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

Time dim in dimensional Reporting

Started by cognos05, 29 Apr 2015 04:06:01 PM

Previous topic - Next topic

cognos05

Hi,

I have a member 2015 and its children has 12 months , july 2014- Jun 2015

I dont have Q1, Q2,Q3 and Q4 in my model ,but for reporting I need to show the quarters.

How do I achieve this,

I will have four data items Q1 , Q2, Q3 and Q4
What should the calculation of Q1 be ?
lastperiods(children([2015]) ---something like this..Any suggestions


Thanks,
Nithya

godawgs85

Quote from: nithya1224 on 29 Apr 2015 04:06:01 PM
Hi,

I have a member 2015 and its children has 12 months , july 2014- Jun 2015

I dont have Q1, Q2,Q3 and Q4 in my model ,but for reporting I need to show the quarters.

How do I achieve this,

I will have four data items Q1 , Q2, Q3 and Q4
What should the calculation of Q1 be ?
lastperiods(children([2015]) ---something like this..Any suggestions


Thanks,
Nithya

I'm confused as to why you would have months in 2014 under a year member of 2015, but if this is truly the case, you could achieve as follows:

lastPeriods (3,item(descendants([2015],[Cube].[Hiearchy].[Level].[Month Level]),2))

This would give you July- Sept 2014 given your breakdown above.  Hope this helps.

cognos05

Thanks godawgs85,

I will check if this would work. Mine is a fiscal year so Fy 2015 will have months from jul 2014 to jun 2015.

Thanks,