BO XI R1; BO XI R2; BO XI R3; BO XI R; BO XI R Later in the year , BO XI was introduced. SAP Webi has a three-layered architecture −. Question2: What are the key differences between BOXI R3 and SAP BO 4.x? Question3: How do Explain The Architecture Of Web Intelligence Tool? Answer . BO XI R2 Architecture (5 Tier’s). We have five tiers in BOXI if you have any PPT or document on BOXI R3 architecture, pl send me to my mail.

Author: Kajiktilar Gushicage
Country: Cyprus
Language: English (Spanish)
Genre: Love
Published (Last): 16 February 2008
Pages: 228
PDF File Size: 7.84 Mb
ePub File Size: 6.90 Mb
ISBN: 193-1-36297-341-2
Downloads: 96566
Price: Free* [*Free Regsitration Required]
Uploader: Daikree

Are you new to the business sector? Do you want to upgrade your skills? Are you unable to grasp the business objectives? Business objective web intelligence XI 3 is a management tool which is specifically created for the business users who need to produce effective reports using this tool. This helps the learners to analyse, access and share corporate data using business objectives. Search for the jobs on wisdomjobs to work as a web developer, web intelligence developer, business intelligence analyst, business object developer, data ware house developer, etc.

Candidates who want to grab the opportunity can look out the given below sample business objective web intelligence XI 3 interview questions and answers and update your skills. Deski is not available in BO 4. A Personal connection is created by one user and cannot be used by other users.

The connection details are stored in PDAC. A shared connection can be used by other users through a shared server. The connection details are stored in SDAC. LSI file in the Business Objects installation folder. However one cannot set rights and securities on objects in a shared connection.

Neither can a Universe to exported to repository using a shared connection. A secured connection overcomes these limitations. Through it rights can be set on objects and documents. Universes can be exported to the central repository only through a secured connection. The connection parameters in this case are saved in the CMS. What Is Bi Launchpad? You can set the preference for your BI Launchpad which determines which tool interface is launched via Launchpad. Create and edit all the queries in no data source Universes but not BEx queries in Web application.

It is three layered architecture: There are three different application modes that can be used to build the queries, create documents and to analyze the reports. Universe Flat files in. What Is A Query Panel?

You can select from list of available objects as per your access permissions. You may not be able to use few of the objects cos of permission. In query panel, you have Universe outline in left pane and Result objects, query filters, data preview panels in main pane. What Are Classes And Subclasses? Classes are used to group similar objects in a report. A class can contain one or more subclasses. Classes are used to organize objects in some logical manner.

While creating queries on Universe you can find the information on objects that you have to use in query. Members are defined at different level of hierarchies in a data source. Named set can be used to define set of members. A named set is defined as named expression and results a set of members.


You need not to create Universe for BEx queries and all attributes, hierarchies, dimensions and measures are automatically mapped in WebI document. Using a Relational connection created in Universe Designer.

What Are The Query Filters? Query filters are used to limit the rows returned in a WebI document. When you run a query, it only returns the rows that meet the query filter definition. Being an Area Sales Manager for NY, you want to see margin values for your region and Sales universe contains data from all the regions in United State.

Query filters are applied in Query Panel and they are used to limit the number of rows from data sources and to return the same in document.

Report filters are applied at report level on reports, tables, charts, etc. These filters are not used to limit the data retrieval from the data source and only hide certain values at report level. Why Do We Use Prompts? Prompt is defined as special filter for users which allows them to enter a value every time data is refreshed in the document.

Using prompts, you have multiple users viewing one document to display different sub set of data in database. Prompts allow you to retrieve the data from database and reduce the time.

Context defines a particular join path between tables or a specific group of joins for a particular query. Any objects created on a table column which belong to specific contexts is naturally compatible with all other objects from same contexts.

Contexts may be created using detect contexts feature or manually. They are generally created based on logical calculation and business requirements, hence the detect context method is not very effective. To manually create a context Go to Insert Context, give the context name and select the joins that should be present in the context.

For a universe contexts should be created in a way that all joins except shortcut joins fall in at least one context. What Is Aggregate Awareness Function? Why Do We Use It? Aggregate awareness function is used in scenarios where we have same fact tables in different grains.

SAP Business Objects Differences between BO and BI

Using this function boxj can define only one object for the measures in the fact tables. We also need to define dimensions for associated granularities and define their incompatibilities with the corresponding facts through the aggregate navigation. They are used to enhance the performance reports by utilizing arrogate tables available at database and are applied at Universe level as function. Subqueries provides you a more flexible option to filter the data as compared to an ordinary query filter.

You can also compare the values of objects in a subquery with the other objects. Using Subqueries, you can implement complex logic to limit the size of data which are not possible to apply with simple query filters.

Database ranking is done by editing the script generated by query. Hierarchical data is defined a data with Parent-child relationship and you can analyze the data at different levels of hierarchy. All the measures that are associated with hierarchical data are aggregated as per object level in hierarchy.


SAP Webi – Overview

Archittecture if you use this geographical hierarchy in report and want to analyze Number of Units sold at each level for different categories, then hierarchies allow you to use Aggregation at country level and if you drill down to state level, for each state too. Section breakup the data into multiple cells that are called Section arcitecture and Each Section header contains a value for dimension and data corresponding to dimension value. Break is used divides the data up into one block and each column carries dimension, attributes and measures and these values are repeated for each other row values in the block.

What Is Query Stripping? Query stripping feature optimizes the query to fetch only DATA which will be directly or indirectly rendered or displayed to the User, thus decreasing the response time and faster display of the report for the user. It is used in Query panel.

A query filter limits the data returned from the database.

A report filter allows selected data to display in a page and hides the other data. The report filter applies to all data blocks on the page. You can only display measures with synchronized dimensions.

When you use them for another purpose, duplicate values appear. All records that match the first query condition and not the second condition. Conditional Formatting is used to highlight some specific values in the report. If you want you can show specific low or high values with some specific colors.


How You Can Use This? This option allows you to merge the data from different data sources. Assume that you have created Query 1 and Query 2 in Query Panel. When you combine both the queries in a single WebI report, objects from both the queries are shown in list of available objects. What Is An Input Context? The input context is the list of dimensions that are included in the calculation itself.

SAP Webi Overview

In Associate dimension, select the unique object from the same query. Yes, by using send by email attachment option. How You Can Resolve This? When you use Arcihtecture as option, on right side architectire get many options — Refresh on open, Permanent Regional formatting, Save for all users, Remove document Security. Input controls are used to filter and analyze the report data. You define input controls using text boxes and radio buttons.

Input controls are associated with report elements like tables and section headers and use control to apply filter on report elements. When you select a value of an input control, it filters the values in report element that is associated with input control by selected value. Using Report Conversion Tool Question 4. Secured connection published to Repository. Various data sources architectuer be used to create analytical and ad-hoc reports.