Schedule webi report with date as "All"

[former_member221192]

Hi Expert,

I am trying to run the report the report with following prompt as "All" .When i select all the prompt as "All" condition due to huge record it is taking to much  so I am trying to schedule the report but here when date(Spend Start Date,Spend End Date,Consent Start Date,Consent End Date) is optional.if this is not select ed it will bring all values

Prompt screens:

Schedule prompt screen:here is the issues

when schedule report with some selected date it is working fine and schedule status is success but here date is optional prompt if date is not selected it should bring all the data but it is not working and schedule status is failure.what is issue could please guide me.thanks in advance

Regards

Gnapathy

[amitrathi239]

how many years of data in your database?what is the your backend database?

report is failing due to high volume.ideally you need to change sone optional prompt to mandatory prompt.

[former_member221192]

Hi Amit,

Thanks for response.

Backend : Oracle

Data:10 years of data

Why do i change optional prompt as mandatory prompt.if date is selected it should bring all the values.is there any other alternate way to proceed further.

Regads

Ganapathy

[former_member199945]

Hi,

What error you are getting when you schedule all for date objects and It is not recommended to fetch all years data in single instance .

Create 5 instances for year object i.e at the time of scheduling try to schedule 2015 & 2016 years data as once and make acopy of that instance and create another schedule 2013 & 2014 years follow same .

Thanks