AtharvaKabade
3 days agoNew Contributor
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?