Dimensional filter on attribute

[Deep750]

Hi,
I have a report, where I am in need of filtering out/including based on an attribute, on the lowest level in a hierarchy, based on selection in a prompt. How can these exoressions be if I wan't to do it in a dimensional manner?

If I hade done it against a relational source, I wold have added two filters, and it would be something like:
exclude:
[PATH] NOT IN (?P_ex?)

and
just to just show:
[PATH] IN (?P_inc?)



The report is using a Dynamic Cubes as source.

[bdbits]

I think you might be wanting the filter() function, which you can apply to the data item in your query.

[Deep750]

Hi,
I have tried solving this with Filter()-function, but I haven't been able to solve it.
My requirement is to filter on two dimensions, Job and Project.

Code Select Expand




CASE
WHEN #prompt ('P_Inc_Oppfolgingskategori', 'string',  '''02''' )# = '01'
THEN
filter(([B7 Andre kostnader]);
[DC].[Dim Project].[Project].[Project].[Oppfølgingskategori] = '01'
or
[DC].[Dim Job].[Job].[Job].[Oppfølgingskategori] = '01'
)

WHEN #prompt ('P_Ex_Oppfolgingskategori', 'string', '''02''')# = '01'
THEN
filter(([B7 Andre kostnader]); 
[DC].[Dim Project].[Project].[Project].[Oppfølgingskategori] <> '01'
or
[DC].[Dim Job].[Job].[Job].[Oppfølgingskategori] <> '01'
)

ELSE
([B7 Andre kostnader])
END

If I choose the first condition, 'P_Inc_Oppfolgingskategori' = '01', it doesn't show anything
If I choose the second condtion, 'P_Ex_Oppfolgingskategori' = '01', it shows all

despite there are data on [Oppfølgingskategori] 01'