Skip to Content

Direct link to cell in a dynamic report

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 15, 2018 at 02:27 PM

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

    Add comment
    10|10000 characters needed characters exceeded