Reporting on cube with Year & Month dimensions

Post Reply
JDLove
Posts: 49
Joined: Thu May 21, 2009 1:16 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Reporting on cube with Year & Month dimensions

Post by JDLove »

How can we combine (Year, Month) dimensions into a single time dimension for BI reports within the Reporting environment that is fully functional?
Cognos Express 10.1

Thanks
JD
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Reporting on cube with Year & Month dimensions

Post by lotsaram »

JDLove wrote:How can we combine (Year, Month) dimensions into a single time dimension for BI reports within the Reporting environment that is fully functional?
Cognos Express 10.1

Thanks
JD
Define what you mean by "fully functional"? I do this via adding a 3rd "time measure" dimension in addition to year and month and having rules calculate all lookups from a fixed reference. All the lookup measures are C so ther is no feeder overhead. See here for a full description. Works for me.
Post Reply