Hi,

I need to stack two dimensions. The two dimensions have equal valuelabels
I tried it using a union:

Select UNION({[q10_4].members},{[q10_4].members},ALL) on rows,

{[Group].[(All)].Members,

[Group].[All Group].Children} on columns

From [Survey 12345]

This works because I used q10_4 two times. I can't use different dimensions
here.


It in NO option to create a new dimension containing the dimensions I want
to stack, because it is the choice of the end-user which dimensions to
stack.
I think this is the main problem: The user can choose it's dimensions
"runtime".

Does anybody have a solution?



Thanks is advance,



Oliver

In your example you are trying to union a set with itself. I'm not clear why
you would want this, or what result you seek.

public @ the domain below
www.tomchester.net

"Free like a bird" <otalens (AT) hotmail (DOT) com> wrote

Ok, perhaps a bad example. I was able to union a set with itself, but I want
to do this using two different dimensions.
As a result I want to see dimension X in the columns and dimensions Y and Z
stacked in the rows.

For example

All Gender F M
All Marital Status 10 4 6
Married 6 2 4
Single 4 2 2
All Education 10 3 7
Bachelor 4 1 3
Graduate 3 1 2
High School 3 1 2
...

So I want Education displayed on the same 'level' as Martital Status.

I also want to be able to stack the columns instead on stacking om the rows
as in this example.
When composing the cube, I don't know which dimensions will be stacked and
which won't. The solution must me "run-time"

Thanks in advance, I appreciate your help.


Oliver


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

I won't go so far as to say it's not doable, but it's probably not feasible.
(I suppose a kludge could be crafted if the number of possible combinations,
and member counts, were managable.)

Depending if your front-end is customizable, you could do 2 separate queries
and stack the results.

public @ the domain below
www.tomchester.net

"Free like a bird" <otalens (AT) hotmail (DOT) com> wrote

Ok, too bad, but thanks anyway

Oliver

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

One way to do it would be

Union( CrossJoin( set from marital statuses, {[All Educations]} ),
CrossJoin( {[All Marital Statuses]}, set from education ) )

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"Free like a bird" <otalens (AT) hotmail (DOT) com> wrote