If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

SOLVED: "Copy" a Cube to use different FM Query

Started by adam_mc, 28 Jun 2013 08:07:33 AM

Previous topic - Next topic

adam_mc

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.

adam_mc

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.

bdbits

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.