TM1 9.4 FP2 - Active Forms - Sort Data

[vaneagle]

Hi All,

Has anyone tried with active forms to sort the data?

By this I mean grouping all apples together, then oranges etc..

like this

apple
apple
apple
oranges
oranges
oranges

Should i be looking to a VBA solution that once the active form has updated, i then go and sort the result of the active form?

These active forms are tricky little suckers as well

Any other ideas suggestions?

vaneagle

[Wim Gielis]

Hello

I'm curious to see why you have multiple times the same element. Normally active forms are used to represent elements out of a dimension, which are unique by default.

Anyway, here's an example of an MDX statement: http://forums.olapforums.com/viewtopic. ... 324&p=7307

You can also use sort functions withing an MDX statement. Plaese see http://www.bihints.com/book/export/html/68 too.

Wim

[vaneagle]

Hi Wim,

In this form it was poor layout on my part, which i have fixed now.

Still learning about these active forms... Getting there though!

thanks for your help!

I am sure I will nedd to use this in the future, so at least i have a reference point!

vaneagle