Business Rule to export data with File name dynamic(prompt), according prompt scenario selected.

I'm using Essbase 11.1.2.4 on Premisse.

I need to export a level 0 data of an BSO Essbase cube but in the name exported I'd like to use the Prompted Scenario selected.

For example:

 

Business rule: XPTO

Prompts: Scenario: Forecast

 

SET DATAEXPORTOPTIONS

{

DataExportLevel LEVEL0;

DataExportDynamicCalc OFF;

DataExportNonExistingBlocks OFF;

DataExportDecimal 3;

DataExportColFormat ON;

DataExportColHeader "PERIODS";

DataExportDimHeader ON;

DataExportOverwriteFile ON;

DataExportDryRun OFF;

};

FIX (

@RELATIVE("YT",0),

{RTP_Scenario_OPER},

{RTP_Version_OPER},

{RTP_YEAR_START}:{RTP_YEAR_END}

)

     DATAEXPORT "File" "," "/PATH/T4_APP_LVL0_ {RTP_Scenario_OPER}.csv" "NULL";

ENDFIX

 

Have anyone done this before?

Any suggestions?

Leo