Hi All,
I am using Cognos 10.2.2, data source is SSAS cube, i have a requirement to do drill through from Master visualization treemap chart report to detail bar chart report. Where I have to pass mun, when I click on a visualization treemap chart box item.
So, I have created Level data item with below expression, which is a treemap chart box item. Which will have MUN's in it.
Master Report, Level MUNs data item expression below.
roleValue('_memberUniqueName', descendants(
#prompt('p_Org','mun','[Labor].[Org Hierarchy].[Hierarchy].[(All)]')#
, #prompt('p_Anlys_Lvl','token','[Labor].[Org Hierarchy].[Hierarchy].[Org Level 6]')#
))
Target Report, Lvl Dsply data item expression below.
#prompt('p_Org', 'memberuniquename', '[Labor].[Org Hierarchy].[Hierarchy].[(All)]->:[M14].[Org Hierarchy].[Hierarchy].[All]', 'set(','',')')#
In the drill through definition target parameter name is 'p_Org', type is memberUniqueName , Method - Pass data item value
Source Value is 'Level MUNs' data item, property to pass Member Unique Name. If I don't provide any default value in my Target Report Lvl Dsply data item then, when I click on the drill through I am getting below error.
QE-DEF-0482
Cannot parse any empty expression
The problem, here I am facing is whatever value I click on the visualization chart, MUN is not getting passed. Whatever default value is present in the target chart report, report is getting executed for that one only. What could be the reason, why my data item value is not getting passed? Can some one please suggest on the same.
Thanks & Regards,
XYZ