TM1 Forum

Thank you for the response - I get it now. It looks as though if we're happy with the format of dim1, dim2, Measure1, value then we get to use a view. If we want to change that format to Dim1, dim2, measure1 value, measure 2 value... then we are still stuck looping through dimensions.

Thanks again.

Does anyone know if there is a TI function that will export a cube in the same manner as right clicking the cube and choosing 'export to text file'. Is the only option to loop through every dimension and then call a textoutput command?

UseSQLExtendedFetch=T also worked for me on 9.5.1, win2008 R2 64 bit

I ran into a similar problem. I have multiple contributor applications against the same TM1 model. I need to manage security against the workflow dimension from application A for groups in application B. Contributor was overwriting the rule. I edited the process }Tp_Application_deploy (which runs ev...