Skip to Content

Direct link to cell in a dynamic report

Feb 15 at 02:03 PM


avatar image

Hi Experts,

I'm looking for a solution how to create a direct link (cell to cell) in a dynamic report.

I have two twin reports. First one with data and second one has a formula in cells which was added to data area via EPMCopyRange function.

C_ACCT dimension has Base Level accounts below 101010000 in Rows with several exeptions (101030000 - 101050000).

Below you can see how cells are linked among. Formula R[-7]C.

If the list of base level accounts will be added by new accounts formula link will be on another cell.

On screenshot below I have left only base level and as I assumed before, link works fine but for another cell.

Do anybody have some suggestions how to make a cell to cell link in that case.Or is it possible only with VBA?

EPM Plug-in for Microsoft Office

SAP Business Objects Planning and Consolidation NW v 10.1 (Standard)

Thank you,


01.jpg (56.2 kB)
02.jpg (56.5 kB)
03.jpg (69.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Feb 15 at 02:27 PM

Sorry, but after reading your question 3 times I am unable to understand what do you want to achieve!

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim,

on second screenshot you can see how cells are linked. Direct link as R[-7]С. First cell in data area of the second report should be linked with first cell of first report. When I've added few accounts to C_ACCT the number of rows increased. After that formula still the same R[-7]С but now first cell of second report shows data of fourth cell of first report. Hope that description makes my question more clearly.

So is it real to make that links like that in dynamic structure without VBA?

Alexander Keshishian

Still absolutely not clear! Please explain once again...


Difficult to explain. Thanks.

Actually I found a way how to realize it. Will be updated asap.