@CalcMgrMDXExport

목적:

MDX 표현식을 사용하여 데이터를 익스포트합니다. 이 함수는 블록 저장영역 애플리케이션 계산 스크립트를 사용하여 집계 저장영역 데이터베이스에서 데이터를 익스포트하는 데 사용됩니다. @CalcMgrMDXExport에서는 calcmgrCmdLine.jar을 사용하여 암호화된 사용자 이름 및 비밀번호로 암호화된 토큰을 생성합니다. 예를 들어, 사용자 관리를 암호화하려면 java -jar calcmgrCmdLine.jar -encrypt -key vta2a536uC/wyX8jM2GlHA== admin을 사용합니다.

구문:

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)

구문:

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 */
                      

예:

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 */