COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Meandcognos on 15 Nov 2016 11:31:06 PM

Title: DMR Functions to know Level position in hierarchy
Post by: Meandcognos on 15 Nov 2016 11:31:06 PM
Hi Gurus,

How to know position of 'LEVL'  in time hierarchy while drill up and drill down functionality over the report?

example : While performing  drill down in time dimension then know the level position.

Year level should be 1, Quarter should be 2 , month should be 3 like that....

Time Dim

Year   
Quarter
Month
Week
days
Title: Re: DMR Functions to know Level position in hierarchy
Post by: MFGF on 16 Nov 2016 08:42:23 AM
Quote from: Meandcognos on 15 Nov 2016 11:31:06 PM
Hi Gurus,

How to know position of 'LEVL'  in time hierarchy while drill up and drill down functionality over the report?

example : While performing  drill down in time dimension then know the level position.

Year level should be 1, Quarter should be 2 , month should be 3 like that....

Time Dim

Year   
Quarter
Month
Week
days

Hi,

The below post shows how you can calculate the level you have drilled down to:

http://www.cognoise.com/index.php/topic,19458.msg76382.html#msg76382

Cheers!

MF.
Title: Re: DMR Functions to know Level position in hierarchy
Post by: Meandcognos on 19 Nov 2016 09:33:04 PM
Your advise work for me :) :) .....Thanks MFGF  :) :)