Is there a way in Transformer to copy an entire "model"?
I am not talking about a "Save As", I need to change the package query that it is using (created in Framework Manager).
I have the need to make a duplicate cube (every element in the cube is exactly the same), but the driving query will be over a different range of dates.
I am hoping I don't need to go thru all the creation steps in Transformer again.
Any thoughts would be greatly appreciated.
Thanks in advance,
Adam.
To resolve:
1. Save .pyj as .mdl
2. Prior to exiting, I had to delete all Categories and delete existing Cube.
3. Save and Exit.
4. Open .mdl in Notepad, edit Transformer Query Name to New Name, Save and Exit.
5. Re-open .mdl in Transformer, Save as .pyj and rebuild Categories.
6. Create Transformer Cube.
7. Publish Cube as a Source and Package.
8. Save and Exit.
This might be more work depending on model size or complexity, but this would probably be a more 'supported' way to do it.
Open your model in transformer.
In the Data Sources pane, right-click an empty area and pick Insert Data Source.
Follow the prompts to connect to the new package/query.
Right-click your existing query and select Change Source Type.
Pick the data source type Package, then select the new package from the drop down.
Remap if necessary in the Query Definition window that pops up and click OK.