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

Starting Period and ending period has to display in the header

Started by Kalyan cognoise, 01 Nov 2009 05:50:39 AM

Previous topic - Next topic

Kalyan cognoise

Hi All,

I have one issue with the dates(data is comming from Dimesional tables(cube data), regardless of whatever user selected level(Year,Quarter,Month) it should show the start of the Quarter (means Month level).Suppose if user selected for QTR 2 2009 it should show the 2009 Apr or if user selected the year it should show 2009 Jan.Same thing I have to apply for ending date also.

I have Hierarchy like Dates->Year(2009...)->QTR 1 2009->Jan 09...
I have tried by using openingPeriod and closingPeriod functions, but I don't know where I have done mistake.
Please send me proper solution if anyone knows....