Editing Custom Functions
I can't seem to edit my custom functions from the Repository Explorer.
Custom functions are not editable from the Repository Explorer because they are housed inside of Formulas. To view custom functions available in the Repository, go to Report, Formula Workshop. In the
Business Views Are Gone
When creating a new report, I see my available Business Views; however, after I
The Repository Explorer in Crystal Reports is context-sensitive and only displays objects that can be used within the report itself.
Migrating the Repository
In Crystal Reports 9, the sample Repository database was in Microsoft Access format. Can I migrate this to BusinessObjects XI?
In BusinessObjects XI, Microsoft Access is not a supported Repository database. The Access database will need to be
Migrating the Repository
Why did the shared
The Use Object Repository When Refreshing Report field needs to be checked. This field can be found using the CMC under objects and refresh options.
The Repository Helper process also needs to be run for the objects to be updated.
Chapter 18. Using a Semantic LayerBusiness Views and Universes
Introduction to Semantic
Why Use a Semantic Layer
Abstract the Complexities of the Database
With large complex data warehousing projects using many tables and complex joins, the report author might not have the requisite knowledge. If the report author is required to join the tables for the reports, he might not use the most efficient join, resulting in poor performance. Semantic layers allow for a division in labor, whereby the more technical database administrators and developers can create the joins between tables and data sources and the business users can concentrate on designing reports to
Putting Report Design in the Hands of Business People
As a result of this division of labor and the reuse of the Business Objects repository, business people do not have to be as technically savvy, effectively resulting in less technical skill being required to develop reports.
Support for a Wide Range of Data Sources
Both metadata layers provide a wide range of database support, including the majority of relational database
Reuse of Metadata Components
One major drawback to specifying the data joins in each report is that this creates a large amount of redundant work. Secondly, should the database change, there is no way to effect this change other than changing each of the individual reports. A semantic layer allows the administrator to create this join once and should this join change, the administrator only needs to change it once.
The semantic layer allows the administrator to set up security so that data is filtered based on who the user is. This can be based off of security within an
The Business Objects repository also secures the semantic layers and only those users with the required permissions can access them. For example, it is
The semantic layers provide the ability to export a business view to an XML file or a universe to an
file. These files can then be easily imported into another Business Objects Enterprise repository. This simple form of transportability makes semantic layer swapping a simple exercise. It also