Forum Discussion

benmac360's avatar
benmac360
New Contributor III
12 months ago

Cube View - Return Blank Columns Where No Members Have a Specific Text Value

Hello - I'm working on a cube view that will be used to add variance commentary. The rows have accounts and subtotals, the first column will have a specific entity that will not change, then the next...
Cube View
Reports
db_pdx's avatar
db_pdx
Valued Contributor
12 months ago

Hi benmac: 

For 1, can you share your current memberfilter(s) here?  While it won't insert a blank, a standard E#YourTopEntity.Base.Where(Text1 Contains 'AQ_2024Q1') should properly return the list of entities, and suppress if none meet the metadata criteria.  But I might not be understanding how you have this setup so an example would be helpful.

For 2: will AQ_|WFYear||WFSubPeriod| work for your needs?  I don't have any quarterly workflows, but that works with my monthly workflows.