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
Reporting on cube with Year & Month dimensions
-
- 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
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.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