@CalcMgrMDXExport

Objectif :

Exporte les données en utilisant une expression MDX. Utilisez cette fonction pour exporter les données à partir d'une base de données en mode "aggregate storage" en utilisant un script de calcul d'application en mode "block storage". @CalcMgrMDXExport utilise un nom d'utilisateur et un mot de passe cryptés à l'aide de calcmgrCmdLine.jar pour générer un jeton crypté. Par exemple, pour crypter l'administrateur, utilisez java -jar calcmgrCmdLine.jar -encrypt -key vta2a536uC/wyX8jM2GlHA== admin

Syntaxe :

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

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

Syntaxe :

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

Exemple :

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