Month Lookup Cube ?

[youngjedi]

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

[asutcliffe]

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

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?

[JDLove]

I would possibly use a TI process, you may benefit from a Date Lookup cube depending on your dimensionality.

[mattgoff]

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

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.

Matt

[youngjedi]

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

[asutcliffe]

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

Perhaps it might help if you post details of the relevant existing dimensions and cubes?