Skip to Content
0

Sorting based on a custom dimension in AO 2.2

Nov 11, 2016 at 11:56 AM

120

avatar image
Former Member

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?

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

2 Answers

Tammy Powlas
Nov 14, 2016 at 09:44 AM
0

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?

Show 1 Share
10 |10000 characters needed characters left 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?

0
Tammy Powlas
Nov 14, 2016 at 11:27 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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?

0