TM1 Forum

Hi All, I have a report with multiple reports incorporated in every button. When i click a button and open in PAW(TM1 web) it opens another report and it works fine . When i open the same report in Perspectives (from Architect-Applications) it opens with the tm1xl error attached . TM1XL Error.PNG th...

Hi All, My Data flow DB -> TM1 -> DB Date - > String -> Date Issue Format : 2021-12-31 In the final "Cube view to Table load" process , I have a insert statement in which i am sending Date column without conversion , which throws an following error . "S1000[Oracle][ODBC][Ora]ORA-01861...

All columns mentioned are from same "Measure" dimension .
Sum If function inside TI process is not working.

Inv % column is my result column and mentioned formula is the one i am trying out.

It's a Measure dimension.

Cube has total of 5 dims where "Item" is Row dimension set and "Measure" is Column dimension

Hi All, I got a requirement of SUMIF calculation to be done in TI process as below , For Eg: Column A | Column B | Column C | Column D India | 5 |10 | Calculated Value SG | 10 | 20 | Calculated Value SG | 10 | 25 | Calculated Value India | 45 | 15 | Calculated Value Column D(Calculation formula) = (...

Thanks @lotsaram and @declanr !

It worked

Hi All, Base Table - ABC Source Table - XYZ Cube - Product Dimension - PROD Table : ABC PROD | Measure ______________ Car | 2000 Bike | 1000 Cycle | 500 ----------------- Table : XYZ PROD | Measure ______________ Car | 2000 Bike | 1000 Car | 3000 Car | 2000 ----------------- I have a TI Process to l...

Thanks tom, I understand attributes cube is no different . My question is how can i replace an alias column values through TI process . i tried DimensionElementInsert DimensionElementComponentAdd but when i do this i get "Error: MetaData procedure line (43): Dimension element name "Hyundai...

Hi All, I am trying to delete or replace existing attribute's(alias name) data from }ElementAttributes cube and insert new attribute element from DB view. My Element attributes cube looks like below : | }ElementAttributes_DIM | ----------------------- | Desc | Code(Alias) | Brand_Code | Pr_Desc | Ye...

Thank you so much Declan for inputs! Based on your code, i got the exact result and output looks good.

Hi All, Good day. Could you ppl help me to separate country name from a string(column). Say i have 1000 rows in country column , each row has its code and country name with "-" separated. Some has single "-" & some has "-"*"-" like eg:1 Please see the foll...