cancel
Showing results for 
Search instead for 
Did you mean: 

Scheduling with a Prompt

former_member672670
Participant
0 Kudos

Hie Guys,

When scheduling a report with a prompt (e.g. "Year"), how is it going to refresh the report when there is no prompt selected. Does it load data for all the years or do we have to remove the prompt for scheduling to work. Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

former_member182343
Active Contributor
0 Kudos

Hi,

Create a prompt with optional setting, so that even if your prompt variable is not filled with values the it gives data as per your query logic.

If your prompt  is mandatory, then make sure that your prompt variable should hold some value always.

Lets say, go with some default values.

Best wishes, Vijay.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hii Jeevan,

It's depends upon the nature of prompt i.e whether it's optional or mandatory.

if the prompt is mandatory, the when ever the report is getting refresh will ask to enter the prompt value.Without answering the prompt , it will not proceed further.

If the prompt is set optional then can be refreshed without entering the value to prompt.Then in this case what ever the data available  for the year will be retrieve if year is the single prompt other wise the data is loaded based on the number of prompt in the query.

It's better to not remove the mandatory prompt from query, rather set it as optional  or set some default values . If set as optional then will work in both way.

Regards

Syed

former_member195290
Contributor
0 Kudos

Hi Jeevan,

If your prompts are set as Optional than your scheduled report will run successfully, if its Mandatory prompt and not changing with time than you can set the prompt value.

But if your prompt value changes with time than you will need sdk code to set it automatically.

Regards,

Javed

Former Member
0 Kudos

Hi Jeevan,

As per my observation if prompt is optional then it will be ingnored as usual. But mandatory prompt has to be filled all the time. So even if you schedule the report without filling mandatory prompt scheduling will fail with

" no data to fetch (prompt values not entered)". similar observation for both relational and olap sources.