Scheduling Analysis Workbook - prompt with 2 different values

[mario_panzenboeck]

Hello,

our customer wants to schedule an AO workbook with prompts. For one prompt (variable) there should be selected two different values.

For example: Bex query contains a variable based on 0costcenter.

For that costcenter the ao workbook should be refreshed and scheduled with two different values.

I am using in our demo system the option "schedule" - "prompt" and defined the following:

Data Source          Variable          Value

DS_1                    0N_CCTR     H1000

How to schedule the workbook with two different values? It would be also nice if the scheduling process then creates two workbooks, each workbook with it´s personalized variable value.

Thanks and best regards,

Mario

[mario_panzenboeck · Accepted solution]

I found the solution for this:

Changed the variable in the query to multiple value variable. (before it was single value)

Changed the Syntax for selecting 2 values:

"Value1;Value2" is the correct Syntax.

[mario_panzenboeck]

This message was moderated.