Skip to Content
0
Former Member
Jul 28, 2016 at 09:01 PM

2000 Member for EPMDimensionOverride Function

26 Views

Dear BPC Friends,

I am building a report in BPC 10.1 (Standard) NW. The report has two sheets (i.e Sheet 1 & Sheet 2).

Sheet 1 has Cost_Center (Base Member) in Row and Time and Category in Column. This also has drop down column of YES/NO (next to Cost_Center dimension). This column is used to select any Cost_Center that the user want to pull in Sheet 2 report.

Sheet 2 has Cost_Center and Account in Row and Time and Category in Column. The Cost_Center member will come from drop down column in Sheet 1 and Account dimension has fixed members.

The Cost_Center expansion (in Sheet 2) has be written using EPMDimensionoverride function.

The problem is - The user can select one Cost_Center or all Cost_Center (aprox 3000 Cost Centers). If the user want to select 2000 Cost Center then the challenge how to pull 2000 members in Cost_Center EPMDimensionoverride function.

Kindly Advice,

Rahul