Discussing all things TM1, Planning Analytics, PAx and PAW
https://www.tm1forum.com/
Are you using one time dimension? Can't you build in consolidated elements like May-2011 with all the days of May 2011 as children? Then just do your reporting on the consolidated element?youngjedi wrote:I have a user input form where I collect input dates by day (5/12/2011), and for reporting purposes, I would like to consolidate these dates and put them them into a monthly format that looks like May-2011.
I do not need to report by day, just by month. What would be the best way to do this???
Much appreciated
It sounds like the date is a measure, not a dimension, in your cube. If so, you're going to have to build a 2nd cube with either rules or TI linking it to your data entry cube.youngjedi wrote:I have a user input form where I collect input dates by day (5/12/2011), and for reporting purposes, I would like to consolidate these dates and put them them into a monthly format that looks like May-2011.
I do not need to report by day, just by month. What would be the best way to do this???
Perhaps it might help if you post details of the relevant existing dimensions and cubes?youngjedi wrote:To be clear I started with a date dimension that collected the date of input from an Excel user sheet. For reporting purposes I want to roll this into months so I can analyze trends. I was thinking of creating some type of look up cube but I like the idea of adding the monthly/yearly rollups in my existing dimension...