TM1 Forum

Hi TM1 gurus,

I have a cube with one of the dimension with one element which is a date(May 31, 2010). This will be update constantly every month i.e it will change to June 31, 2010. I have created an excel application by slicing the cube and uploading it to application folder. How can i make the excel application constantly updated when ever the month changes.

Thanks
Daya

daya007 wrote: I have a cube with one of the dimension with one element which is a date(May 31, 2010). This will be update constantly every month i.e it will change to June 31, 2010. I have created an excel application by slicing the cube and uploading it to application folder. How can i make the excel application constantly updated when ever the month changes.

Using a calendar might be a good start, given that June has only 30 days...

Aside from that two possible ways are:
(a) Have a public subset defined as something like "Current Month", and have an automatically scheduled TI update that subset each week / month / however often you need. You can then use a SubNm formula pointing to that subset. We use that approach for a number of our subsets which are time-related. Or
(b) Have a Dates lookup cube which will allow the worksheet to look up the month corresponding to the current date. You can use standard Excel date / text formulas to drive a DBR formula in the worksheet.

thank you Alan.