Skip to Content

Analysis Office - New cells with excel formula

Aug 17, 2017 at 05:04 AM


avatar image
Former Member

Hi All,

Am using Analysis for Office 2.4 and Excel 2013.We have a strange issue for below scenario.

1. Inserting New line juts after the dimensions.

2. Fill it with a very simple excel formula ex: referencing the member of dimension in column A1.

3. Using 'drag' option to copy the formula to all cells of a newly created column.

I am expecting the other cells of a column should refer to the correcting value of Dimension member like from A2, A3, A4 etc.. But it actually copying A1 value to all cells of newly created formula.

I do not have this issue if I create a excel formula using 'Measures' in Analysis Office.

It exists only with 'Members' data both key and text.

Please advice, is it a known issue with Analysis Office or am I missing anything here?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Venkata Subhash Medisetty
Aug 17, 2017 at 04:18 PM

Hi Reshma,

i believe formulas can be used only for Key figures not for dimensions

anyway, i tried to create formula for dimension, i am not able to even drag & drop

Thanks & regards,


10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 17 at 10:31 PM


You need to choose the end of the dimensions column and Click on new Cell /New Column and populate it with formula...

Iam still facing the same issue as Reshma is facing.. any clue to get over it? in AO 2.3

10 |10000 characters needed characters left characters exceeded