The components of SAP BI are. SAP BusinessObjects is the main application coming under SAP Business Intelligence (BI). SAP Crystal Reports application provides the facility for generating and designing the reports that customers tutorial about SAP Crystal. LearnSAP. Your SAP Training Partner. SAP Business Intelligence step-by-step guide Camden Lane, Pearland, TX Business Intelligence (BI) Reports. .. Create Document. . The SAP BI budget and award reports are run from the database known as the.

Sap Business Intelligence Pdf

Language:English, French, Hindi
Genre:Academic & Education
Published (Last):06.12.2015
ePub File Size:27.46 MB
PDF File Size:16.10 MB
Distribution:Free* [*Sign up for free]
Uploaded by: ISAIAH

BUSINESS INTELLIGENCE SOLUTIONS FOR SAP. About the Author. PHILIP RUSSOM is the senior manager of TDWI Research at The Data Warehousing. The SAP® Business Intelligence Competency from Fujitsu has a proven track record in the design, development, deployment, and maintenance of enterprise BI. SAP's Strategic Focus on Business Intelligence. Core. • Core for innovation . SAP Business Objects Mobile BI .. WebI Support of PDF.

Using condition objects has the following advantages:! Useful for complex or frequently used conditions! Gives users the choice of applying the condition!

No need for multiple objects! Condition objects do not change the view of the classes and objects in the universe pane Aggregate Awareness! Aggregate awareness is the ability of a universe to make use of aggregate tables in a database. Set up aggregate awareness as follows: Define the Select statement for an object using the AggregateAware function.

Specify which objects are incompatible with the aggregate table and can not be used in a query that is run against that table. Derived Tables 51! Derived tables are tables defined in the universe schema. A derived table is defined by an SQL query at the universe level that can be used as a logical table in Designer. The columns returned by the queries to build objects can be used as the columns of a normal database tables. In this way.

This SAP security plug-in offers several key benefits: So, once you map an SAP role to the platform, all users who belong to that role can log on to the system. When you make subsequent changes to the SAP role membership, you need not update or refresh the listing in BI platform. Double-click the entry SAP. Click on the tab Role import. Click on the tab Options. SAP authentication also allows you to preserve information about user roles in SAP, and to use this role information within SAP BusinessObjects BI platform to assign rights to perform administrative tasks, or access content.

To access it from the home page of the CMC, click Authentication. Authenticating SAP users. These names are recommended but not required. Change the new role's authorization data by setting these values for the following authorization objects as shown in the table above. For greater security, you may prefer to explicitly list the user groups whose members require access to SAP BusinessObjects BI platform. Log on to the Central Management Console. Navigate to Authentication.

For example: Click Update. The system ID and client number are combined and entered as an entry in the list of logical systems. Log onto the Central Management Console.

Double-click SAP. Navigate to the Options tab. That is, the system that is contacted to authenticate users who attempt to log on with SAP credentials but without specifying a particular SAP system. If you designate a default system, users from that system do not have to enter their System ID and client when they connect from client tools like Live Office or Information Design Tool using SAP authentication.

SAP BusinessObjects BI platform uses these settings to determine when to stop communicating with an SAP system that is unavailable, and when it should resume communication with that system. In the Max number of failed attempts to access entitlement system field, type the number of times that SAP BusinessObjects BI platform should reattempt contacting an SAP system to fulfill authentication requests.

Setting the value to -1 allows SAP BusinessObjects BI platform to attempt to contact the entitlement system an unlimited number of times before ceasing. In the Keep entitlement system disabled [seconds] field, type the number of seconds that SAP BusinessObjects BI platform should wait before resuming attempts to authenticate users against the SAP system. For example, if you type 3 for Max number of failed attempts to access entitlement system, SAP BusinessObjects BI platform allows a maximum of 3 failed attempts to authenticate users against any Continued on next page.

Named user licenses are associated with specific users and allow people to access the system based on their user name and password. The fourth failed attempt results in SAP BusinessObjects BI platform ceasing its attempts to authenticate users against that system for the amount of time specified by Keep entitlement system disabled [seconds].

This provides named users with access to the system regardless of how many other people are connected. This type of licensing is very flexible because a small number of concurrent licenses can support a large user base. Each group is named with the following naming convention: The following fields are used to configure the SAP single sign-on service: If option is set to 1.

If set to 3. You can also manually enter the full path to the file in the field provided. The certificate is stored on the SAP system. Navigate to the Role Import tab. Select Users and Groups from the drop-down list. Close the above screen by clicking the X on the top right-hand corner. After the import of the SAP roles has been completed. Select the logical system for the SAP server.

You should see the role you imported from SAP under Groups. No new user accounts will be created if you only update SAP roles. It is recommended that you use this option if you expect to run frequent updates. Choose the correct answer s. B Correct answer is B. This unit provides you with an overview of the functions and different types of components that can be created in Information Design Tool Information Design Tool Overview Create a Multisource Universe..

Creating Multisource Universes All rights reserved Unit Objectives After completing this unit The Semantic Layer. Concept of the Semantic Layer A semantic layer represents corporate data in common business terms.

For example you can create familiar business objects like Customer.

Ideally it brings together all forms of data for consumption which means relational. The complexity of the data source is hidden and so the business user can use these objects for analysis without having to know the underlying tables of the database where the data is stored.

It enables organizations to easily reach and work with the broadest set of information sources. The objective of a semantic layer is to provide a semantic or common adaption layer that allows business users to have a common experience across the different clients. It helps that business users can access data autonomously without being familiar with the structure and technical characteristics of the respective data source.

The semantic layer is created by a designer who understands the structure of the data source. The objects are named and classified by data type. Product and Revenue which represent database structures in the data source. Innovations with the Semantic Layer in BI 4. You should use the Information Design Tool for all new projects.

Resources i. You can share projects in a repository to make resources available to other designers. To provide this functionality. You can create and edit secured connections. The information design tool lets you take advantage of these major new universe design features: Once you have validated a local connection. The Information Engine works behind the scenes and enables querying and computational capabilities during report consumption.

Innovations in the Semantic Layer in Release 4. The Connection Server has also been updated to improve connection management. The Semantic Layer Figure The role of the universe is to provide the business user with semantically understandable business objects. Information Design Tool Overview Lesson: The metadata object layer. A universe is an organized collection of metadata objects that enables business users to analyze and report on corporate data.

These objects include dimensions. A universe includes connections identifying the data sources. The user is free to analyze data and create reports using relevant business language regardless of the underlying data sources and structures.

The Information Design Tool provides the following resources that a designer uses to extract metadata from relational or OLAP data sources and then to build a business layer of objects targeted to a specific user group: Resource Description Project A project is a named local workspace.

Each object corresponds to a unit of business information that can be manipulated in a query to return data. The metadata objects include dimensions. Connections or universes are provided for this user group by the Information Design Tool users. A project contains one or more resources that are used to build one or more universes.

A universe is always associated with at least one connection. Data Foundation A data foundation is a schema that defines the relevant tables and joins from one or more relational data sources. This could be a database administrator. The designer can enhance the data foundation with contexts. The data foundation becomes the basis of one or more business layers. However the Information Design Tool is not intended as a design environment for typical Business Users. A project can be shared so that multiple designers can work on the same resources.

You can build any number of business layers on the same data foundation. The business layer provides the metadata objects dimension and measure objects. Parameters are often defined to prompt the user to supply a value.

Parameters and lists of values can be defined in the data foundation. For OLAP data sources a data foundation is not necessary. Parameters and Lists of Values A parameter is a variable in the universe that requires a value at query time. In this case the data foundation becomes the basis for multiple universes.

Universe A universe is an object that includes all resources used in the definition of the metadata objects built in the design of the business layer. Within this project a connection to a data source has to be defined. A query can only be used to test objects in the business layer. They are inherited by all business layers based on that data foundation. A list of values is a collection of data values that can be associated with an object in the universe.

Based on this connection a Data Foundation has to be created for relational data sources. Query A query is a set of objects that define a request to the data source. Parameters and lists of values can also be defined in the business layer.

In the Information Design Tool which is installed as local client tool the Designer first has to create a new project.

The resources and folders in a local project are stored as physical files and folders in the local file system. Components of a BI 4. Once you have created a local project. You create and edit all resources except secured connections and security profiles in a local project. Working with Shared Projects When you work with multiple users on one project. Resources between local and shared projects have to be synchronized. In order to create a shared project follow these steps: Shared Projects are saved in a repository and can be made available to other designers.

Information Design Tool Overview Figure Create a local project and create resources 2. Choose New Shared Project in the context menu of the project. The resources are available for other designers in the shared project. Synchronize the resources in the project that you want to share in the Synchronization View by choosing Save Changes to Server icon. To view local dependencies choose Show Local Dependencies in the context menu of a resource. You are warned of the impact before you delete or move a resource.

For example deleting a connection has an impact on a Data Foundation or Business Layer built on top of it. The connection is represented by a local file. A lock icon appears next to the resource if it is locked. The view displays synchronization information in two panes: The status can be set to Conflicting if there are inconsistencies.

Make sure that you lock resources before you edit them locally. There are different types of connections that can be created: The status is determined by comparing the resources in the local and shared projects.

Other information about the resources on the server are given: Here you will find information if resources have been added. Once you have finished editing resources choose the Save Changes to Server icon and unlock them afterwards.

Log on to BI Platform and select the shared object. All connections created in the local project are called local connections. They are primarily used in the authoring phase of data foundation and business layer development.

You can use the shortcut in the same way as a local connection. The connection shortcut is available locally. The business layer is published as a universe and the connection provides direct access to the OLAP data source.

Local connections have limited or no security as they can be used by any user with access to the machine running the Information Design Tool. Data foundations need to be built on top of these connections. Data foundations are the basis for business layers. After the connection has been published a local shortcut. Description Relational data source Relational connections can be created for many relational databases. That means this kind of connection cannot be part of a universe.

Single-source data foundations support database-specific SQL syntax for derived tables. There are two different types of data foundations: This connection can be local or secured. As the name implies single-source data foundations support only one connection.

You reference relational connections in the data foundation. Using the Data Foundation Editor. You insert tables and joins from the databases referenced in the connections. Connectivity with Universe Design Tool and Information Design Tool Working with Data Foundations A data foundation contains a schema of relevant tables and joins from one or more relational databases that are used as a basis for one or more business layers. They are recommended for the following situations: A multi-source join can be created between tables from different connections.

Multisource-enabled data foundations only support secured connections. Universes with this kind of data foundation can only be published to the repository. That means that a relational connection can be created on the fact tables and the related master data tables of an InfoCube.

Tables and joins can also be inserted and edited manually. Use the Insert Tables command to insert several tables at one time and ask for keys. Multi-source data foundations always have to be created in the BI Platform repository. You can add connections when you create the data foundation and anytime later.

Information Design Tool Overview Once the data foundation is created. As in single-source data foundations you can let the Information Design Tool detect joins between tables automatically. Multisource-enabled data foundations are required in the following situations: Data Foundation on a Relational Data Source Multi-source data foundations support one or more connections.

You can also select certain table fields from the data foundation that are relevant for this universe and leave others out.

In the business layer you define the dimension objects and attributes representing master data. For example a database field Amount sold could be renamed to Sales Volume. The principle role of the business layer is to define and organize metadata before it is published as a universe.

The user who opens the universe in one of the SAP BusinessObjects tools then only sees the objects that you have created in the business layer and does not have to deal with the complex structure of the data source. Also the objects in the business layer can be renamed into familiar business terms.

Or business layers can be directly that means without a data foundation built on OLAP connections. You insert result objects into the Result Objects pane.

You can add filter objects to filter the returned results by criteria such as a date range. The result objects are shown in the executed query. You can preview the results to verify that the query returns the expected results and you can also view the query syntax that forms the query. Note that in order to edit universes you always have to retrieve them from the repository and open the respective resources in Information Design Tool.

If the connection is published to BI Platform repository the universe also has to be published there. After editing the resources have to be published again to be available for reporting users. When business layers have been published locally or into BI Platform they are represented by a universe.

Or in other words: It is not possible to publish a universe to BI Platform if the connection is local. Publishing locally This can only be done with business layers that use local connections. Publishing to a repository A universe that has been published to BI Platform data and metadata of the universe are secured by the security profiles that have been assigned in the Security Editor of Information Design Tool.

Creating Relational Universes with the Information Design Tool Lesson Overview In this lesson you will learn how to create semantic layers on relational data sources. Sybase database systems and many more. That means you have to create a project.

SAP BusinessObjects BI

Relational Connection Options In order to create and publish a relational universe you have to build all the necessary resources for the universe first. The first step to create a universe is to create an new project in the Local Projects View. When selected. Use specified user name and password — enter login details in the connection definition 2. Also see Information Design Tool User Guide for more information about the settings for the different database connection drivers.

Tables and Joins in a Data Foundation After you have created a relational connection you have to create a new data foundation. You also need to define cardinalities of the joins. To run an integrity check. To create a new data foundation follow these steps: To start the New Data Foundation wizard.

In the wizard you name the data foundation. If you only want to work with one relational connection a single-source data foundation is sufficient. Migrating a BusinessObjects Enterprise 3. As a last step you choose a repository folder where the converted. Then you can select a. After you have converted. Depending on the type of data source for the business layer. Follow these steps to create a new business layer: For more information. X Universe You can use the Convert.

The Information Design Tool TBI30 Creating and Publishing a Relational Universe The last step of publishing data from is to create a new business layer on top of the existing relational data foundation.

Make sure that the connection has also been published before. However this is only for legacy reasons. Also note that OLAP universes cannot be converted. In order to convert a. You can convert the following types of. The Business Layer objects pane contains the metadata objects you use to build the business layer. Filters and Folders. Upgrade from. Migration of.

Use Information Design Tool to create a semantic layer for the sales users in your company. This universe needs to be provided to Web Intelligence users for reporting on sales key figures. Make sure that the table fields in the data source are represented by dimensions and measures that can easily be identified by this user group. Make sure you use the secured version of the relational connection. Set primary keys for the database tables.

In total you need to create three joins. Enter the cardinalities for each of the joins. Save your data foundation after you have defined the cardinalities. Use the following credentials to log on: Use different dimension and measure objects and execute the query to check if the results are displayed correctly.

String State Time Week in Calen. That means amount and quantity of sold goods should be analyzed in connection with shop data. Run all possible integrity checks. Do not create dimensions and folders automatically in this business layer. Note that the universe will have the same file name as the business layer. The business layer is intended for strategic sales reporting. Provide the following dimensions and measures for your reporting users: Publish the business layer as a universe to the BI Platform repository.

You do not need to change any other parameters in this connection.

Make sure that the tables are marked green in the Connection window on the left. The detected cardinality is correct in this case and can be accepted by clicking OK. Click the SQL Assistant button. Choose Measure. Uncheck Automatically create classes and objects. Enter the name of the first folder stated in the table above into the Name field.

Click OK and do not change any of the other settings in the measure. Click OK and do not change any of the other settings in the dimension. Choose Dimension. Shop Name. Click Next. Run all possible integrity checks.. This connection can only be published to the repository and enables SAP BusinessObjects client tools to access SAP data sources directly without a universe.

Enter the following information: Here you have to create a project. For an OLAP connection it is not possible — and not necessary — to create a data foundation. The first step here is to create an new project in the Local Projects View or to choose an existing one. If you choose not to detect aggregation. The OLAP connection cannot be used in a data foundation so all you have to do now is to create a business layer on the connection: The following objects are only available in OLAP universes: If you decide not to choose a cube.

If you choose a cube users of the universe are only able to work with this cube. A hierarchy can contain levels. Calculated Members A calculated member is a member of a hierarchy that is calculated using an MDX expression e. Named Sets A named set is a collection of members of a hierarchy. Now you can select members or levels of the hierarchy for reporting. Multisource Universes Multisource-enabled data foundations support one or more relational connections.

Note that these connections are relational that means the fact. Creating Multisource Universes Lesson: Creating Multisource Universes Lesson Overview In this lesson you will learn to create multisource universes with the Information Design Tool and different kinds of data sources. Universes based on this type of data foundation can only be published to a repository and can not be published locally. Reasons for Multisource Universes In order to create and publish a universe with a multisource data foundation you have to build all the necessary resources for the universe first..

Note that multisource-enabled data foundations only support secured connections. After you have built the a desired relational connections in the SAP BusinessObjects BI Platform repository you need to create a multisource data foundation by following these steps: You specify the short name when adding the connection. After you have added connections to your data foundation you can insert tables from the different sources to your data foundation.

Default setting is automatic insertion of table. Expand the connection to see the database tables referenced in the connection.

In a multisource universe you can define joins that connect different data sources. To detect joins between tables referenced by different connections. The Insert Tables dialog box lists the connections defined in the data foundation. Follow these steps to create joins over different data sources in a multisource data foundation: Cardinalities can also be edited manually.

As in a single source data foundation you now define database keys. This color is used in the table header in data foundation views. Business Layers on multisource universes can be created in the same way as business layers for relational universes and allows you to create folder.

Joins between tables from multisource-enabled data foundations. Creating Multisource Universes The connections in a multisource-enabled data foundation have the following additional properties: You select the color when adding the connection. Create relational connections on the tables of an InfoProvider and use these connections in multi-source data foundations and business layers 2. The advantage here is that no universe has to be created and maintained and that all elements of the Business Explorer query can be used to prepare data for the needs of reporting users.

Query elements are for example filters, restricted key figures, calculated key figures, variables, hierarchies. If you use relational connections on an InfoProvider these elements are not available and you to create them otherwise:.

Business Explorer query feature Relational Universe workaround Calculated key figures, restricted key Use SQL expressions in measure figures, formulas definition in the universe BW variables Define prompts in dimension definition in the universe. There are limitations, for example for exit variables.

Filters Create filters in dimension definition in the universe Hierarchies No workaround available. Here it is useful to create multi-source universes. Be aware that when you use an InfoCube in a relational data foundation it can easily get confusing.

An InfoCube can have a fact table, up to 16 dimension tables and each dimension can contain up to characteristics which are connected with master data tables. However you can turn off automatic detection when you are adding a connection to a multi-source universe, for example if you want to use only few tables of the InfoProvider and join them with another data source.

As a conclusion there can be three different scenarios where you have to decide how to access SAP NetWeaver BW which can summarized as follows:. Exercise 4: Create a Multisource Universe Exercise Objectives After completing this exercise, you will be able to: Business Example You are searching for information about phone calls that customers have made at the customer support organization in different data sources.

Business users want to analyze calls for materials, material groups, and material types. Authentication Mode Use specified user name and password User name guest Password bobobo. Do not change any of the Configuration Parameters or Custom Parameters.

Use the following credentials to log on:. Create a multisource data foundation and create joins between the data sources you just created. Make sure you do not automatically create tables and joins for the SAP Netweaver BW connection check Advanced settings of the connection properties. Insert the following tables from the connections into the data foundation.

Create Joins between the tables and add the correct cardinality: Task 3: Use the multisource data foundation that you have just created in a business layer, check if query results are correct and export it as a universe to the BI Platform repository.

Create the following dimensions and measure:. Object Table field Dimension: Do not forget to save the business layer.

Execute the query and check the results. Publish the business layer as universe to BI Platform repository. Solution 4: Create a Multisource Universe Task 1: Select the cube and click OK then click Finish. Click Next and click Finish. If the expression is valid click OK. Change the dimension object to a measure by right-clinking it and choosing Turn into measure s.

Double-click the dimension object that appears and change the name to Material Name. Double-click the dimension object that appears and change the name to Material Type. Double-click the dimension object that appears and change the name to Material Group. Sum Do not forget to save the business layer. Click Finish. You should see values in all of the columns in the query result.

Switch to the query view and create a new query with result objects Material Group. Material Type. Material Name and the measure Number of Calls. Material Name. Execute the query and check the results.. Advanced Functions Enhance the Presentation of a Web Intelligence Document Create a Web Intelligence document based on an Existing Universe All rights reserved.. It provides the user the ability to create ad hoc new reports or change existing reports based on new business requirements.

SAP BusinessObjects Web Intelligence empowers the user to answer business questions using a simple and intuitive user interface and typically providing access to a broader range or data. SAP BusinessObjects Web Intelligence allows business users to dynamically create data-relevant queries; apply filters to the data; sort, slice, and dice through data; drill down; find exceptions; and create calculations.

Using SAP BusinessObjects Web Intelligence, you can easily create a simple sales report showing revenue broken down by several dimensions. Or you can change the sales report to show the top 10 areas based on revenue.

When you build a query in the SAP BusinessObjects Web Intelligence Query Panel, you select the universe objects and query filters that represent your business question.

The query is then sent to the database to retrieve the data mapped to the objects you selected. This information is then formatted and displayed in a SAP BusinessObjects Web Intelligence document as a simple table, or even a complex chart, ready for your analysis.

A BusinessObjects Web Intelligence document can contain multiple reports and each report may have been built using different queries. Once you run the query and retrieve the data that interests you, you can structure and organize the data as you wish in the SAP BusinessObjects Web Intelligence document. Once you have the data you need, you can display or present it in multiple ways.

Analyzing with SAP BusinessObjects Web Intelligence You can analyze your reports and switch your business perspective by dragging and dropping objects, inserting calculations, and changing the display to make the important information easy to see at a glance.

You can also perform multidimensional analysis by looking at results at a global level or drilling down to a more detailed level of information. Creating a new document involves two steps: Working in Application Modes You build queries, documents, and reports and analyze the data in reports using three application modes: Data, Reading and Design.

Depending on the mode you choose, the toolboxes and toolbars relevant to the mode are made available and other toolboxes and toolbars are either invisible or disabled. Mode Description Data In Data mode you create, edit and manage queries that supply data to reports. You can, for example, create a new data provider, rename a data provider, or change the source from which a data provider draws its data.

All the data providers used by the current document appear in a list in Data mode, and all toolboxes not related to working with data providers are disabled. Data view is not available in the HTML interface. Reading Reading mode allows you to view existing reports, search for text in reports, track changes in report data or drill down on report data.

The main application toolbar and the Left Panel are available in Reading mode. Toolboxes are not available.

Design Design mode allows you to perform a wide range of analysis tasks.

bics - SAP Business Objects.pdf

You can, for example, add and delete report elements such as tables or charts, apply conditional formatting rules, and enhance reports with formulas and variables. You can work with the report structure only in Design mode, or with the report populated with data.

Working with the report structure only allows you to make modifications without accessing the server. When you work with reports populated with data, each change you make is applied on the server. If you are making numerous modifications, we recommend to work with the report structure only, and to populate the report with data when you have finished your modifications.

You can apply filters at two levels within a document:. Comparing query filters and report filters Filter Description Query filter This filter is defined on the query; they limit the data retrieved from the data source and returned to the document. A query filter is created in the Query panel. There are four types of query filters that you can use in Web Intelligence: The data is still contained in the document; it is just hidden from the report display.

A report filter is created in the Report panel in the Design mode. Displaying Data in Tables The simplest style for displaying data is tables. Web Intelligence provides four different types of tables: When you first create a new document by building and running a query, the data retrieved is generally displayed in a vertical table.

Displaying Data in Charts You can create charts in one of three ways: Then Choose a chart type. Create a query filter to show only data for the store e-Fashion Dallas. Store name and the measure Sales revenue in that order and execute it to view the results.

Create a Web Intelligence document based on an existing universe Create a new Web Intelligence document based on the existing eFashion.

Switch from the Design mode to Reading mode and compare the displayed toolboxes and toolbars. You need to get familiar with the basic functions of Web Intelligence. Edit the document you just created to include a listing for Quantity sold by Year and Quarter. Create a report filter to show only data for the year In the Reading mode you perform simple viewing tasks. Create a query with the dimensions State. Your report should appear as shown below: Create a query filter to show only data for the store e-Fashion Dallas..

As you edit your reports in Web Intelligence documents. When you apply a break. Web Intelligence separates all the data for each unique value of the selected variable. As a long table can be tedious to read and understand. It inserts a blank row or column after each value.

You apply breaks on the data and values that you select. Using Breaks Breaks allow you to structure the data in a table into groups and make the data easier to view and interpret. The data becomes much clearer and simpler to read. You need a comprehensive overview of advanced functions of Web Intelligence. Average Calculates the average of the data. Advanced Functions Figure When you insert a break on a dimension.

Using Calculations Web Intelligence provides standard calculation functions to help you make quick calculations on the data in your reports. Count Counts all rows for a measure object or count distinct rows for a dimension or detail object. The following standard calculations are available: Using calculations Calculation Description Sum Calculates the sum of the selected data.

Minimum Displays the minimum value of the selected data. The grouped value appears as a header outside the block instead of remaining within the block when you are using breaks. The results of the percentage are displayed in an additional column or row of the table.

Percentage Displays the selected data as a percentage of the total. When you apply standard calculations to table columns. If standard calculations are not sufficient for your needs. To calculate the percentage of one measure compared to another measure.

Percentages are calculated for the selected measure compared to the total results for that measure on the table or break. Default Applies the default aggregation function to a standard measure. To add revenue per sale to the report. Grouping Information with Sections Sections allow you to split report information into smaller.

A custom calculation is a formula that can consist of report objects. Formulas have a calculation context that you can specify explicitly if you choose. One footer is added for each calculation. You have a report with Sales Revenue and Number Sold objects. Sorting dimensions and details helps you organize results chronologically.

Sorts in Web Intelligence allow you to apply the following orders: Custom sorts allow you to define your own order for the data displayed in a report. Depending on the type of data in the column or row. You can apply sorts to any dimensions. Grouping Information with Sections Using Sorts You can apply sorts to the results displayed in tables. You can also define tables and charts as input controls. Formatting Reports You can use the Format toolbar to format tables and charts in your Web Intelligence document.

The Page Setup toolbar allows you to modify the layout of your document. When you select a value in the table or chart. You define a variable with a constant value. You can use input controls to analyze different scenarios by changing the value of variables. They are grouped on the Input Controls tab on the Left Pane.

You can then change the value of the variable using the slider control. Input controls are report-specific. You define input controls using standard windows controls such as text boxes and radio buttons. When you select values in the input control. You associate these controls with report elements such as tables or section headers. You can. It is not possible to change between all data sources. Change Source. It consists of a Data pane that you use to explore the queries.

Another use case is. In Data view. You use the Data Manager by switching to Data view. Changing the Data Source of a Query You can change the data source of a query without losing query definition.

You can change the source of the data by mapping objects to different objects in the same query or in a different query. The following table lists the possible changes: Advanced Functions Highlighting Data Using Conditional Formatting Conditional formatting enables you to highlight results or change formatting based on data.

Managing Queries with the Web Intelligence Data Manager Data Manager is an application perspective in Web Intelligence allowing to manage all your data from one single place: Delete You can use the Data Manager to view.

This is useful. Excel BEx Change query possible Ad. In Web Intelligence Desktop. Change vanced possible Analysis workspace When you choose the query whose data source you want to change. You can change the data source in the Java interface or Web Intelligence Desktop only.

Create a new Web Intelligence document using the eFahion. Quarter and the measure Quantity sold. Use the existing eFashion. Remove all breaks and filter. Create sections on State and Year. Filter your report to show only data for Colorado.


Apply a break on the State and Year columns and set break properties. Add a sum and percentage to the Quantity sold column 5. Create a query showing State.

SAP BusinessObjects BI suite and SAP Analytics Cloud

Do not close the application. What is the difference between applying breaks and sections to a report? Advanced Functions Exercise 6: Deselect the Break Header checkbox.

Advanced Functions 3. Your report should display as follows: Using Breaks to Organize Data in a Report 6. Filter your report to show only data for Colorado.. Using Sections to Organize Data in a Report Advanced Functions 7. The difference is that by applying sections the grouped value appears as a header outside the block instead of remaining within the block.

A break only groups within a block. Advanced Functions Lesson Summary You should now be able to: You need a comprehensive overview of the connectivity options and how they integrate and complement each other. You need this information to understand the relationship between BEx queries and universes. The OLAP connection let you define access to: All characteristics.

Queries may have filters on characteristic values or filters on key figure values conditions assigned to select a certain slice of information from the InfoProvider. They may be parameterized by query variables. A reusable structure is a particular. Structures may contain a combination of key figures. Upon selection of an InfoProvider. All of the key figures for a particular InfoProvider are available for queries.

A filter may contain any combination of characteristics and their filter values. Use the formatted value instead if you need to keep the exact decimal setting in your report. A filter specifies the size of the subcube. These are described in the following table: Lower level nodes Lower level nodes are always shown after the main node. A calculated key figure is a formula consisting of basic.The Information Design Tool provides the following resources that a designer uses to extract metadata from relational or OLAP data sources and then to build a business layer of objects targeted to a specific user group: Specify the Datasource For any new report you want to create.

Group Records You may want to break data into meaningful groups. Web Intelligence This component is a self-service strategic tool that allows the business user to slice and dice the information and perform ad-hoc analysis of the multidimensional data. Benefits of Business Intelligence Business Intelligence can help organizations to: Folders and categories can be public or corporate or personal.

Using SAP BusinessObjects Web Intelligence, you can easily create a simple sales report showing revenue broken down by several dimensions. Remove decimal places from the Group Summary of Order Amount.

Upgrade from.


NANCIE from Davenport
Also read my other posts. One of my extra-curricular activities is indoor archery. I fancy reading books shrilly .