Page 1 of 1

Is there a way to skip the Metadata pass in a TI process?

Posted: Wed May 05, 2010 6:34 pm
by MarioRubbo
It seems extremely inefficient to iterate through my SQL data source 2 times. I try to design my TI processes so that I process the dimensions first and then post data to a cube. In the case of the TI process that is focused on building a cube, is there any way to avoid the Metadata pass and simply execute the Data pass. I'm a good boy - I know that there are no orphans that will generated from the Data Pass. Build time is going to be an issue at this client so I am trying to reduce it as much as possible.

Re: Is there a way to skip the Metadata pass in a TI process

Posted: Wed May 05, 2010 7:00 pm
by MarioRubbo
Sorry, I just found the answer in the FAQ.


"If only one or the other tab is needed then there should be NO CODE on the other tab, otherwise the data source will be processed twice unnecessarily. If the data source is large then this can be hugely inefficient."