Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 14 Aug 2014 02:00:17 PM

Title: Two Different Dimensions-Hierarchy and One Data Item - OLAP-RPT 10.1.2
Post by: gosoccer on 14 Aug 2014 02:00:17 PM
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.
Title: Re: Two Different Dimensions-Hierarchy and One Data Item - OLAP-RPT 10.1.2
Post by: gosoccer on 14 Aug 2014 02:01:21 PM
Not a Scrollbar but a Crosstab!!
Title: Re: Two Different Dimensions-Hierarchy and One Data Item - OLAP-RPT 10.1.2
Post by: karthik.kadambi on 16 Aug 2014 06:47:03 PM
Is this what your looking for?

tuple (currentMember(Hierarchy1),currentMember(Hierarchy2),Measure)?
Title: Re: Two Different Dimensions-Hierarchy and One Data Item - OLAP-RPT 10.1.2
Post by: MFGF on 17 Aug 2014 05:43:38 AM
Quote from: gosoccer on 14 Aug 2014 02:00:17 PM
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.
Title: Re: Two Different Dimensions-Hierarchy and One Data Item - OLAP-RPT 10.1.2
Post by: gosoccer on 18 Aug 2014 10:27:39 AM
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.
Text only | Text with Images