Two Different Dimensions-Hierarchy and One Data Item - OLAP-RPT 10.1.2

[gosoccer]

Hi everybody,
:( :'(
I have a simple question?
I have the following
DIMENSION 1
HIERARCHY 1
LEVEL         Login, Logout

DIMENSION 2
HIERARCHY 2
LEVEL         Work Address, Home Address

So therefore, after cube generation in the Report Author I have the following,
DIMENSION 1
HIERARCHY 1
LEVEL/Members        Login, Logout

DIMENSION 2
HIERARCHY 2
LEVEL/Members         Work Address, Home Address

Now, all I need to do is to create a new Data Item can have the members from first and second DIMENSIONS together as a "Set of Members" so I can drop it as a part of the Edge of a Scrollbar.

I have tried linkMember and Union none is working since the levels are in two different Dimensions.

There has to be a trick to make my life easier!!!

Thank you in advance for your time.

[gosoccer]

Not a Scrollbar but a Crosstab!!

[karthik.kadambi]

Is this what your looking for?

tuple (currentMember(Hierarchy1),currentMember(Hierarchy2),Measure)?

[MFGF]

Hi everybody,
:( :'(
I have a simple question?
I have the following
DIMENSION 1
HIERARCHY 1
LEVEL         Login, Logout

DIMENSION 2
HIERARCHY 2
LEVEL         Work Address, Home Address

So therefore, after cube generation in the Report Author I have the following,
DIMENSION 1
HIERARCHY 1
LEVEL/Members        Login, Logout

DIMENSION 2
HIERARCHY 2
LEVEL/Members         Work Address, Home Address

Now, all I need to do is to create a new Data Item can have the members from first and second DIMENSIONS together as a "Set of Members" so I can drop it as a part of the Edge of a Scrollbar.

I have tried linkMember and Union none is working since the levels are in two different Dimensions.

There has to be a trick to make my life easier!!!

Thank you in advance for your time.

Hi,

You can't mix members from different hierarchies in the same set. You can stack them but you can't make it a single set.

Cheers!

MF.

[gosoccer]

Karthik,

I'll try the tuple. I finally decided to fix the issue at SQL level. I changed the SQL to have both members to be populated in the same
column and re-generate the cube. Now the Set of Members include all the necessary members that can be populated and sorted accordingly.

Thank you in advance for your time. Thank you MF.