Repeat Block for each Product in Report SAP BPC7.5NW SP10

[Former Member]

Hi Gurus,

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 ID	Account Type Desc	Product Desc	Curr Desc	2012.JAN (COL)	2012.FEB(COL)...
EUR	AFRT1	LPRICEY	Africa 1	Euro	10	40
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.

Thanks,

Abhishek Khatti

[Former Member]

Finally figured it out. Just had to move around Product and Currency in the Expansion Memberset. Instead of keeping currency first, changed to reflect the following.

ExpandIn	ROW	ROW
Dimension	PRODUCT	INPUTCURRENCY
MemberSet	REGION=Africa	Yearly Ip!$P$25:$CF$27
BeforeRange
AfterRange		Yearly Ip!$P$28:$CG$28
Suppress
Insert

where Memberset for Input Currency is the block that needs to be repeated. Keeping one of the Currency member at the start of the block. So at the end, kind of Block Suppression worked.

Thanks,

Abhishek