@CalcMgrMDXExport

Purpose:

Exports data using an MDX expression. Use this function to export data from an aggregate storage database using a block storage application calc script. @CalcMgrMDXExport uses an encrypted user name and password using calcmgrCmdLine.jar to generate an encrypted token. For example, to encrypt user admin, use java -jar calcmgrCmdLine.jar -encrypt -key vta2a536uC/wyX8jM2GlHA== admin

Note:

An MDX expression with only the column and row axis is supported.

Syntax:

Java Class: com.hyperion.calcmgr.common.cdf.MDXExport.exportData(String,String,String,String,String,String,String,String,String,String,String,String,String,String,String)

CDF Spec: @CalcMgrMDXExport(key,user,pwd,fileName,application,database,server,columnAxisMdx,rowAxisMdx,seperator,missing,useUniqueName,useAliasName,supressZeros,rowHeaders)

Exporting Data From a Database Using @CalcMgrMDXExport

Syntax:

RUNJAVA com.hyperion.calcmgr.common.cdf.MDXExport
  <KEY used to encrypt user name and password>
  <Encrypted user name>
  <Encrypted password>
  <Export file>
  <Application>
  <Database>
  <Server>
      <MDX expression that defines column members>
      <MDX expression that defines row members>
      <Separator>
      <#MISSING Value>
      <Use Unique Name> "true" or "false"
      <Use Alias Name> "true" or "false"
      <Supress Zeros> "true" or "false"
      <Show Row Headers> "true" or "false"
      /* where mdx */
      /* source member mappings */
      /* target member mappings */
                      

Example:

RUNJAVA com.hyperion.calcmgr.common.cdf.MDXExport
     "fht1qmevLWMqKSHF2yusKS" /*  key */
     "py9FTBsRCwp8afii9ntCAwSvVUXr3oZbxpxFMqobx5Jwkt34Cfxvhs21z4WmG9KT" /* user */
     "KvwlKgs56Coi1HQsrk1UwiVi9zyoE+Llel4BrYBHiJz9PF6ZDVQ/rF5taip707CL" /* password */
     "c:\\Temp\\export_W1.txt" /* export file */
     "Vision" /* source application name */
     "Plan1" /* source Database name */
     "server1" /* server */
     "{[Actual]}" /* columnAxisMDX */
     "NON EMPTY (Crossjoin({Descendants([&QRFPer1],[Period].Levels(0)),Descendants([&QRFPer2],[Period].Levels(0)),Descendants([&QRFPer3],[Period].Levels(0)),Descendants([&QRFPer4],[Period].Levels(0))},
           Crossjoin({[{Department}]},
           Crossjoin({[&QRFPer1],[&QRFPer2],[&QRFPer3],[&QRFPer4]},
           Crossjoin({[{Version}]},CrossJoin({[Basedata]},
             {[Units],[5800],[4110]}))))))" /* row AxisMdx */
     "," /* separator */
     "" /* #MISSING */
     "false" /* use unique name */
     "false" /* use alias name */
     "true" /* suppress zero’s */
     "true" /* show row headers */
     "{[P_000]}" /* where mdx */
     "Jan, Feb, Mar" /* source member mappings */
     "January, February, March" /* target member mappings */