Skip to Content
avatar image
Former Member

Sorting based on a custom dimension in AO 2.2

Here is a question i didn't yet find an answer to.

I have the Time dimension which is uniquely sorted based on a particular fiscal year format. However, i wanted the ability to sort based on calendar year format. Since each member of the time hierarchy is tied to a key (as per the fiscal year format), even if i "break hierarchies", it does not sort it in proper order.

So i thought, lets add a custom dimension where, i would manipulate the keys (using excel formulas) and then sort the whole table using this new custom dimension. However, there is no such sorting option available.

Please note: this sorting needs to be done at the AO level only (not below).

Is there any way to achieve this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 14, 2016 at 09:44 AM

    You are right; this can't be done in Analysis Office

    Can you go back to the BEx Query and reformat the time dimension there?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Tammy. The thing is a lot of other workbooks are dependent on this BW Query that do not need sorting this way.

      Not even by using Excel macros?

  • Nov 14, 2016 at 11:27 AM

    Utkarsha - I am not an Excel macro expert; but I know future versions of Analysis Office 2.4 will further support formulas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Tammy. Support formulas, as in if we add a custom column, will it be able to sort the entire table? Do you think you know about that?