Skip to main content
October 16, 2025
Question

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

  • October 16, 2025
  • 0 replies
  • 0 views

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?