TM1 Forum

Also to note the requirement to at least have something on 0 doesn't apply when using the view as a zero out view. I've taken several of these without columns defined the view the same way and done a ViewZeroOut call with no problem. It seems it only applies to a view as a data source.

THANK YOU! I did what you suggested and got a temporary memory pool error. So I decided to rewrite the mdx below # set the MDX for the dynamic view vDataSourceMDX = 'SELECT non empty { [currency].[currency].[Local] } ON 0, NON EMPTY { TM1SubsetToSet([entity].[entity],"mdxLeaf","public...

I think what may be happening is all the intersecting cells are 0 and the old TI is making a file full of zeros while the new TI is not looping the zeroes through data and metadata. Trying to figure out a way to prove that

I also tried

ViewExtractSkipCalcsSet(vCubName, vDataSourceView,0); and it didn't change anything

It is a subset the contains a mix of consolidations and leaf elements. I did change the view to use a single leaf value in its place and got the same result (no loops through the data tab)

I read the useful tips FAQ sorry in advance if I didn't follow it right I'm in PAW. I think we're 2.0.0.84. I have a TI process where the data source is a named view tiListSalesYTD. My goal is to change the TI to do the exact same thing but make the view in the prolog. I will post the code after thi...

I've used ODBCOutput to do dml and ddl on oracle tables but is this possible? ODBCOutput(vConnection, 'select 12345 into %vNumber% from dual'); The reason is I'd like to use this as like a post-query against a sql based ODBC data source in a process. I've read all over the place and seen numerous in...