Drill through report between two different cube.

[Shamar]

Hello Gurus!!!

I have 2 reports with 2 different Cubes as source.

Now the client's requirement is to create a drill through report between these two reports.

Is it possible to create a drill through report with different OLAP sources. Please advice.


Thanks,
Shamar

[MFGF]

Hello Gurus!!!

I have 2 reports with 2 different Cubes as source.

Now the client's requirement is to create a drill through report between these two reports.

Is it possible to create a drill through report with different OLAP sources. Please advice.


Thanks,
Shamar

Hi,

Yes, but you need to make sure that the IDs of the members are the same between the two cubes. You also have a big hurdle to overcome - namely that the MUNs (Member Unique Names) within the two cubes will be different. The way to get around this is to pass the member ID in the drillthough, and in the target report have a query calculation that constructs the MUN of the member and prompts for the ID using a prompt macro

eg: #'[Your Cube].[Your Dimension].[Your Hierarchy].[Your Level]->:[Your Cube Technology Identifier].[@MEMBER].[' + prompt('Your Parameter','token') + ']'#

If you can provide the MUN of an existing member in your target report we can be more specific about the syntax above.

Cheers!

MF.

[sdf]

just a side question MFGF,
can we incorporate something like this?

#prompt('parameter', 'memberuniquename')#

[MFGF]

just a side question MFGF,
can we incorporate something like this?

#prompt('parameter', 'memberuniquename')#

The 'memberuniquename' datatype indicates the prompt will return a complete MUN in the parameter, but that's exactly what you don't need here, as the leading parts of the MUNs between the two cubes will be different. You need to use the technique I outlined above to construct the relevant leading part of the MUN, then add the passed value in the parameter to complete the MUN.

Cheers!

MF.

[sdf]

aye! Thanks!