cancel
Showing results for 
Search instead for 
Did you mean: 

BPC input template including multiple models

former_member970690
Discoverer
0 Kudos

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
Participant
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

johnnbc
Explorer
0 Kudos

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

Answers (2)

Answers (2)

former_member970690
Discoverer
0 Kudos

Thanks all for the hints!

Finally I could solve it with EPMDimensionOverride()

former_member186338
Active Contributor
0 Kudos

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