Skip to Content
Product Information
Author's profile photo Pranav Kumar

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.

Workflow

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.

During schedule run-time, each of the publication will consider the variable value set in the respective publication and generate story with the respective variable values.

 

Note:

  • 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. 

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Rene Malmberg
      Rene Malmberg

      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

      Author's profile photo Karthik Kanniyappan
      Karthik Kanniyappan

      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

       

      Author's profile photo Shankar Nagabushan
      Shankar Nagabushan

      Hi Pranav,

      With Prompts, can you select multiple values. in case of Region, can you select Nevada or California.

      Author's profile photo Sayed Zubair D
      Sayed Zubair D

      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.

       

      Regards,

      Sayed Zubair