View is not loading

Post Reply
nag123
Posts: 2
Joined: Thu Sep 13, 2012 1:56 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2003

View is not loading

Post by nag123 »

Hi,

I have a TI process that builds the view and another TI process will use that view as a source and load. But in my case First process is creating view properly i can see the values but second process is completed but not loading any values. i used the same code as in second process and i created a view manually and able to load that.

any sugestions will appreciate.

Thanks,
nag
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: View is not loading

Post by qml »

I would suggest that maybe the view you create doesn't e.g. include rule-calculated values (whereas it should).

Check out these switches and use them to make sure your view actually returns what you expect it to.
ViewExtractSkipCalcsSet
ViewExtractSkipRuleValuesSet
ViewExtractSkipZeroesSet

To further debug the problem you can put some ASCIIOutput on your Data tab to see if it gets executed at all (it will not if the data source is empty).
Kamil Arendt
nag123
Posts: 2
Joined: Thu Sep 13, 2012 1:56 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2003

Re: View is not loading

Post by nag123 »

I have added all these 3 and disabled. I can see data in view and verified properties but when i run second process its not going to data tab its ignoring i cant able to put ascii output.

Thanks,
nag
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: View is not loading

Post by qml »

Can you post your script from the first and second TI here?

And by the way, there is normally no need to create a view that will be used as your data source in a separate TI. Normally you can do it in the Prolog of the same process that will be using this view as Prolog is executed before opening the data source.
Kamil Arendt
Post Reply