SAP Business Warehouse Reporting and Analysis Tools

SAP Business warehouse is used to extra data reporting and we can go for analysis with the data obtained.Here in this post we are going to explain this erp module works and what is the basic way of creating and extracting information available.BEx is the SAP BW element that provides flexible reporting and analysis tools that you ought to use for strategic analysis and supporting the decision-making process in your company. Employees with entry authorization can analyze historic and current data at differing levels of element and from different perspectives. BEx allows a wide spectrum of customers to entry info in SAP BW. This could be carried out in Enterprise Portal from an iView that you can name alongside the applications the place you extract the data, within the Web or Intranet, or utilizing a cell machine.

Net Application Design allows you to implement generic OLAP navigation in Internet purposes and in Enterprise Intelligence cockpits for each easy and extremely-particular person scenarios. Highly particular person situations with customer defined person interface parts may be realized using standard markup languages (HTML) for example. Web Application Design encompasses a wide spectrum of interactive Web-based mostly Enterprise Intelligence scenarios that you could modify to suit your requirements utilizing customary Web technology.

Portal Integration contains

(1) single point of entry,
(2) position-based staging of information,
(3) personalization,
(4) publication of iViews, and
(5) integration of unstructured data.

Question,Reporting, and Evaluation embody

(1) question design utilizing the BEx Analyzer,
(2) multi-dimensional (OLAP) evaluation,
(3) geographical evaluation,
(4) ad-hoc reporting, and
(5) alerts.

Net Utility Design includes

(1) interactive analytical content material,
(2) data cockpits and dashboards,
(3) foundation for creating analytical purposes,
(4) creation of iViews for a portal, and
(5) wizard-help.

Utilizing the SAP BW reporting features, you'll give you the option to evaluate a dataset from an InfoProvider according to numerous traits and key figures. To do this, you outline a question on your chosen InfoProvider in the BEx Query Designer. By selecting and combining the InfoObjects in a query, you identify the manner in which by which data from the chosen InfoProvider is evaluated.

You might have varied choices for calling up the Question Designer: From the BEx Analyzer open dialog box; As a separate program utilizing Begin → Applications → Business Explorer → Question Designer;Utilizing the Web Application Designer (see the BEx Net Software Designer unit); With Crystal Studies (Crystal Stories >=8.5 including CR add-ons for SAP).

The Open Dialog Box - When you select to access the Query Designer from the BEx Analyzer, the SAP BEx: Select Question dialog field is known as earlier than the Query Designer opens. This dialog box is context sensitive, which implies that it provides totally different decisions relying on the sort of object selected.

Object Kind: Dialog Box Accessible:

(1) Workbooks: History, Favorites, Roles,
(2) Queries: History, Favorites, Roles, InfoAreas,
(3) Stored Question Views: Historical past, Favorites, Roles, InfoAreas,and
(4) Exceptions: History, InfoAreas

Within the relevant dialog box, you may have the option of making a brand new query or of finding and deciding on an current query. You'll have the ability to then change or execute the query.

Exception: You use this function to define exceptions for a query. Note: Exceptions are deviations from normal key determine values, as defined by you, and are highlighted in colour in the executed query. Using the small arrow subsequent to the exceptions symbol, you may change or create exceptions.

For more data, see the Exceptions and Situations unit. You use this function to define situations for a query. Utilizing the small arrow next to the conditions symbol, you probably can change or create conditions. Notice: For every characteristic, you may give restrict situations to the key determine values with a view to determine, for instance, all sales revenues above or beneath a specified threshold value. The chosen characteristics are displayed in the query with restricted key figures.

Outline Cells: This function is simply available for queries with two structures. You can define formulas and choice situations for cells explicitly. On this approach, you management the values of cells that seem at the intersections of structural components. This perform allows you to entry particular person cells in queries or to assign special values to these.

Query Properties: Choose this operate if you want to change the description of the query or outline the settings for the outcome place, show options, numeric display, zero show and key date of the query.

To define a model new question, begin the Query Designer and choose New Query. Within the New Question: Select InfoProvider dialog field, select the required InfoProvider. Once you have selected the InfoProvider,the Query Designer shows as proven in the graphic.

The Question Designer is divided into six subareas: 1.Directory tree of the selected InfoProvider
Upon getting chosen the required InfoProvider, all accessible objects (dimensions, key figures, constructions) display within the listing tree in the left display screen area of the Question Designer.

To give you the option to find a question for which you already know part of the description or different information, select Find.

Within the Seek for Queries dialog field, enter the technical identify or description of the query. If needed, you probably can restrict the search to further criteria. Choose Discover .

If you are in the BEx Analyzer and have referred to as the search perform from the Choose Question dialog field, the question result shows as an Analyzer report. If you're using the search perform from the Question Designer, the query definition displays.

No comments :

Post a Comment