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

Building a specific Power Cube in a Model

Started by raj_aries81, 16 Jun 2016 02:45:49 AM

Previous topic - Next topic

raj_aries81

Hello All,

I have a model with multiple cubes.However, I would like to specify the cube name that needs to be built.How can I build a specific Cube using Command line.

Regards
Raj

raj_aries81

Quote from: raj_aries81 on 16 Jun 2016 02:45:49 AM
Hello All,

I have a model with multiple cubes.However, I would like to specify the cube name that needs to be built.How can I build a specific Cube using Command line.

Regards
Raj

Tried using the below command line, its still building all the cubes in the model instead of Customize.mdc. Any leads on changing the script..

cogtr -nologo -j Customize -c -n "D:\Samples\Sales_and_Marketing_Ver1.mdl"

bdbits

Transformer command line options are detailed at http://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.cogtr.10.2.1.doc/c_clioptionslist.html.

I think you want something like this:
cogtr -nologo -j Customize -c -n -m "D:\Samples\Sales_and_Marketing_Ver1.mdl"

Note that if you have cube groups you need a path-like syntax. For example if Customize is inside group MyFirstGroup, you'd need...
cogtr -nologo -j MyFirstGroup/Customize -c -n -m "D:\Samples\Sales_and_Marketing_Ver1.mdl"


raj_aries81

Quote from: bdbits on 16 Jun 2016 09:02:46 AM
Transformer command line options are detailed at http://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.cogtr.10.2.1.doc/c_clioptionslist.html.

I think you want something like this:
cogtr -nologo -j Customize -c -n -m "D:\Samples\Sales_and_Marketing_Ver1.mdl"

Note that if you have cube groups you need a path-like syntax. For example if Customize is inside group MyFirstGroup, you'd need...
cogtr -nologo -j MyFirstGroup/Customize -c -n -m "D:\Samples\Sales_and_Marketing_Ver1.mdl"


Hi bdbit,

Thanks for your reply. well, its not a cubegroup, they are all individual cubes within the same model, so I'm not sure if I can use the above command line

Regards
Raj

Francis aka khayman

use -g and specify the cube to be refreshed...

example:
cogtr -nologo -j Customize -c -n -g"Cube1" -m"D:\Samples\Sales_and_Marketing_Ver1.mdl"
cogtr -nologo -j Customize -c -n -g"Cube2" -m"D:\Samples\Sales_and_Marketing_Ver1.mdl"

raj_aries81

Thanks Khayman. My mdl doesn't have cube groups anymore, is there any option where I can selectively run only that cube.

Francis aka khayman

cogtr -nologo -j Customize -c -n -g"MyOneAndOnlyCube" -m"D:\Samples\Sales_and_Marketing_Ver1.mdl"