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.
I think you might be wanting the filter() function, which you can apply to the data item in your query.
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.
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'