Hi!

Im currently working on a setup where some PDI jobs and transformations will be executed from the BI-server scheduler.

In one of my dataflow the initial input step is an MDX query.

Here it seems that i can choose between the Mondrian Input Step and the OLAP input Step in PDI.

Im having a hard time wrapping my head around the differences between the two, and how these differences might be affected by my setup.

It seems as if the OLAp input connects to the BI-server XMLA service, which then processes the query.
Wheras the Mondrian input within PDI itself builds a Mondrian cache, and fetches the data directly form the database specified.

How would this work when executing form within the BI-server? Which would be the best choice?

Thanks!