Query will not run/refresh data

While running a report in BSAE, the following oracle error appears:

"ORA-01013:user requested cancel of current operation (wis 10901)" when trying to refresh the information.

This is a known issue. The Business Objects (BO) reporting engine has a default setting that can cause this problem.

1.) Go the edit query screen and click on the properties pane there is an option to "Retrieve duplicate rows" that is checked by default, uncheck this box.

2.) Use a date filter. On the data pane under general there is a "Single Date Filter" and a "Date Range Filter". Depending on what users want from the report, they should use one of this filters to help BO make a good decision when it creates the SQL. The "Single Date Filter" is like saying show me the data that was current as of this date. This is what most reports want. The "Date Range Filter" is like saying show me the data that was current between these two dates.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s