目的:
使用 MDX 表示式匯出資料。使用此函數以使用區塊儲存應用程式計算指令碼,從聚總儲存資料庫匯出資料。@CalcMgrMDXExport
會運用 calcmgrCmdLine.jar
來使用加密的使用者名稱與密碼,以產生加密憑證。例如,若要加密使用者管理員,請使用 java -jar calcmgrCmdLine.jar -encrypt -key vta2a536uC/wyX8jM2GlHA== admin
註:
支援僅具有欄列軸的 MDX 表示式。
語法:
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 */