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.