Skip to Content
avatar image
Former Member

Analysis Office - New cells with excel formula

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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,


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17, 2018 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

    Add comment
    10|10000 characters needed characters exceeded