TM1 Forum

Hi,

Thanks a lot...

Its working now Used to_char and to_number function...


Regards,

Monisha

Hi, While loading the values from oracle, the TI process is showing following error. "Forecast","25000.","Other","FY2010-P01","4000.",Data Source line (11) Error: Data procedure line (3): Cell type is string. Here 25000 is data.. rest all are element...

Hi,

I wanted to know whether we can get the difference between two dates in terms of months.( as we can do in oracle and all).
If not please tell me how to do it.


regards,

Monisha

Hi, Its working now. Thanks to all. In the formula bar the value of the cell was coming truncated. For eg: If the cell had "frozen & fresh food", in the formula bar it was showing only "Frozen &". I removed all these kind of cells and retyped. It got corrected then. Once ...

Hi, I tried to attach the screenshot of my excel perspective but i am not able to. I am using TM1 9.5. In the excel perspective there is a tab called devoloper. In that Dimension create , Dmesion Open and Dimension Save options are there. When we use Dimension create option an excel sheet named *.xd...

Hi, I am using TM1 Excel perspective. In Excel perspective I tried to create dimension. That dimension had 670 elements + Consolidations in it. Its Showing error, " Error in creating line 376<"","",""> I thought there is some syntax error in my consolidation , but ...

Hi,

I am loading dimensional elements through excel. Total 690 elements are there. I am not able to load the elements from line 376.

Pls tell me a soln to load entire elements through excel .


Regards,

Monisha.

Hi,

I am getting connected to TM1 Excel pesrpective when simply I am opening an excel 2007 file.

Pls help me to resolve this issue.


Regards,
Monisha

Hi, Prolog: NumericSessionVariable('a'); NumericSessionVariable('b'); NumericSessionVariable('c'); StringSessionVariable('d'); Epilog: b=ELCOMPN('dim','Consolidation'); Metadata: While(b<1); d=ELCOMP('dim,'Consloidation,b); a=if(dayno(today)-Dayno (ATTRS('dim',d,'StartDate'))>366, 1,0); If(a=0); Dim...

Thanks to All . Its working now

Hi, I tried using TI process. But its showing error : "StoreA","1 Quarter","France","1.",Data Source line (1) Error: MetaData procedure line (9): Unable to delete element "StoreA" from consolidation. Pls tell why its not able to delete?? Regards, Mon...

Hi, Actually the description is like this: Child A is in "New" Consloidation No elements are there in "Old" Consolidation. A condition is there which include substraction of start date of "A Company" And Current date. If this value is greater than 366 then Child A is to...

Hi,

There is an if condition, if this condition is true then an element is to be shifted from one consolidated element to another consolidated element which is in the same dimension.

Can anyone pls tell how to do it using rule editor.

Thanks

Monisha