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

DMR Functions to know Level position in hierarchy

Started by Meandcognos, 15 Nov 2016 11:31:06 PM

Previous topic - Next topic

Meandcognos

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

MFGF

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.
Meep!

Meandcognos

Your advise work for me :) :) .....Thanks MFGF  :) :)