BOE Report Scheduler Asking for Context
Many SAP Business Objects 4 users have report scheduling complaints which are based on a universe designed in Information Design Tool and have a design that allows context selection. Issue is that when report is scheduled that can take two different paths, it ask for the context but available list of context is not displayed, resulting in the in-ability to schedule the report. Up-till SP4 (service pack 4) SAP has not released a fix for this and until that time, following are the do's and don't's for scheduling a report containing context choices:
- Create a new report and in the query panel set option to save the context choice
- Save the report
- Open the report and refresh the report using refresh icon on the top
- Select the context of choice
- Once report is refreshed, save it again
- Do not change the selection of the query objects in the query panel. Once you change objects and save it, you will not be able to schedule this report again. The only work around would be to re-create the report from scratch by following through step 1 to step 5
Good luck!
SAP Business Objects: Refreshing Structure in Information Design Tool
If Data Foundation Layer has already been developed or is being developed, then refreshing structure to reflect latest DB changes have to be done in following sequence:
- Take a backup of your project before proceeding with this process
- Open Data Foundation Layer and select "Refresh Structure"
- Utility will gather information and will categorize changes into Missing Tables, Missing Columns, Added Columns, Modified Column. On each screen it will give you option to choose which changes to reflect
- Un-check all Missing Tables and Missing Columns. Take note of missing tables and missing columns. Check all Added Columns and Modified Columns
- Complete the process. This will update changed columns and add new columns
- Manually remove missing tables from your Data Foundation and also any relevant joins
- For missing columns, make sure they are not used in any joins. If so, you need to update joins and remove/change any columns which are removed from database
- Save your Data Foundation and back it up again to protect your progress
- Once you are sure that you have updated all the joins that contained missing columns, run Refresh Structure again. This time, it should not show you any Missing Table (since you removed them manually)
- Check all missing columns and proceed. It will remove all obsolete columns from your Data Foundation
- Now try to save your work. If Information Design Tool gives you a strange error/exception, that means you have not updated all the joins and there are still some joins containing missing columns.
- Restore your Data Foundation from latest backup and go through your joins again and make sure all missing columns have been removed from joins. You have to iterate this process until you are able to save successfully after removing missing columns by Refreshing Structure
- Once Data Foundation is updated and saved, update object definitions in Business Layer
This information is for SAP Business Objects 4 SP2. This approach is useful if you want to retain your aliases, contexts and joins while refreshing structure.