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