Defining Prompt values while creating or editing Schedule Publications in SAP Analytics Cloud
Starting wave 2020.07, while creating and editing schedule, user will have an option to define prompt values for a given publication (View).
When a story is created on model with variables, while viewing the story, user have an option to edit the value of the variables and the story will be populated with the data with the selected values. Since schedule is background job, variable values should be provided during create/edit workflow and the same value should be used during Schedule run-time.
Essentially, as a Scheduler, I want to deliver story content to sales team with data for their respective regions. While creating a schedule, I will create a publication for each region and select the prompt value in each publication for the respective region. This will ensure, when the schedule runs each region sales team gets their filtered copy of the data.
I have a Story which is created on two models and both has variables, while viewing story I can select the models and define the value(s) for it
While creating a schedule publication, I will have an option to define variables values for each model in my publication using edit prompt
I will create two Publications, one for California and another for Nevada sales team. I will select the model Regional sales and select the respective variable values in the publication
In California Publications, value for Region = California
In Nevada Publications, value for Region = Nevada
There is another model with name Sales data in the story, this model has prompt values for the products. I will not change the value for this model prompt in the publications. This means, it will always respect the default values set at the story side. Basically, during schedule run-time, it will check the default value updated in the story and uses same value to generate the story data during schedule run-time.
- If the Model is created on connection which is based on Basic authentication (username and password), then while creating and editing schedule it will prompt for username and password of connections similar to the way it prompts during story view time. If the password is not provided correctly then the user will not be allowed to change the prompt values
- Scheduling will either respect all values for the variables saved at the story or set at the individual schedule, for a given model
- if scheduler wants to respect the value set at the story then they should not modify at the schedule definition (create and edit schedule screen) and if they want to define values at individual schedule then all value set at the schedule definition would be honored during run time.
- In case of multiple variables (fixed and dynamic) within same model, scheduling do not have an option to set value for certain variables at the schedule definition and certain from the story or be dynamic.
But you need at least 25 licenses to have option to do a single publication. And the only option to do more is to buy more licenses
Yes, That's the current way out , We have a minimum of 25 licenses for enabling this feature and using the same.
Post that , the calculation is based on 5% of total number of licenses = publications per hour
With Prompts, can you select multiple values. in case of Region, can you select Nevada or California.
Hi Pranav Kumar
What can we do when we have Dates as mandatory prompt value and how these can be changed when we do a schedule? How can this be made dynamic selection.
Hi Sayed Zubair D ,
Did you find a solution ?
Yes there is a solution. This needs to be defined at the query level. You need to define prompts like
Run every: Daily, Weekly, Monthly in the query and logic for these should be defined in the query.