|
Hello all
I have a need to create an Active form, whereby the (only) row dimension will not be part of the cube in the active form.
Specifically, the dimension is in no cube at all, but is a concatenation of 3 dimensions in the current cube.
In that dimension, I have an MDX expression for a top 10 count.
As far as I know, the top 10 count can not be done on 3 dimensions in the same cube.
So, the 10 best combinations of 3 dimensions - model / quality / colour in a cube to analyze sales of clothes.
Therefore, I created a different dimension to hold the concatenated items and order by sales quantity. Get the 10 best combinations in an MDX, and use that one in the active form.
Mid() functions in Excel can then take out the 3 parts (or I could use attributes, does not matter in the end).
Any help from you?
Thanks in advance!
Wim |
|