Index awareness creating universes with sap businessobjects. Using the function correctly can greatly improve the performance and user experience. The using functions, formulas and calculations in web intelligence guide provides detailed information on the advanced calculation capabilities available in when you perform data analysis. Add business layer folders create business layer dimension objects create time dimension objects create attribute objects lesson 3. Business objects interview questions and answers business. Information design tool user guide sap help portal. Sap businessobjects business intelligence suite document version. Is it possible to set up aggregate awareness in a universe with contexts and it will still work with objects from 2 contexts in one query. So if you have aggregate tables in your db, you will always get the summarised data as compared to detailed one. Index awareness is a feature that will help the idt use key columns while generating sql queries to speed up data retrieval. When a query is fired against the base table the query gets rewritten by query rewrite feature of materialized view. Universe design with sap businessobjects bi amazon s3. Ill start by listing the five steps to setting up aggregate awareness in a sap businessobjects universe. Jan 02, 2014 ill start by listing the five steps to setting up aggregate awareness in a sap businessobjects universe.
This you will see in setting up in navigation path. To use aggregate awareness in a universe, you need to arrange objects by aggregation level and objects are. Set up aggregate awareness to improve query performance. And you make the universe object aware to use those aggregate table at run time, if only summary info is required. Aggregate tables contain precalculated aggregated data. You can use multiple universes to solve a chasm trap in a webintelligence universe when multiple sql for measures cannot be used as there are dimension objects defined for one or both of the fact tables. Sap businessobjects web intelligence users guide sap help portal. The navigation map and report map panes list all the reports in a document. Ask your universe designer to remove the incompatibility between the objects.
A query based on an indexed database column will retrieve data faster than a normal column. This class is a combination of instructorled lecture, discussions, and demonstrations with a heavy emphasis on handson workshops to teach businessobjects 4. As per my experience good interviewers hardly plan to ask any particular question during your interview, normally questions start with some basic concept of the subject and later they continue based. When i try to aggregate that variable on the summary report bowi is not calculating correctly. Top 20 business objects interview questions and answers. Does power bi support aggregate awareness aggregate awareness is supported in obiee. Aggregate tables allow for faster querying speed and increases query performance manifolds. The business layer and its classesfolders and objects.
If you have summary tables and detailed tables and if you want the bo to pick up right table based on what kind of dimension objects you picked at the report level. Steps involved in enabling aggregate awareness are credits to complete reference business objects reference by cindi howson are. Aggregate tables are smaller than detail tables and can be aggregated in a number selection from sap businessobjects bi 4. Aggregate awareness is a feature that makes use of predefined aggregate tables to enhance the performance of sql transactions.
Well dig deeper into each step in the next section. In this tutorial, we are going to learn about aggregate awareness that is indeed one of the most powerful features of business objects. Jan 22, 2014 aggregate aware is one of the powerful functions in bo and very common famous function in business objects designer and reports. Using functions, formulas and calculations in web intelligence. Aggregate awareness the aggregate awareness feature is used to increase performance by leading the report query to select objects from the aggregated table instead of the detailed table at runtime. Have a look on designer pdf help files for more details about this. Aggregate awareness is a feature of designer that makes use of aggregate tables in a database. Aggregate awareness functionality will help me in achieving the same. Tutorials sap businessobjects information design tool 4. Sap universe designer aggregate awareness tutorialspoint. The purpose of these tables is to enhance the performance of sql transactions. Business objects training classes and business objects training in camp pune.
May 10, 2012 aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database. Information design tool user guide crystal reports. Aggregate awareness an aggregate table is a summary table that dbas build to execute queries faster. Business objects developer resume samples velvet jobs. New content is added as it becomes available, so check back on a regular basis.
If you are not using aggregate awareness you dont need to define incomatiblity objects. Book description the definitive reference for building actionable business intelligencecompletely revised for sap businessobjects bi 4. Sap business objects interview questions and answers. The following tutorials have been developed to help you get started using the business intelligence suite products. Topics to be covered include universe creation, creating relational database connections, creating data foundations, creating business layers, folders and objects, filters, table aliases, aggregate awareness, viewing table keys, publishing and securing universes, index awareness, universe maintenance, and converting 3. Audience the target audience for this course is anyone responsible for creating and designing universes using a businessobjects enterprise xi r2 or xi 3. Verify business object accuracy and integrity lesson 4. Aggregate aware is one of the powerful functions in bo and very common famous function in business objects designer and reports. Set sql options and sql generation parameters in the business layer properties. Insert the aggregate table into the universe and add the appropriate joins. The aa function takes multiple fields from multiple tables that have been inserted into your universe and determines which one to use depending on objects selected for a query by the.
Inserting a navigation path object into a business layer. Validating objects lesson objectives after completing this lesson, you will be able to. Aggregate awareness as the name suggest awareness will objects aware of the aggregate tables in the database. Created the new universes as well as customizing the old universes using aliases, contexts, aggregate awareness, aggregate navigation and hierarchies as per the requirements. List aggregate listagg listagg is a built in function that enables us to perform string aggregation natively. Free web intelligence best practices guide we put together a best practices guide for web intelligence development that includes over 20 pages of tips and techniques for developing business ready reports. Business objects training classes in puneerp academy.
The semantic layer offers a functionality called aggregate awareness which automatically makes the sql sentence optimally point to the highest aggregation level available in the schema for the requested result set. I used index awareness prompt in a parent report and child report. Business objects xi web intelligence aggregation issue 11. I am new to business objects and more specifically desktop intelligence. When i put this on the aggregate report it is doing the following. Go here to see the second part of our aggregate awareness series to see how to implement your new summary tables into a universe.
It is a concept which involves the creation of summary tables which leads to simplified storage of. Feb 03, 2015 relaxing jazz for work and study background instrumental concentration jazz for work and study duration. You can select the objects you want to perform integrity check. May 10, 2012 may 10, 2012 business objects leave a comment. By setting the month dimension as incompatable with the year fact aggregate navigation, the measure will selected from the month table. An aggregate table is summary table that dba build to execute querys faster. You can perform an integrity check on business layer. Before we get into the syntax, here is a quick overview of how the function works. T elling database to redirect to the desired query table based on selection objects in report so this will not track all the tables in db it will directly query from the aggregate table. Aggregate awareness function is used in scenarios where we have same fact tables in different grains.
When i remove aggregate awareness the universe works fine again, but then without aggregate awareness. Jun 02, 2014 zeek zeek, the region table is being used in the where clause. It will speeds up the execution of queries, improving the performance of sql transactions using database aggregate tables. Interview questions and answers free pdf download page 19 of 51 what are the 2 different approaches of implementing aggregate awareness. Thats why the choices within the aggregate aware measure are set from best to worst, left to right. Applying the aggregate awareness optimization method 17 lesson. Using contexts is the most effective way to solve chasm traps. Using this function we can define only one object for the measures in the fact tables. This creates two sql statements and two separate tables in business objects, avoiding the creation of a cartesian product.
Using aggregate awareness in conditions business objects. Through welldesigned universes, report designers and business users will be able to create reports without having to know anything about the underlying data source or structure. Introducing web intelligence bo architecture describing web intelligence concepts explaining web intelligence core functionality creating web intelligence documents with queries querying with web intelligence creating a new document modifying a documents query. Performance tuning in business objects environment sap. String aggregation or list aggregate listagg function in bo. Unleash the full potential of business intelligence with factbased decisions, aligned to business goals, using reports and dashboards that lead from insight to action. When this is possible, all queries regardless of reportingsql tool can benefit from the aggregations. Detect incompatability option is provided by bo in order to find out incompatible objects based on some crietria. Dec 19, 2012 once aggregate tables have been inserted into your data foundation, the next step to setting up aggregate awareness in a universe is to modify the select statement of certain objects in the business layer to make them aggregate aware.
Our previous reporting tool, business objects, allowed aggregate awareness. When we go for aggregate awareness in business objects do we need to insert the materialized view or the base table. In this tutorial, you will change the select statements for both a dimension and a measure. An aggregate table which summarises the above table by departure month amongst others. Experience in resolving join path problems, including loops and traps in the universes using aliases, contexts, and aggregate awareness in sap business objects designer experience with sap business objects reporting functionalities, including master detail, slice and dice, drilling methodology, filters, ranking, sections, and graphs and breaks. Aug 10, 2010 the second step is to set up the aggregate awareness function in your objects. The main idea of this feature is to use the available database index.
Dear readers, these sap webi interview questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of sap webi. Sap businessobjects business intelligence platform 4. Responsible for effort estimations for business objects universe and reports requirement. Top 20 business objects interview questions and answers pdf. The video versions of these tutorials on youtube include optional text captions that can be translated into a number of languages. There are times when you want to run query againts summary tables. Export a document as a pdf, text, excel or excel 2007 file. When i call child report using opendocument i pass key fields in the index awareness prompt. Sap universe designer is a tool used by businessobjects developers to create semantic layer between. Hi, if we have summarized data in the materialized view. Sep 29, 2014 if we did not use aggregate awareness, we would need to define separate objects for each of the fact tables which would be difficult to understand from a users point of view. Aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database.
The query objects exclude all possible sql choices for an aggregate aware function. Apr 20, 2010 steps involved in enabling aggregate awareness are credits to complete reference business objects reference by cindi howson are. If we did not use aggregate awareness, we would need to define separate objects for each of the fact tables which would be difficult to understand from a users point of view. Aggregate awareness is the ability of a universe to make use of aggregate tables in a database. For example, teradata now allows aggregate join indices aji. Aggregate awareness is a function in universe designer that makes use of aggregate tables.
Using an alias and the aggregate awareness function. The second step is to set up the aggregate awareness function in your objects. Identify all the possible definitions tablecolumn combinations of the objects. Map the star schema to understand which data columns do not work with the aggregate tables. Sap business objects developer resume example american. Applying the aggregate awareness optimization method. The ibi recommendation was to leverage database solutions for handling aggregate awareness. When we define aggegrate awareness, we manually define incompatible objects. Sum qty sum price total, in other words it is doing. Aggregate awareness improves the performance of a query by reducing the query fetch time. May 12, 2014 aggregate awareness functionality will help me in achieving the same. However, it can be solved easily by using aggregate awareness in business objects. Using index awareness and setting up a foreign key column on your object means that if no objects are used from that table in this case countrys then the foreign key column kicks in and takes the place of the object.
Dec 31, 2015 many of us are not aware of this listagg function in bo universe since this is an oracle 11g function and should work well in bo when you use oracle db. Right now i have issue when i try to link the index awareness prompt reports. Accessing an object from its path in the business layer. A demo with a couple of basicsimple tables where i. There are times when you want to run query againts summary tables rather then normal non aggregated tables because of the amount of data calculation is involved. An overview of aggregate awareness in business objects. Use aggregate aware function in objects that needs to be made aggregate aware. We are trying to use it as a reporting tool for our scientific data but running into issues when performing calculations to create objects and then trying to perform statistical or aggregate functions on them. There are three main steps to set up the aggregate awareness feature. Selection from creating universes with sap businessobjects book.
227 138 1390 1611 438 462 186 1672 365 1027 1540 928 323 1235 741 1049 1363 1597 1201 968 1378 1072 925 1093 1093 1508 11 539 621 1182 705 1437 121 1052 1104 1556 1293 649 491 186 209 454 496 270 499 1290 112 1200 1455 175