I am trying to create a report where the Product is based on the selection of Region. I need to expand on the Product to bring the Product IDs as the region is changed. I am using the filter in Memberset of Product as "REGION=&"""<Region_selection_cell>, which is working fine.
Now the challenging part is, for each product, I need to repeat a block. Something like
Region=Africa (Selection from Drop Down)
Part of Row Key Range Descriptions Col Key Range (Account, DataSource, Time)Curr
Product IDAccount Type Desc Product Desc Curr Desc 2012.JAN (COL)
EURAFRT1 LPRICEY Africa 1 Euro
1040 EUR AFRT1 DISCY Africa 1 Euro 20 50 EUR AFRT1 COGSY Africa 1 Euro 30 60 EUR AFRT2 LPRICEY Africa 2 Euro 70 100 EUR AFRT2 DISCY Africa 2 Euro 80 110 EUR AFRT2 COGSY Africa 2 Euro 90 120
where LPRICEY, DISCY, COGSY are just some descriptive texts, not part of any dimension members or dimension properties.
How can I achieve this? I think Block Expansion would not work, since the Product needs to be part of the block and I cannot hard code the Product IDs in that block. Please correct me if I am wrong.
Please let guide what options do I have. I will really appreciate your help.