Linking data from 2 diff. cubes for drill down(listed in 2 seperate cross tabs)

[siyad]

Hi All,

I am using Cognos 10.1 with TM1 cubes for report studio

I have 2 cross tabs and the data coming from 2 different cubes for the cross tab. Now I want to allow the drill down/up for both of the cross tab with the cross tab node using one of the cross tab. ie:- if user clicks one cross tab the other one also needs to be drill down 'ed. The cross tab nodes of both members are coming from same dimension, but the MUN is different becasue of the cube. I have tried to create the data item used in the cross tab node(drill up/down needed column) with caption and added into the data item linking, but I have got a mulitpe cube errror(XQE-GEN-0006 Feature not yet supported: 'Multiple cubes in MDX')

Anybody for a crack on this

Thanks in advance

[adik]

as far as I know you can't do this. they are two different cubes and cognos treats them as such.

[siyad]

Thanks Adi for your interest in answering here.

I would have appreciated if you have not replied for this post when you are not aware of a possible solution. A '0' reply for a post have more chance to get more viewers and hence to work around from some of the gurus of this group

[siyad]

Any other suggestion from Cognos gurus

[Lynn]

I'm not sure I agree with you about 0 reply having greater chance to be read. The moderators on this site are outstanding and they review pretty much everything eventually. I generally read most everything regardless of how many replies there are. I see lots of people besides me replying to posts that already have replies offering an alternate approach or opinion.

I think the opinion that it can't be done is something to consider in terms of deciding how much time to spend working on a requirement.

Lastly, responses keep your topic high on list so you don't risk scrolling off and getting ignored.

Just my 2 cents.

[siyad]

ouch...that is a new information for me and I am changing my opinion here. I have to completely agree that the moderators in this site and some of the gurus like you are also excellent. Thanks for your 2 cents Lynn

[CognosPaul]

I do see most posts. What little free time I've had before has been almost completely taken up recently. This means that I'm not able to respond to most posts. Fortunately we have trains, and with trains comes delays. And delays means more free time!

Unfortunately there is no way to share a drill down between two cubes. It's just not possible. It's the same reason you can't join them together in a single query. Instead of using a drilldown, try creating a self drill through. Pass the business key, not the mun. Find the member in question using the filter function, and then wrap that in descendants.

It should look something like, in each query:

descendants(filter([Cube].[Dim].[Hier],roleValue('_businessKey',currentMember([Cube].[Dim].[Hier])) = #prompt('HierKey','string')#),1)

[adik]

hi syiad,
i just now saw your reply to my post. sorry my answer disturbed your thread, i tought you were in search of an answer, not in search of an answer from a specific person (in this case you should have written to that person directly).

[siyad]

Thanks Paul for your prompt answer, as usual

[siyad]

Adi,

Please dont be offended ... I was on the impression that a reply would take off the post from forum users eyesight

cheers mate