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