If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to determine level of DMR parameter passed to report?

Started by kajasuresh, 25 Dec 2008 01:13:37 AM

Previous topic - Next topic

kajasuresh

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