Author Topic: Command Line for Parent within Dimension  (Read 5749 times)

Offline ShawFlowers

  • Associate
  • **
  • Join Date: Jun 2011
  • Posts: 2
  • Forum Citizenship: +0/-0
Command Line for Parent within Dimension
« 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

Offline ShawFlowers

  • Associate
  • **
  • Join Date: Jun 2011
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Command Line for Parent within Dimension
« Reply #1 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.

 


       
Twittear