Hi Guys
I have an Analytics project with multiple NAV data sources, and I am looking for a quick way of copying the work in the Data Stage from the initial setup found in the project downloaded from the Cube Store into the second instance. to explain:
When you download a project and connect to the first data source Jet sets a large number of additional Lookup and other calculated fields in the Data Stage tables.
When connecting to a second or subsequent data source I used the Selection Template to copy the basic selection from the first connection to the second instance. This creates a parallel set of tables in the Data Stage, However these tables don't contain any of the Lookups etc. that Jet creates in the initial load.
Is there a quick process for copying this Data Stage logic into the subsequent load?
Thanks
Malcolm