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
Quote from: Shamar on 31 Dec 2015 01:32:55 AM
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.
just a side question MFGF,
can we incorporate something like this?
#prompt('parameter', 'memberuniquename')#
Quote from: sdf on 06 Jan 2016 01:00:34 AM
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.
aye! Thanks!