SAP BusinessObjects is the main application coming under SAP Business Intelligence (BI).Here is an introductory tutorial with PDF training materials about SAP. Y:\TrainingDevelopment\Business Intelligence Training Guides .. Open SAP Business Objects Web Intelligence. .. Save as PDF. Intelligence. Rich Client. Business Objects . Saving to Other File Formats ( Excel, PDF, CSV, and Text). .. Select SAP Business Objects Web Intelligence.
|Language:||English, French, Dutch|
|ePub File Size:||30.89 MB|
|PDF File Size:||18.67 MB|
|Distribution:||Free* [*Sign up for free]|
Public folders and categories are created by the Business Objects team, and can be viewed by Reports can be exported as CSV, Excel, PDF, or Text files. PUBLIC. SAP BusinessObjects Business Intelligence Suite .. Exporting HTML Code, URLs, and Images to Excel Spreadsheets and PDF Files. Web Intelligence, the business intelligence reporting tool, is a part of SAP BusinessObjects product suite. This is a handy tool for business users for analytical.
We can use universe in central repository by secured connection. What is custom hierarchies? It defines the universe for providing the drill down which is customized and occur between objects from same or different classes taking care of the user requirements. How we can create Custom Hierarchies? We can create custom hierarchies by clicking on tools then choosing hierarchies from BO designer. What do you understand by context in the universe?
Context can be explained as the specific path of join between a specific group of joins or the tables for the purpose of a specific query.
What is Chasm Trap.
It is a situation which arises at the time when the value in the fact table get wrong when it is measured from two various fact tables. How the problem of Chasm Trap be solved?
Creating a New Report
It can be solved by two methods: By using SQL parameter in universe which generates SQL statement for each measures and result into a correct output. The second one is involving two joints in different contexts. Define Derived tables? They are created in the universe. It defines data relation between the Tables as. One —to- One. One —to- Many. Many —to- One. Many —to- Many. In the database technically how many One —to- One relations are possible?
In this example One record in Table-1 can have exactly One record in Table This relation is called as One —to- One Relation. How many One-to-Many or Many-to-One relations are possible?
How many Many-to-Many relations is possible? If the Tables are related between Two non key columns or Two Composit key columns then there is a possibility of Many-to-Many relations. Loop is a Drawback in reporting.
Because of Loop, reports will display the data in Time Slash. Finding the possible loops in Universe structure panel is called as Detecting Loops. Detect Loop is the option used in Universe to find possible Loops. To resolve the Loops we can use 4 techniques in Business Objects. Delete Unnecessary Joins: In Industries most of the reports are created using Transaction based master data. By deleting J3, if business requirements can be satisfied then delete J3 join. Second Solution: Create Alias Table: As the memory is already created in BO Repository Data retrieval, is possible.
This is divided in to 3 areas as: Security Domain Area: Universe Domain Area: Document Domain Area: Document Domain Area is the area where created documents are saved to be accessed by client environment with corresponding Authentications. A class is the presenting Object in Universe to present Business Information to the reporting Environment. A class is assigned with one or more Tables information to be presented to the Reporting layer. A class represents Schema in Universe. A class is a collection of Objects.
Ob jects represent a table column for reporting. Simply, reporting columns in Business Objects are called as Objects. Dimension Object: It is the default property applied for every database column added inside the class. This property can be assigned with all data types of source database to display source business data as it is.
Detail Objects: Using this property we need to select a parent Dimension Object. While reporting detail object is also added with parent dimension object automatically. Measure Objects: This property is appled only for Numeric Columns added with corresponding Aggregated functions to display summary information in the reporting.
Combining Breaks, Sections, and Charts in your Business Objects Web Intelligence Document
Hierarchy is collection of Dimension objects arrangement to support Drill Down and Drill Up functionalities. In hierarchies we can find two options as. All objects added under the class panel are displayed as Default Hierarchies.
Based on these default hierarchies we can create required Custom hierarchies to support RRI Concepts. Report to Report Interactions. Using this option, the. Posted by Unknown at Email This BlogThis! Sunday, March 17, Business Objects: Basic Question and Answers.
Business Intelligence is a technology used for preparing the reports for multidimensional analyses. The following are the responsibility assigned to administrator. Installations and configurations in a distributed environment. Creating the BO Enterprise Repository. Performing back up and recovery of Metadata.
Tuning the servers.
Deployment of reports. Once the Interface has designed it should be regressively tested before giving to the end user population. To design the interface and architect having good knowledge on database under standing the report requirements. Design the Reports according to the report requirement templates. Testing the each report with following types of tests.
Unit Testing. System Testing. Performance Testing. When install the XI R2 following products get installed: Business View Manager. Business Objects enterprise.
Net administration launch pad. Business objects Enterprise. Net Info view. Designer desktop intelligence. Central management console.
Universe builder. Designer is a Business Objects IS module used by universe designers to create and maintain universes. Universes are the semantic layer that isolates end users from the technical issues of the database structure. Universe designers can distribute universes to end-users by moving them as files through the file system, or by exporting them to the repository. Universe provides a semantic layer between you and the database.
It consists of classes and objects named in business terms. It is basically a mapping of table and the columns in the database to classes and objects respectively in the query panel.
SAP BusinessObjects BI
Alternatively, It is logical mapping of data in business terms. In the Business Objects User module, universes enable end users to build queries from which they can generate and perform analysis. Universes isolate end users from the complexities of the database structure as well as the intricacies of SQL syntax. Universe will be created using designer. Using this classic universe we can create web intelligence reports, desktop intelligence reports, crystal repots.
Universe Parameters. Import Tables. Import Joins. Define hierarchies. A universe parameter defines the name of the universe and connection to the target database. The first step in creating a universe is to specify its parameters.
These parameters include the definition of a universe, which is comprised of: You enter universe parameters from the Universe Parameters dialog box. This dialog box also lets you set up database options, external strategies, graphic options, and print settings. With the Check Integrity command, you can test the structure of your active universe. This means testing to determine whether its components are accurate and up-to-date.
Check Integrity serves the following purposes: It detects any inconsistencies in the objects, joins, conditions, and cardinalities of your universe. It detects whether there are any loops in the joins. It determines whether changes were made to the database to which the universe is connected.
Using check Integrity, u can check the universe. If the data provided is from two different data providers then we can link those two universes, such type of universe is called Linked Universe.
A multi dimensional analyses is a technique to modify the data so that the data can be view from different prospective and at the different levels of details. The following are the features of multidimensional analyses: Drill Down For more details. Drill Across Like from year to different cities. You can view Business Objects documents in the following formats: Enhanced Document Format. Business Objects Format. There are 2 types: Enterprise Mode, Workgroup Mode. Designer lets you save universes in either enterprise or workgroup mode.
Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository. The mode in which you save your universe determines whether other designers are able to access them.
By default, a universe is saved in the mode in which you are already working. For example, if you launched a session in enterprise mode, any universe you save is automatically in that mode. If we want to make a universe accessible to another designer working without a repository, then click the Save as Workgroup check box in the Save as universe dialog box.
Designer provides three types of connections: A universe can be accessed by multiple users and can send multiple queries to the database. A Join is a relationship that explains how the data in one table relates to data in another table.
The following are the types of Joins: Inner Joins. Left outer Joins. Right outer Joins. Full outer Joins. Theta Join. Short cut Join.
A join is a relational operation that causes two or more tables with a common domain to be combined into a single table. The purpose of joins is to restrict the result set of a query run against multiple tables. A Theta join links tables based on a relationship other than equality between two columns. A macro is a series of commands and functions that are stored in a Visual Basic for Applications module and can be run whenever you need to perform the task.
If you perform a task repeatedly, you can automate the task with a macro. You create macros using the Visual Basic Editor.
Loop is a situation that occurs when more than one path exists from one table to another. Loops result in ambiguity in the design of a universe. Designer enables you to identify loops in one of two ways: You can run the Check Integrity function, which indicates the existence of any loops.
You can select the Detect Loops command from the Tools menu. If there are loops, the Loop Detection viewer appears; it indicates the joins causing a loop. An alias is a logical pointer to an alternate table name.
The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table. As you create aliases, Designer may prompt you to create other aliases. This occurs when the new aliases result in the need for additional aliases; in other words, creating such aliases entails the propagation of other aliases. In such a situation, two options are available to you: Designer displays an alias in the Structure pane as a table.
It links an aliased table to existing tables, re-arranging joins, as necessary. You can resolve loops in two ways: The first step in resolving loops is to detect the cardinalities of the tables.A Prompt is an end users object, which allows the users to enter the value or select the values to restrict the data in the report. The home page for BusinessObjects InfoView opens. Enhanced Document Format. One to Many. Security domain can not be multiple.
- STUART MCGILL ULTIMATE BACK FITNESS AND PERFORMANCE EPUB
- HOTEL BILL FORMAT IN PDF
- FIT FOR LIFE DIAMOND PDF
- OBJECTIVE COMPUTER AWARENESS BY ARIHANT PUBLISHERS PDF
- STUART MCGILL ULTIMATE BACK FITNESS AND PERFORMANCE EPUB
- FORZA 5 CODE EBAY
- PSICOGEOMETRIA EPUB
- RAPIDEX ENGLISH SPEAKING COURSE TELUGU BOOK PDF
- ANATOMIE DER BUCHSTABEN PDF