Forum Discussion

AtharvaKabade's avatar
AtharvaKabade
New Contributor
3 days ago

How to filter Specific Columns in Cube View Report Output Using FDX ?

I have a Cube View that displays Multiple bas members (for example: Tokyo, Osaka, Berlin and Munich) as columns.
When I click on the Report button, the report currently includes all four columns which matches my cube view setup. 

However, I want to customize the report output so that it only include few selected columns (for example Tokyo and Berlin) while still showing all four columns in the Cube View itself.

I want to achieve this using an FDX functions.

My questions:

Which BR type should I use for this requirement?

How can I apply column level filtering in the FDX rule so that only selected base members appear in the report output, while keeping all members visible in the Cube view?

 

No RepliesBe the first to reply