Hi ,
Actually similar kind of requirement was solved in Cognos community,but was not able to open those sample report.Could some one help me on this .
I use Cognos 8.1 and DMR model. I pass DMR based Year dimension from one report to another and want to identify which level of hierarchy was passed to target report.
I was able to other parameters like product,order type to target report as parameters ,but when we drill down on Year ->Month->Week->Day not able to pass particular level to target report ..
During search i found these expression in cognos forum
Source Report :
<dataItem name="LevelNumber"><expression>roleValue('_levelNumber', currentMember([Product forecast].[Product].[Product]))</expression></dataItem><dataItem name="LevelName"><expression>rolevalue('_levelName',currentMember([Product forecast].[Product].[Product]))</expression></dataItem>
They have created these data items in source report ,so i did the same ...
Coming to target report we should create parameters so that we can pass above data items right ,here i am facing problem to create parameters in target report.
<dataItem name="Level Number"><expression>?LvlNum?</expression></dataItem><dataItem name="LevelName"><expression>?LvlNm?</expression></dataItem>
I have created above parameters but in source report not able to link as these are not visible in source report.
As i am using cognos 8.1 was unable to open the sample reports i found in community .Could some one guide me to create parameters in target report.
I have attached the 2 reports in one doc ...
Any other methods to get the desired result ,plz suggest me
Thanks,
Suresh.k