@CalcMgrMDXDataCopyRTP
Purpose:
Copies data using runtime prompts from one database to another database or from one server to another server using MDX scripts.
RTPs can be used for the following arguments:
- Column MDX
- Row MDX
- Where MDX
- Source mappings
- Target mappings
- POV Columns
Instead of using the variables for these arguments, use $1, $2, $3, and so on. Then in the argument, use a @LIST function to pass these variables. The first argument's input replaces $1, the second argument replaces $2, and so on.
Syntax:
Java Class: .hyperion.calcmgr.common.cdf.MDXDataCopy.dataCopy(String,String,String,String,String,String,String,String,String,String,String,String,String,String,String[],String)
CDF Spec: @CalcMgrMDXDataCopyRTP(key,user,password,sourcApplication,sourrcDatabase,dtnApplication,dtnDatabase,columQuery,rowQuery,whereQuery,sourcMappings,targetMappings,targetPOVColumns,maxRowsPerPage,arguments,loggerName)
In this example, instead of using variables for the runtime prompt arguments, we use $1, $2, $3, and so on. In the argument, we used a @LIST
function to pass these variables. The first argument’s input replaces $1, the second argument's input replaces $2, and so on.
Example:
FIX ("FY14", {Scenario}, {Version}, {Department})
"Jan" (
@CalcMgrMDXDataCopyRTP(
"fht1qmevLWMqKSHF2yusKS",
"py9FTBsRCwp8afii9ntCAwSvVUXr3oZbxpxFMqobx5Jwkt34Cfxvhs21z4WmG9KT",
"KvwlKgs56Coi1HQsrk1UwiVi9zyoE+Llel4BrYBHiJz9PF6ZDVQ/rF5taip707CL",
"Vision",
"Plan1",
""
"ASO_401",
"ASO_401",
""
"{[$1]}" ,
"NON EMPTY (Crossjoin({Descendants([&QRFPer1],[Period].Levels(0)),Descendants([&QRFPer2],[Period].Levels(0)),Descendants([&QRFPer3],[Period].Levels(0)),Descendants([&QRFPer4],[Period].Levels(0))},
Crossjoin({[&QRFYr1],[&QRFYr2],[&QRFYr3],[&QRFYr4]},Crossjoin({[$3]}, Crossjoin(Descendants([P_TP],[Product].Levels(0)),{[Units],[5800],[9000]})))))",
"([$2])",
"",
"",
"",
""
"-1",
@LIST(@name({Scenario}),@name({Department}),@name({Version})),
"c:/Temp/CM_DCopyVW1.log"
);
)
ENDFIX