How to change multiple Reports within one Workbook at once

[Former Member]

Hello

We have a  epm Workbook with multible reports and input forms. How is It possible to change i.e. the entity dimension for all Reports / Input Forms at the same time? I think "edit" is not the most efficient way. thanks for your help

regards

stephen

[former_member186338]

Not clear!

You can have ENTITY based on context

You can use Excel links

...

Please explain you requirements using some test sample

[Former Member]

we select all dimension by edit report, so epm context pane is not in use...

I try to make it clear.

we have two reports in one workbook - I want to change i.e. entity an all reports should apply this change.

[former_member186338]

Sorry, but still not clear!

Do you have entity in page axis or row/column axis?

Provide test screenshot!

P.S. There is no magic solution for all types of reports

[Former Member]

in this case, entity is in row axix...

[former_member186338]

You can use EPMDimensionOverride in the second report,

You can use VBA code to play with dimension members...

Please show report sample!

[akos_beres]

As Vadim says, use the dimension override ... here is a video on how to use it:

https://wiki.scn.sap.com/wiki/download/attachments/281281278/Dynamic_Filters.mp4?original_fqdn=wiki....

Hope this helps!

Akos

[akos_beres]

As mentioned earlier by Vadim, you can also make your page axis selection in the row axis linked to context like:

[former_member186338]

"epm context pane is not in use"

Anyway the requirements are still not clear