New Lines in AO referencing wrong cells

[Former Member]

I have AO report on HANA view.  AO Version :  2.3.1.

Entity(col.A) and GL(col.B) are in row and Periods(Col. D & E) in column. We want to add a new line for concatenating Entity and GL as shown in below example. We have added excel Concatenation (col. C)    function to achieve this. But if you see column ENTITY+GL, concatenation function is referring the first row itself, it is not getting dynamically referenced. But if we add a addition type function on keyfigure data ( col. F), it is dynamically referenced

   A                B                        C                             D                     E              F      Desired Results

Entity   GL Account         ENTITY+GL               2016.01          2016.02                                 

1007     0001150910    10070001150910             100                   10           110    10070001150910

1007     0007801100    10070001150910             200                   20           220    10070007801100

1019     0001114300    10070001150910             300                   30           330    10190001114300 

Steps taken to add new line(ENTITY+GL ) :

1. Click on GL Account ( B1), right click-->New Lines --> Column after GL_Account)

2. Blank new line gets added in the report ( Col. C)

3. Click on cell C2, add excel formula =CONCATENATE(A2,B2) , concatenation of first ENTITY and GL is done.

4. Select cell C2, drag down to next two cells below it. Formula gets added to all the cells in the column.

Thanks

[Former Member]

Hi SAP BPC, i am also facing this issue. there seems to be a few bugs in this functionality.

For example when trying to do a Date difference formula i just get a random result, it then populates that result in more than one cell.

[avinashd_m]

Hi,

Can you check the formula in C3 and C4, whether you have following

C3 = CONCATENATE(A3,B3),

C4 = CONCATENATE(A4,B4)

If no , then dragging C2 is not applied the formula correctly to C3 and C4.

Thanks,

Avinash

[Former Member]

Once we drag the formula , it gets referenced to correct cells. But within fraction of seconds, it reference back to the old cell which is applied in the first cell.