I have tried using this function inside and w/o a calc block. w/o calc block get error "not a CALC command", w/ block get the above error and no matter what members I try to use in the block, get the same error message.
Worked w/ the system administrator and verified that the cdfs are installed on Essbase, Planning and Calc Manager so I am obviously not doing something correctly. Anyone have any examples of using this function successfully? My attempt is below, for which I used an example in this link to create:
https://docs.oracle.com/cd/E57185_01/CALDH/mdx_functions.htm#CALDH-GUID-CBE991C8-9FD2-40F4-8EEE-DB6D87F67A32
Calc Manager Version: 11.1.2.4.013.005
Planning Version: 11.1.2.4.007.05
Essbase Version: 11.1.2.4.023
Source Plan Type is BSO
Target Plan Type is ASO
FIX("Forecast")
"Local" (
@CalcMgrMDXDataCopyRTP(
key removed, /* key */
user removed, /* user*/
pwd removed, /* password */
"AppName",/* from application */
"DBName", /* from database */
"", /*source server */
"AppName", /* to application */
"DBName", /* to database */
"", /*destination server*/
"CROSSJOIN({Periods},{[Total_Labor]})", /*column query */
"CROSSJOIN({[Forecast]}, CROSSJOIN({[Input_Version]},CROSSJOIN({[Local]},CROSSJOIN({[Total_Employees]},CROSSJOIN({Year},{$1})))))", /*row */
"", /*where */
"Total_Employees,Total_Labor", /* source member mappings */
"No_Contract,Labor", /* target member mappings */
"[View],[No_Dim1],[Input],[No_Dim2]", /* Target POV columns, members from dimensions that do not exist on the source*/
"-1",
@LIST(@NAME({prompt_Entity})),
"/essbaseserver/Log/test.txt" /* logger name */
);
) ENDFIX