Checking the integrity of a universe or its elements helps you avoid problems when you run queries on a published universe. This function lets you check the design of your universe and its elements. The check happens in two steps: the SQL is first parsed, and then run.
You can check the integrity of different objects and resources at any time in the SAP BusinessObjects Information Design Tool.
You can use this function in these views:
- Local projects view: For resources such as data foundations, business layers, connections, and shortcuts.
- Editor: For elements in the data foundation and business layer, such as tables, contexts, business layer objects, queries, parameters, and lists of values.
- Repository resources view: For published universes.
Note
Check the Integrity
To check the integrity of a resource or object, first right-click the item you want to examine. Then, choose Check integrity from the context menu.
In the Check integrity dialog box, select the rules you wish to apply from the left-hand pane. Finally, click Check integrity to run the selected checks.
The results appear in the right-hand pane of the Check integrity dialog box.
After a rule is checked, it can have one of three statuses:
- Error: The check finds an error and stops. You must resolve the problem.
- Warning: The check finds a missing object, such as a key or link. This may cause future issues.
- Information: The check does not find any problems.
Set the Integrity Check Preferences
On the Check integrity preference page, you choose which rules run automatically when you save a resource. You also set the severity level for the messages each rule provides to match your organization's standards and risk tolerance for integrity control.
To configure the check integrity settings, start by opening the main menu and navigating to Window→Preferences.
In the Preferences dialog box, expand the Information Design Tool section and choose Check integrity.
You can then enable the background check integrity on save by selecting the corresponding option.
Next, choose which rules you want to include in the background check. If you need to adjust the severity of the messages returned by a specific rule, simply click in the Severity column for that rule and select the desired severity from the list.
Once you have made all necessary changes, click OK to save your settings and close the Preferences dialog box.
Best Practices
In the universe life cycle, you must follow these steps:
- Update the universe.
- Save your changes, including connection, data foundation, and business layer.
- Check the integrity of the universe.
- Test objects in the Query panel of SAP BusinessObjects Information Design Tool.
- Test objects in the Query panel of SAP BusinessObjects Web Intelligence.
Let's Summarize What You've Learned
- Checking integrity helps identify and resolve design issues in universes before running queries.
- You can check integrity for various resources and elements in different views of the SAP BusinessObjects Information Design Tool.
- Integrity checks assign statuses: error, warning, or information, guiding you to address or monitor issues.
- You can customize rule statuses to match your organization’s standards in the tool’s preferences.
- The check integrity process is simple: right-click, select Check integrity, choose rules, and run the check.