TM1 Forum

Yeah, I tried changing the format in excel but no use.

Hi I have a cube1 which pulls data from a file and then User inputs/edits some data manually in Excel. The DATE comes in the format of YYYYMMDD from the file but has to be shown in the Cube in the format MM/DD/YYYY We used the substring to display it in the required format Now, the issue that we are...

Thanks for the quick response.. However, the issue is that we do not have a TIME dimension in this cube... ofcourse, we are capturing the dates for the records but there is no specific time dimension... and it is not possible to insert the time dimension too Could you please suggest me if there is a...

Hi..

Consider the scenario
cash Paid out for Sept'10 = 200 $
Now I would like to retain this value as Previous Month Cash paid once the Month changes to Oct.

I cannot go for the calculations again becoz the values will be different.

Can someone help me out...

Thanks

Hi

I am trying to capture the date and month of a status change.

Here i have two fields under measures Order Status and Change Date.
I should be able to capture the date and month of the order status change from Active to Inactive.
Can someone help me with it

thanks
Ravi