1. Designer's Guide
  2. Using Member Selection, Variables, Functions, Smart Lists, and Planning Formula Expressions to Design Components
  3. Working with Custom Functions
  4. MDX Functions
  5. @CalcMgrMDXExportRTP

@CalcMgrMDXExportRTP

Purpose:

Exports data using run time prompts from a cube using MDX scripts.

Syntax:

Java Class:.hyperion.calcmgr.common.cdf.MDXExport.dataExport(String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String[])

CDF Spec: @CalcMgrMDXExportRTP(key,user,pwd,fileName,application,database,server,columnAxisMdx,rowAxisMdx,seperator,missing,useUniqueName,useAliasName,supressZeros,rowHeaders,args)

Exporting Data From a Database Using @CalcMgrMDXExportRPT

You can use run time prompts for the following arguments:

  • Column MDX
  • Row MDX
  • Where MDX
  • Source Mappings
  • Target Mappings
  • POV Columns

Instead of the using variables for these arguments, use $1, $2, $3, and so on. In the argument, use a @LIST function to pass these run time prompts. The first argument’s input replaces $1, the second argument replaces $2, and so on.