COGNOiSe.com - The IBM Cognos Community

UNICOM Products => UNICOM Finance => Topic started by: ShawFlowers on 15 Jun 2011 03:35:07 PM

Title: Command Line for Parent within Dimension
Post by: ShawFlowers on 15 Jun 2011 03:35:07 PM
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
Title: Re: Command Line for Parent within Dimension
Post by: ShawFlowers on 23 Jun 2011 01:24:17 PM
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.