"Selective" Report

[#1]

All,

Is it possible to make a report in Q-Sense that uses only a few elements of a dimension?

For example of my 'general ledger'-dimension only the account 700000 and 700001 without using a filter on this dimension.

Thank you

W.

[arulsettu]

may be your 'general ledger' is like this

700000

700001

700002

700003

700004

700005

and you want to see only 700000 and 700001

try like this in your dimension

if(match('general ledger','700000','700001'),'general ledger')

[Gysbert_Wassenaar]

Yes, that's possible. As Arul points out above you can use a calculated dimension. You could also change create it as a new field in the script and use that as dimension. And if you use an chart that has measures you could change the measure expressions to filter the accounts. For example Sum(Amount) would become Sum({<Account={700000,700001}>}Amount).

[#4]

This formula gives me the account 700000 and 700001 but the other accounts are still in the report.

The report that I want to build:

Account 700000

blank

Account 700001 +700003

blank

Account  700005

Is this possible with a calculated dimension?

Thx

W.

[arulsettu]

can you post some sample qvw along with your expected output..

[#6]

perhaps use APPLYMAP Brief Explanation about Apply map

create an inline mapping load with the accounts you want to list, then use NULL() as the alternative in the APPLYMAP function

[AccountShow]:

MAPPING LOAD * INLINE [

Account, Display

700000, 700000

700001, 700001

];

LOAD

APPLYMAP('AccountShow',Account,NULL()) AS General_Ledger

...