BPC input template including multiple models

[former_member970690]

I have an input form with 5 worksheets. Each worksheet contains a report from a different model. (e.g. level_01, level_02...).

Is it possible for each worksheet to recognize the same dimensions from the context when I open the input template ?

(e.g. have the same country and version on all worksheets).

Before you advise to put them in different input sheets... I can't. It must be like this.

Thanks,

Balázs

[former_member751591]

Thank you for asking a question in the SAP Community! Your question is very important to us. It would be helpful for you to take the Community Tutorial which provides tips for preparing questions that draw the best responses from our members. Plus, by organizing your Community profile using Profile Tutorial you will encourage more readers to respond to your questions!

Thank you!

[johnnbc · Accepted solution]

Instead of setting context members couldn't you have a master sheet and then override the dimensions in the reports with the values in the master sheet? Otherwise you would need them to change all the context's in each model to be the same - either manually or programmatically

[former_member970690]

Thanks all for the hints!

Finally I could solve it with EPMDimensionOverride()

[former_member186338]

You can link your page axis (or other axis) member using Excel link to another report. Easy solution.