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