BusinessObjects Topics

Search This Blog

BusinessObjects Topics
Showing posts with label Business Objects. Show all posts
Showing posts with label Business Objects. Show all posts

Thursday, November 27, 2014

Resolving Loops in a Universe

Define what a Loop is
Detect and recognize loops in Universe
Using Aliases and Contexts to resolve the loops
Identify when in the design process you resolve loops
Be able to use shortcut joins and know when to use them as alternative for resolving loops.
Be able to resolve recursive table structure loops.


A loop exists when the joins between tables form a continuous path

Three automated routines can be used to resolve most loop situations in the universe structure window.

1. Must be first Cardinality Detection
2. Alias Detection routine
3. Context Detection routine.

Click the Detect cardinalities or you can set manually also.

What is an Alias?
• An Alias is an exact duplicate of the original table with a new name. The data in the table is exactly the same.

• The Alias is used only to resolve the loop in the structure of the universe. There is no impact on the schema of the database
– Easy to define
– Easy to maintain
– Easy to use

• A loop with a single lookup table should be resolved by an alias
• A lookup table can be identified by its cardinality
• A lookup table only has the ‘one’ end of joins attached to it










Designer routines detect loops and candidates for aliases.


Break the loop by creating an alias of the lookup table for each side of the loop.
Some DBs require a separate alias for both sides of the loop.

After that you can detect loop once again,
Alias detection routine
You can use automatic loop detection also,

Click the Detect loops button, it will be identifies loops are exist or not
You can get the message in Loop detect window and it suggest to candidate contexts or aliases

If it is structure multi star situation it not possible using alias.









Normalized dimensions are not amenable to loop resolution using Aliases

• If you try to resolve the loop using Aliases:











And also we get duplicate of objects














This will be effective sales universe Rentals universe

In this case we can use to resolve with contexts.











after result look like this way.












Detecting and create context.


Double click the context in the list mode window

- give it context name
- if want write any description to update description this will be user




Read more »

Introduction to Semantic Layers

Introduction to Semantic Layers
The semantic layer is a metadata layer that abstracts the complexities of the data source. The end user sees only a logical grouping of available, well-named fields for use and does not have to concern them with the details of database design or need any SQL knowledge.
In Business Objects XI, two semantic layers are supported business views and universes. With the merging of Crystal Decisions and Business Objects, a decision was made to keep business views from Crystal Decisions and universes from Business Objects.
Why Use a Semantic LayerSemantic layers offer wonderful advantages over traditional report design processes by removing the most difficult data-intensive tasks, as described in the following sections, from report design. Furthermore, it allows for reuse of components and promotes the concept of changing a component once and having the change applied to multiple reports.
Abstract the Complexities of the DatabaseWith 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 satisfy their requirements.
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 vendors. Business views also include the ability to connect to some no relational data sources; for example, a user could abstract the complexity of an XML file by encapsulating the XML with a business view.
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.
Security
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 entitlements database, or the Business Objects user model can be used to create the security model. This way rows and columns can be secured by users or groups.
The Business Objects repository also secures the semantic layers and only those users with the required permissions can access them. For example, it is generally accepted auditing practice that accounts receivable personnel should not be able to see accounts payable information and vice versa. By using the user group functionality in Business Objects Enterprise, the accounts receivable group would be given access to only the accounts receivable semantic layer.
TransportabilityThe semantic layers provide the ability to export a business view to an XML file or a universe to an .unv 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 simplifies the storage of source code, should the organization have a source code storage requirement.

Read more »

Monday, February 7, 2011

What are Dimensions and Measures?

Read more »

Tuesday, September 21, 2010

BusinessObjects Enterprise architecture basic terminology

Host
A host can be a physical computer or virtual machine.


Server

A server is an Operating System (OS) level process hosting one or more services.
For example,
CMS and Adaptive Processing Server are servers.
A server runs under a specific OS account and has its own PID.


Service

A service is a server subsystem that provides a specific function. The service runs within the
memory space of its server under the Process ID (PID) of the parent container (server).
For example,
the Web Intelligence Scheduling and Publishing Service is a subsystem running within the Adaptive Job Server.


Node


A node is a collection of BusinessObjects Enterprise servers, all running on the same host.
One or more nodes can be on a single host. Each node is managed by a Server Intelligence Agent (SIA).


Server Intelligence Agent


The SIA is a locally run service managed by the operating system. The task of the Server
Intelligence Agent (SIA) is to start, stop, and monitor locally run BusinessObjects servers.

When one of the managed servers goes down unexpectedly, the SIA restarts the server immediately.
When you issue a command in the CMC to stop a server, the SIA stops the server.

When you create a SIA, you create a new node. A node is a collection of BusinessObjects
Enterprise servers which run on the same host and are managed by a single SIA.

You can add servers to the node and you can have more than one node on the same machine.

The SIA continuously monitors server status information, which is stored in the CMS databases.

When you change a server's settings or add a new server in the CMC, the CMS notifies the SIA
and the SIA performs the jobs accordingly.


................ continue..next we will discuss about Workflows for each servers and how the communicate each server

Read more »

Tuesday, July 27, 2010

SAP BusinessObjects Useful Links

SAP BusinessObjects Links
SAP® BusinessObjects Community: http://sdn.sap.com/irj/boc
SAP® BusinessObjects Notes: https://sdn.sap.com/irj/boc/notes
SAP® BusinessObjects Articles: https://sdn.sap.com/irj/boc/articles
SAP® BusinessObjects Forums: https://sdn.sap.com/irj/scn/forums

Read more »

Tags