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

Command Line for Parent within Dimension

Started by ShawFlowers, 15 Jun 2011 03:35:07 PM

Previous topic - Next topic

ShawFlowers

Hey Guys,

I'm trying to pull and Export from Module Define.  However I need to pull it at a parent level within the Hierarchy.

Example: Within the Accounts Dimension I have Balance Sheet ID: BS.  I want to pull all the children of that parent into a CSV through Command Line.

Start /w "Cognos Finance" "C:\PROGRAM FILES\COGNOS\CER5\BIN\lexwcmd.exe"
/SYSTEM SGI03
/user XXXX /pswd XXXX
/MODULE DEFINE
/ACTION EXPORT
/FILE \\XXXXX\Cognos Data\SGI03\ADMINISTRATION\GROUP1.CSV /SUBMISSION BI_Reporting
/DIMENSION ACCOUNTS
/TYPE CSV
/FILTER CALC
/DELIMITER ,
/NI
/FORMAT ID , NAME
/OPTION NORMALIZED
/debug

Thanks! James

ShawFlowers

There's no one out there that can tell me how to pull this through command line?

I can do this through Define Items and put a range of Selected but I can't find where in Command Line I can tell it what Hierarchy in the dimension I specifically want.