Objetivo:
Exporta dados usando uma expressão MDX. Use esta função para exportar dados de um banco de dados de armazenamento agregado usando um script de cálculo do aplicativo de armazenamento em bloco. @CalcMgrMDXExport
usa um nome de usuário criptografado por meio de calcmgrCmdLine.jar
para gerar um token criptografado. Por exemplo, para criptografar o usuário admin, use java -jar calcmgrCmdLine.jar -encrypt -key vta2a536uC/wyX8jM2GlHA== admin
Nota:
É suportada uma expressão MDX com apenas o eixo de coluna e linha.
Sintaxe:
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)
Sintaxe:
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 */
Exemplo:
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 */