TM1 Forum

Hi All, Wonder if someone know how to union 3 elements (or more if needed) in given code? Works with two elements perfect. Does not work when added 3rd element. Thanks in advance :) SubsetCreatebyMDX( vSubset, '{UNION( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( { [ ' | vDim1 | ' ].[ ' | vEl | ' ] }, AL...

Thank you Wim, Found something that solves #2 issue - removes single quotation mark. I think that code below can be adapted to resolve #1 issue same time.. vDesc= ATTRS('WIN',vWIN,'Description'); #Remove singe quote from description string. without this loop SQL insert will fail. iClean = 0; WHILE (...

Hi All, Another interesting problem came up when working with TM1 as newbie :) Well, two issues actually.. 1st - I'm writing out element description (using vDesc=ATTRS('WIN',vWIN,'Description'); ) to SQL table result is "123456 - Product Description" How to remove part of string starting w...

Hi, In this case you may want to create a C: element, which sums up all the 5 measures, and use that in the cube view data source Then on the Data tab: vMeasure1 = CellGetN(Cube,...,Measure1) ... So 5x CellGetN from the cube, and then 1x ODBC Output in the Data tab This will work fine as long as yo...

Hi, I'm new to TM1 world, wonder if someone can help solve this. I've created Ti process that writes data into SQL table, which is fine. However my measures all gets written in same column. Cube contains 4 dimensions. From measure dimension I need 5 elements to be into individual columns and values ...