Skip to Content
0
Former Member
Oct 28, 2013 at 05:21 PM

EPM - Sharing Dimensions over Multiple Sheets

157 Views

Hello Experts,

I have a question about building reports in Excel with the EPM Add-in. Is it possible to Share Axis' over multiple sheets? I have done it on one sheet before. My example is we have a workbook with multiple Reports for different entities on their own tab(sheet) within the workbook. The reports are all the same structure. Once a month, an update is needed to be made to the TIME Dimension. Currently, we have to update each individual report. I was hoping there is a way to link them or share an axis so one update could update multiple reports in the same workbook. Any ideas would be great.

Thanks,

Sean