TM1 Forum

Hey, can u pls tell me or write the syntax and show me.I am pretty new to TM1, so i dont really have much knowledge about coding. :( That is not how this works. No one is here to do your job for you. Alan has already directed you to the Request For Assistance Guidelines once already. Please follow ...

You can't do what you want without some special coding. This is because when you use a cube view as a data source you get one intersection per record. Your picture shows 5 intersections (the 5 columns). The only way to output these 5 columns in one line in the CSV is going to be to pull one column ...

Hello all,

Any suggestions ?

sorry, done now.

cant i make something like this ? here if u see in the attached file, my views measure each of them comes as a diff col in sql table against the dims.

How can i set my dimesnions in cols and rows in a ti ? though my view shows my 4 dims in cols and measure in a row, i want to that every measure element must become a column rather than appearing together in a measure column ? how can i acheive this?

BariAbdul wrote:This might help:
http://www.tm1forum.com/viewtopic.php?f=3&t=3415 Thanks

Thanks a lot !

Hi Shivangi,Could you please try ViewExtractSkipZeroesSet in Prolog tab and see the result.Thanks hey i tried the function on the prolog tab, but the ti stops responding that is it gets hanged after 15 mins, my records are around 4- 5 croes I suggest that you post your exact code, along with specif...

BariAbdul wrote:Hi Shivangi,Could you please try ViewExtractSkipZeroesSet in Prolog tab and see the result.Thanks

hey i tried the function on the prolog tab, but the ti stops responding that is it gets hanged after 15 mins, my records are around 4- 5 croes

Hello, i want to extratc my cube view to a csv file, m using ascii output but the values for the elements are not going correct.can anyone please show me how to do it ?

Hello,I have to integrate my tm1 cube data to a sql table through ti. I had made a ti using the odbcopen and close commands and insert command in the data tab.My records were going into the table, but one issue was coming that the elements that used to get hide when suppresszero was selected were no...