Hi All,
I am using BPC 10 and trying to do filtering with excel.
Roberto had suggested me a solution but it is only applicable for BPC 7.5
Link: [Reload data into excel with user's filtering input;
I have manage to find the replacement for EVCVW, but am still struggle on finding the replacement for pagekeyrange.
I also researched on EPMCellRanges. It might be useful but it wouldn't be applicable as refer to Roberto's suggestion.
Can anyone please advise me on the replacement of pagekeyrange for BPC 10?
Regards,
Kang
-
Attached Roberto reply.
Hi Kang,
sorry but I don't know the BPC 10 so if it's different you must translate from 7.5 (f.e. i don't know "EPMContextMember").
What you mean is put a parameter for my dimension entity eg. company = CV_Entity ?
no, give a name on the cell that contain the EV_CVW
Then put the parameter into EVCVW E.G. =EVCVW(application,CV_Entity) ?
no, EVCVW(application,=link to the entity dim (the name entity) in the pagekeyrange area)
then put the value of the entity dimension with "=CV_Entity" eg. =EVRNG(=CV_Entity) ?
no, put in the entity value cell of the pagekeyrange area the string "=CV_Entity", so the entity value will change automatically when you change the parameter.
Kind regards
Roberto