Mod Xi 3 Analyzing The Data Business Objects Xi

60 %
40 %
Information about Mod Xi 3 Analyzing The Data Business Objects Xi

Published on May 19, 2008

Author: wsmiller

Source: slideshare.net

Description

Business Objects XI R2 Web intelligence Analyze the data

Module 3 Business Objects XI Web Intelligence Data Analysis

Analyzing the Data In Module 2 we viewed, refreshed, and navigated a Web Intelligence document. In module 3 we interact with a report further to discover new insights. You will be exploring data within an existing report to make it more meaningful. Such an analysis can range from viewing information in a different block style such as tabular or chart, to re-sorting, filtering, and drilling down into the details. This report-based analysis is aimed at report consumers, not just power users. Thus, many of the actions are available via right-mouse clicks. Also all the analysis discussed in this module is available via a zero-footprint browser; you do not have to launch the full-blown Java Report Panel

In Module 2 we viewed, refreshed, and navigated a Web Intelligence document. In module 3 we interact with a report further to discover new insights. You will be exploring data within an existing report to make it more meaningful. Such an analysis can range from viewing information in a different block style such as tabular or chart, to re-sorting, filtering, and drilling down into the details. This report-based analysis is aimed at report consumers, not just power users. Thus, many of the actions are available via right-mouse clicks. Also all the analysis discussed in this module is available via a zero-footprint browser; you do not have to launch the full-blown Java Report Panel

Analyzing the Data However, while drill mode is supported in both the Java Server Pages (JSP) and Active Server Pages (ASP) versions of Web Intelligence, the HTML Interactive Viewer for on-report sorting and filtering is available only in the JSP version, you will have to modify the report to launch the Java Report panel to access some of the features discussed in this module.

However, while drill mode is supported in both the Java Server Pages (JSP) and Active Server Pages (ASP) versions of Web Intelligence, the HTML Interactive Viewer for on-report sorting and filtering is available only in the JSP version, you will have to modify the report to launch the Java Report panel to access some of the features discussed in this module.

Analyzing the Data

Analyzing the Data The HTML Interactive Viewer In order to open a document with the HTML Interactive Viewer, you must set your InfoView Preferences for Web Intelligence as shown in module 1. Note that with the Interactive Viewer, you now have an additional toolbar for formatting the report, an Edit button to modify the report or query, an Insert pull-down menu, and additional options in the Document and View pull-down menus. The left panel in the HTML Interactive viewer is called the Context panel.

The HTML Interactive Viewer

In order to open a document with the HTML Interactive Viewer, you must set your InfoView Preferences for Web Intelligence as shown in module 1. Note that with the Interactive Viewer, you now have an additional toolbar for formatting the report, an Edit button to modify the report or query, an Insert pull-down menu, and additional options in the Document and View pull-down menus. The left panel in the HTML Interactive viewer is called the Context panel.

Analyzing the Data The HTML Interactive Viewer It has may more capabilities than the standard HTML viewer, including the ability to see additional objects in the query (but perhaps not displayed in the report) and a data summary that displays a description of each object. Report consumers as well as query authors can clearly see the universe object descriptions. From the Document menu, you now have a Document > Properties option that displays the report author, document description, last modification date, and duration of the query refresh.

The HTML Interactive Viewer

It has may more capabilities than the standard HTML viewer, including the ability to see additional objects in the query (but perhaps not displayed in the report) and a data summary that displays a description of each object. Report consumers as well as query authors can clearly see the universe object descriptions.

From the Document menu, you now have a Document > Properties option that displays the report author, document description, last modification date, and duration of the query refresh.

Analyzing the Data Report Toolbar Modify a report or query The HTML Interactive Viewer

Analyzing the Data The HTML Interactive Viewer From the View menu, you have additional option to view toolbars (Formatting, report, formula) as well as formatting and query preferences.

The HTML Interactive Viewer

From the View menu, you have additional option to view toolbars (Formatting, report, formula) as well as formatting and query preferences.

Analyzing the Data Actions Available via the Report Toolbar

Analyzing the Data Block Types In module 2, the different components of a web Intelligence report were explained and the concept of a block introduced. A block is a set of data that contains column headings, row headings, and data values. Business Objects allows several block types: table, crosstab, form, and chart. A master/detail is a type of a report but not specifically a block style. Within a master/detail report you specify a block style to appear in each section. A report can contain multiple block types. For example, in our previous document has both table block and a chart block. Each block can be populated from the same or a different query.

Block Types

In module 2, the different components of a web Intelligence report were explained and the concept of a block introduced. A block is a set of data that contains column headings, row headings, and data values. Business Objects allows several block types: table, crosstab, form, and chart. A master/detail is a type of a report but not specifically a block style. Within a master/detail report you specify a block style to appear in each section. A report can contain multiple block types. For example, in our previous document has both table block and a chart block. Each block can be populated from the same or a different query.

Analyzing the Data You can change block styles or duplicate a block and convert a style. Block Types Use When Table You want to detail information in a list or spreadsheet style. You may break the list into section in a master/detail report or with breaks. Tables can contain additional columns for many dimension, details, and measures. Chart You want to discover trends and patterns by exploring summary, not detail. Numbers in a visual format. Charts are ideal for analyzing a limited number of measures by a limited number of dimensions. Crosstabs Your want to compare measures by different points within a given dimension. A crosstab is a particular kind of table layout that lets you compare actual sales with budget sales, for example, or to compare data from one period to the next. Form You want to see many details for a particular product, customer, or record. Instead of viewing a very wide report in which a lot of details are displayed on one row, a form lets you view the details vertically.

Table When you initially create a new query, Web Intelligence uses the default block type of table. A table is a spreadsheet-style block that lists data in rows and columns. In this example, you will change a chart to a table to further analyze the individual data values. Assume your report displays a horizontal, stacked bar chart. This is a good way to quickly identify that Colorado and Maryland have the high count. However, you cannot readily tell from this chart the specific values. Nor can you easily see the performance by individual month. Analyzing the Data

Table

When you initially create a new query, Web Intelligence uses the default block type of table. A table is a spreadsheet-style block that lists data in rows and columns. In this example, you will change a chart to a table to further analyze the individual data values. Assume your report displays a horizontal, stacked bar chart. This is a good way to quickly identify that Colorado and Maryland have the high count. However, you cannot readily tell from this chart the specific values. Nor can you easily see the performance by individual month.

Analyzing the Data Chart

Chart

Analyzing the Data Left click on the chart to select the chart. Right-click to invoke the pop_up menu. Select Turn Chart To. A Turn To dialog appears. Here you can select a different chart style or, in this example, select Tables.

Left click on the chart to select the chart.

Right-click to invoke the pop_up menu. Select Turn Chart To.

A Turn To dialog appears. Here you can select a different chart style or, in this example, select Tables.

Analyzing the Data

Within each Type, you will see several thumbnails that indicate a subtype. Select Vertical Table and then click OK to close the Turn To Dialog. The horizontal chart now appears as follows, giving a clearer breakdown of the counts per month. Also, you can more easily see that counts are higher for Colorado than for Maryland only in 2005. Analyzing the Data

Within each Type, you will see several thumbnails that indicate a subtype. Select Vertical Table and then click OK to close the Turn To Dialog. The horizontal chart now appears as follows, giving a clearer breakdown of the counts per month. Also, you can more easily see that counts are higher for Colorado than for Maryland only in 2005.

Analyzing the Data

Crosstab The vertical table in the preceding section displays individual column data values. Inter column relationship comparisons are a challenge. A crosstab is the best block style for quick comparisons and transposes what may originally be rows in a tabular report to column heading. People frequently use crosstabs for the following types of analysis: Incident counts by year, quarter, or month Financial measures by actual and budget Met SLA by region Analyzing the Data

Crosstab

The vertical table in the preceding section displays individual column data values. Inter column relationship comparisons are a challenge. A crosstab is the best block style for quick comparisons and transposes what may originally be rows in a tabular report to column heading. People frequently use crosstabs for the following types of analysis:

Incident counts by year, quarter, or month

Financial measures by actual and budget

Met SLA by region

Crosstab To convert a block to a crosstab: Select the block Right click to invoke the pop-up menu. Select Turn Table To Within the Turn To dialog, select Tables, and then select the Crosstab thumbnail Click OK to close the dialog an see the crosstab. Analyzing the Data

Crosstab

To convert a block to a crosstab:

Select the block

Right click to invoke the pop-up menu.

Select Turn Table To

Within the Turn To dialog, select Tables, and then select the Crosstab thumbnail

Click OK to close the dialog an see the crosstab.

Analyzing the Data Crosstab

Crosstab

Crosstab With converting a block to a crosstab, you cannot specify which dimensions appear on top and which appear in each row. Web Intelligence takes its best guess, You can easily swap the row and column headings. For example, to have the years appear across the top and the states appear vertically, follow these steps: Select the existing crosstab block that you wish to convert. Right-click to invoke the pop-menu. Select Swap Axis. The crosstab now appears as follows. Using the Java report panel you can drag and drop column and row headings. Analyzing the Data

Crosstab

With converting a block to a crosstab, you cannot specify which dimensions appear on top and which appear in each row. Web Intelligence takes its best guess, You can easily swap the row and column headings. For example, to have the years appear across the top and the states appear vertically, follow these steps:

Select the existing crosstab block that you wish to convert.

Right-click to invoke the pop-menu. Select Swap Axis.

The crosstab now appears as follows.

Using the Java report panel you can drag and drop column and row headings.

Analyzing the Data

Chart Charts are a powerful way to uncover trends and patterns in your data. Chars can transform a dense page of numbers into a visual that quickly highlights opportunities and problems. Web Intelligence provides numerous chart styles. Often when you want to chart data, you only need a subset of the data that may appear in a table. In such a situation, try using the Duplicate button to first duplicate the table and then convert it to a chart. Analyzing the Data

Chart

Charts are a powerful way to uncover trends and patterns in your data. Chars can transform a dense page of numbers into a visual that quickly highlights opportunities and problems. Web Intelligence provides numerous chart styles.

Often when you want to chart data, you only need a subset of the data that may appear in a table. In such a situation, try using the Duplicate button to first duplicate the table and then convert it to a chart.

Chart Procedure Select the tabular block that you wish to graph From the Report toolbar, select Duplicate. If you wish the chart to appear to the right of the table, select To The Right. If you want the chart to appear beneath the table or at the end of the report choose At The End. Modify the duplicated table to remove any extra columns or to further filter the data. Select the duplicated table and right-click to invoke the pop-menu. Select Turn Table To. From the Turn Table To dialog, select the desired chart style, then click OK. Analyzing the Data

Chart Procedure

Select the tabular block that you wish to graph

From the Report toolbar, select Duplicate. If you wish the chart to appear to the right of the table, select To The Right. If you want the chart to appear beneath the table or at the end of the report choose At The End.

Modify the duplicated table to remove any extra columns or to further filter the data.

Select the duplicated table and right-click to invoke the pop-menu. Select Turn Table To.

From the Turn Table To dialog, select the desired chart style, then click OK.

Insert a New Report and Block Using the pop-up menus and Turn To are the easiest, and most intuitive way to view information in different block styles. Alternatively, from within the Interactive Viewer, you can also use the left panel to insert new block or change the style of an existing one. When you insert a new block, you are not creating a new query. Instead, you are displaying data that already exists in the document in a new block style. Analyzing the Data

Insert a New Report and Block

Using the pop-up menus and Turn To are the easiest, and most intuitive way to view information in different block styles. Alternatively, from within the Interactive Viewer, you can also use the left panel to insert new block or change the style of an existing one. When you insert a new block, you are not creating a new query. Instead, you are displaying data that already exists in the document in a new block style.

Master/Detail A master/detail report is a particular kind of report in which a dimension value is used to separate different blocks. Master/detail reports allow you to analyze data within a particular subset. The earlier report slide is an example of a master/detail report and contains a crosstab and a 3D line chart for each Day. Analyzing the Data

Master/Detail

A master/detail report is a particular kind of report in which a dimension value is used to separate different blocks. Master/detail reports allow you to analyze data within a particular subset. The earlier report slide is an example of a master/detail report and contains a crosstab and a 3D line chart for each Day.

Master/Detail Analyzing the Data Click here to set as section

Master/Detail

Master/Detail To change an existing column in a report to a section header, click anywhere in the column and then right-click to invoke the pop-up menu. Assuming you have correctly selected a dimension column, the pop-up menu contains an option Set as Section. In this example, the category existed as a column in the crosstab. However, if it did not exist in the block you can create a master/detail report by dragging an object onto the report page. Analyzing the Data

Master/Detail

To change an existing column in a report to a section header, click anywhere in the column and then right-click to invoke the pop-up menu. Assuming you have correctly selected a dimension column, the pop-up menu contains an option Set as Section.

In this example, the category existed as a column in the crosstab. However, if it did not exist in the block you can create a master/detail report by dragging an object onto the report page.

Master/Detail Display the Left panel by clicking the arrow to show left pane or selecting View > Left Panel. From the Left panel Drop-down, choose Available Objects. This shows you all objects that may be stored as part of the query results but that are not necessarily displayed in the block, Drag the Type object form the Left panel to the report. In order to create a section header, you must drop the object in the upper-left corner, just above the table. Pay careful attention to the shape and position of the mouse pointer. Analyzing the Data

Master/Detail

Display the Left panel by clicking the arrow to show left pane or selecting View > Left Panel.

From the Left panel Drop-down, choose Available Objects. This shows you all objects that may be stored as part of the query results but that are not necessarily displayed in the block,

Drag the Type object form the Left panel to the report. In order to create a section header, you must drop the object in the upper-left corner, just above the table. Pay careful attention to the shape and position of the mouse pointer.

Master/Detail Analyzing the Data

Master/Detail

Master/Detail (HTML Report Panel) Analyzing the Data Drag and drop 4. When you drop the object into the report, If you do not get the desired results, click undo and try again.

Master/Detail (HTML Report Panel)

Master/Detail (HTML Report Panel) Note The HTML Interactive Viewer has a multilevel undo, But the Java panel allows you to undo only the last action Analyzing the Data

Master/Detail (HTML Report Panel)

Note The HTML Interactive Viewer has a multilevel undo, But the Java panel allows you to undo only the last action

Sort Sorting data within a report allows you to rearrange the rows alphabetically, or if your sort is on a measure column, numerically. For example, you can use sort to find locations with the highest counts. When you want to analyze data within a subset by using Breaks, the breaks take priority over the sorts. In the following example, you will sort counts in descending order to quickly identify which locations have the highest counts. Select the column you wish to sort within the table. Web Intelligence highlights the selected column with a gray box. Click Descending Sort from the Report toolbar. Analyzing the Data

Sort

Sorting data within a report allows you to rearrange the rows alphabetically, or if your sort is on a measure column, numerically. For example, you can use sort to find locations with the highest counts. When you want to analyze data within a subset by using Breaks, the breaks take priority over the sorts. In the following example, you will sort counts in descending order to quickly identify which locations have the highest counts.

Select the column you wish to sort within the table.

Web Intelligence highlights the selected column with a gray box.

Click Descending Sort from the Report toolbar.

Sort Priority When you want to have multiple sorts within a table, use the pop-up menu to set the sort priority. To access the sort priorities, select the table and then right click. From the pop-up menu, select Sort > Properties. For example, compare the priorities and results shown in the examples below. The data is sorted in descending order of counts and then by state. Analyzing the Data

Sort Priority

When you want to have multiple sorts within a table, use the pop-up menu to set the sort priority. To access the sort priorities, select the table and then right click. From the pop-up menu, select Sort > Properties. For example, compare the priorities and results shown in the examples below. The data is sorted in descending order of counts and then by state.

Sort Analyzing the Data

Sort

Sort Analyzing the Data

Sort

Sort Analyzing the Data

Sort

Breaks A Break will break the table into multiple pieces so that you can better analyze the data within a group. A master/detail report is somewhat similar, except that a break does not create a separate master cell. Also, a break column must exist in the table, whereas a section header in a master/detail report does not have to exist in the table. Finally, breaks give you additional options for keeping tables together for printing. Once you create a break, you then use Calculation to generate subtotals. The first break column becomes the primary sort order. Often, this is the first column in the table, but it does not have to be. Analyzing the Data

Breaks

A Break will break the table into multiple pieces so that you can better analyze the data within a group. A master/detail report is somewhat similar, except that a break does not create a separate master cell. Also, a break column must exist in the table, whereas a section header in a master/detail report does not have to exist in the table. Finally, breaks give you additional options for keeping tables together for printing.

Once you create a break, you then use Calculation to generate subtotals. The first break column becomes the primary sort order. Often, this is the first column in the table, but it does not have to be.

Breaks Using the same table from the Sort section, add a break to the state column; Select the State Column Select Insert Break from the Report toolbar. Web Intelligence will insert the break and by default add the state as a break footer. Caution The break button on the toolbar acts as a toggle to add or remove breaks. If you inadvertently click this when what you really wanted to do was check the break properties, you will lose all your subtotals and other break settings. Use the Undo to restore them and be sure to use the pop-up menu when you want to change Break Properties. Analyzing the Data

Breaks

Using the same table from the Sort section, add a break to the state column;

Select the State Column

Select Insert Break from the Report toolbar. Web Intelligence will insert the break and by default add the state as a break footer.

Caution The break button on the toolbar acts as a toggle to add or remove breaks. If you inadvertently click this when what you really wanted to do was check the break properties, you will lose all your subtotals and other break settings. Use the Undo to restore them and be sure to use the pop-up menu when you want to change Break Properties.

Breaks Analyzing the Data Remove duplicate Break Header Break Footer Use Breaks to group the data into what appears as mini-tables

Breaks

Breaks For each state, there is now a separate mini-table. Visually, you can now more clearly see the performance from one year to another. Note Although breaks make the data appear as if they are in separate mini-tables, in the strict sense, Web Intelligence still treats the table as one block, an important nuance when formatting the table. The Format > Table options will be the same for both the California and Colorado mini tables Analyzing the Data

Breaks

For each state, there is now a separate mini-table. Visually, you can now more clearly see the performance from one year to another.

Note Although breaks make the data appear as if they are in separate mini-tables, in the strict sense, Web Intelligence still treats the table as one block, an important nuance when formatting the table. The Format > Table options will be the same for both the California and Colorado mini tables

Break Options The effects of certain break options, such as break header, break footer, and remove duplicates can be modified by right-click the table and from the pop-up-menu, select Break > Properties. Analyzing the Data

Break Options

The effects of certain break options, such as break header, break footer, and remove duplicates can be modified by right-click the table and from the pop-up-menu, select Break > Properties.

Analyzing the Data Break Options

Break Options Break Header Repeats the column headings within each mini-table. If your table contains more than one Break Header for each break, certain multiple rows of column headings. To avoid this, set the Break Header only on the first break (or one of the largest grouping for which you want to create a separate mini-table). Break Footer Inserts a separate row beneath each mini-table. The Calculation subtotals (not yet inserted) will appear in the break footer. Analyzing the Data

Break Options

Break Header Repeats the column headings within each mini-table. If your table contains more than one Break Header for each break, certain multiple rows of column headings. To avoid this, set the Break Header only on the first break (or one of the largest grouping for which you want to create a separate mini-table).

Break Footer Inserts a separate row beneath each mini-table. The Calculation subtotals (not yet inserted) will appear in the break footer.

Break Options Remove Duplicates If you want the break value repeated only once in the first row of the mini-table, use this option. As shown, the state name CA appears only in the first row of the table. Without this option set, California would be repeated in each row of the mini-table. Center Value Across Break Works with the Remove Duplicates option so that the break value is centered within the rows of the table. (Note This was not working as of XI R2 ) Analyzing the Data

Break Options

Remove Duplicates If you want the break value repeated only once in the first row of the mini-table, use this option. As shown, the state name CA appears only in the first row of the table. Without this option set, California would be repeated in each row of the mini-table.

Center Value Across Break Works with the Remove Duplicates option so that the break value is centered within the rows of the table.

(Note This was not working as of XI R2 )

Break Options Note Do not confuse the term break “value” with calculation values that may appear in the row of a break footer. A break value is the value from the dimension---in this example California and Colorado etc.. A calculation value would be the subtotals We will discuss table formatting in another learning module. Printing mini-tables, created with breaks, are affected by the following options. Start a New Page For each break level, print the mini-table on a new page. This print setting is useful when you intended to distribute each break level to a different person—for example, if you have different service managers and have a break on location. Analyzing the Data

Break Options

Note Do not confuse the term break “value” with calculation values that may appear in the row of a break footer. A break value is the value from the dimension---in this example California and Colorado etc.. A calculation value would be the subtotals

We will discuss table formatting in another learning module.

Printing mini-tables, created with breaks, are affected by the following options.

Start a New Page For each break level, print the mini-table on a new page. This print setting is useful when you intended to distribute each break level to a different person—for example, if you have different service managers and have a break on location.

Break Options Avoid Page Breaks in Block use this option to force Web Intelligence to start the break or mini-table on a new page. For breaks that contain many rows of data, particularly long tables it may not be possible to avoid a break in the middle of the mini-table. If the grouping of data is longer than a page and not the first grouping of data in the block, a page break will occur before the break and the mini-table will span multiple pages. Repeat the Header on Every Page For each page break, repeat the column headings. Analyzing the Data

Break Options

Avoid Page Breaks in Block use this option to force Web Intelligence to start the break or mini-table on a new page. For breaks that contain many rows of data, particularly long tables it may not be possible to avoid a break in the middle of the mini-table. If the grouping of data is longer than a page and not the first grouping of data in the block, a page break will occur before the break and the mini-table will span multiple pages.

Repeat the Header on Every Page For each page break, repeat the column headings.

Break Options Repeat Break value on new Page For mini-tables that span multiple pages, repeat the break value in the first row of each page. If you choose to repeat the header as well, then the row with the break value is repeated beneath the column headings. Analyzing the Data

Break Options

Repeat Break value on new Page For mini-tables that span multiple pages, repeat the break value in the first row of each page. If you choose to repeat the header as well, then the row with the break value is repeated beneath the column headings.

Calculations Calculations allow you to add subtotals to a table that contains breaks. If the table does not contain any breaks, then the calculations are grand totals for the entire block. In most instances, if you ad a calculation to one measure, you will want them on all measures in a report. The subtotals are inserted as formulas in the break footer. The Calculation dialog box is context-sensitive, depending on the object type (character, date, number). For example you may want to count the number of states in which you have stores, but this is not something you would sum or average. Analyzing the Data

Calculations

Calculations allow you to add subtotals to a table that contains breaks. If the table does not contain any breaks, then the calculations are grand totals for the entire block. In most instances, if you ad a calculation to one measure, you will want them on all measures in a report. The subtotals are inserted as formulas in the break footer. The Calculation dialog box is context-sensitive, depending on the object type (character, date, number). For example you may want to count the number of states in which you have stores, but this is not something you would sum or average.

Calculations that Allow you to Create Subtotals Analyzing the Data Calculation Explanation Formula SUM Adds the values for a particular measure. SUM is the default calculation when you first apply a calculation to a variable. However, SUM may not make sense for certain measures such as ratios and percentages. =SUM([Measure Variable]) Count Counts the unique values within a break. Use this with dimension or detail objects =COUNT([Dimension Variable])

Calculations that Allow you to Create Subtotals

Calculations that Allow you to Create Subtotals Analyzing the Data Calculation Explanation Formula Average Calculates the average based on the individual measures displayed in the table. If you hide certain rows of data through a filter, the values from the hidden rows do not , by default affect the subtotal. Average is not a weighted average, so for things like average price, you may want to create a formula to get a weighted average or use extended syntax. =AVERAGE([Measure Variable]) Minimum Displays the minimum value for a particular measure within the break. =MIN([Measure Variable])

Calculations that Allow you to Create Subtotals

Calculations that Allow you to Create Subtotals Analyzing the Data Calculation Explanation Formula Maximum Displays the maximum value for a particular measure within the break. =MAX([Measure Variable]) Percentage Calculates the percentage contribution a particular break level makes to the grand total, In addition, it inserts a new column in the table that shows the percentage each row contributes to the individual break level. This calculation uses the Context Operator ForAll. =Percentage([Measure Variable]) ForAll([Dimension Variable])

Calculations that Allow you to Create Subtotals

inserting calculation, Web Intelligence automatically add a grand total to the end of the report. Use the page navigation buttons to scroll to the last page to see the grand totals the following report shows a sum calculation and a percentage calculation in the break footer. Analyzing the Data

inserting calculation, Web Intelligence automatically add a grand total to the end of the report. Use the page navigation buttons to scroll to the last page to see the grand totals the following report shows a sum calculation and a percentage calculation in the break footer.

Analyzing the Data

To add Total SR Count to the table Select the SR Count column. Click the Calculation drop-down from the report toolbar . Select Sum Tip Consider formatting the break footer row so that your subtotals stand out. Analyzing the Data

To add Total SR Count to the table

Select the SR Count column.

Click the Calculation drop-down from the report toolbar .

Select Sum

Tip Consider formatting the break footer row so that your subtotals stand out.

Note If you do not have your break options set to include a break footer, the calculations are inserted only as grand totals at the end of the report. Also, if you apply a break after you have inserted calculations, the calculations are not repeated in the break footer and remains as grand totals. To have them appear as subtotals in the break footer, first set the break , then insert the calculations. Analyzing the Data

Note If you do not have your break options set to include a break footer, the calculations are inserted only as grand totals at the end of the report. Also, if you apply a break after you have inserted calculations, the calculations are not repeated in the break footer and remains as grand totals. To have them appear as subtotals in the break footer, first set the break , then insert the calculations.

Filter As you apply breaks, sorts and calculations, you may find that you want to focus on one or more subsets within the report. Filters allow you to restrict the number of rows displayed in the report. They do not affect the query results; they affect only the data currently displayed in the block. It’s important to understand that the calculations will also change to reflect only what is displayed. In the previous report, the table displayed several year of data. To focus on the year 2005, Insert a filter on year. Analyzing the Data

Filter

As you apply breaks, sorts and calculations, you may find that you want to focus on one or more subsets within the report. Filters allow you to restrict the number of rows displayed in the report. They do not affect the query results; they affect only the data currently displayed in the block. It’s important to understand that the calculations will also change to reflect only what is displayed. In the previous report, the table displayed several year of data. To focus on the year 2005, Insert a filter on year.

Filter Position your mouse in the table on the year column Select Apply Filter from the Report toolbar or right-click to invoke the pop-up menu and select Quick Filter. Web Intelligence displays a list of values available in the report. You can either enter the text to filter on or choose the year from the list in example select 2005 and click >> to add it to the box on the right. Note normally this is only a subset of the list of values in the entire database. Analyzing the Data

Filter

Position your mouse in the table on the year column

Select Apply Filter from the Report toolbar or right-click to invoke the pop-up menu and select Quick Filter.

Web Intelligence displays a list of values available in the report. You can either enter the text to filter on or choose the year from the list in example select 2005 and click >> to add it to the box on the right.

Note normally this is only a subset of the list of values in the entire database.

Filter By default, Web Intelligence uses the In List operator to allow you to select multiple values. However, you can use the drop-down to choose Between, Not Null, and so. Operators are discussed later. Click OK to see the effect of the filter. Analyzing the Data Enter filter Value Choose filter value Available operators Filter value

Filter

By default, Web Intelligence uses the In List operator to allow you to select multiple values. However, you can use the drop-down to choose Between, Not Null, and so. Operators are discussed later.

Click OK to see the effect of the filter.

Removing the Filter To remove the filter, you must use the left panel, Document Structure And Filters. You cannot use the quick Filter button. For example, assume you want to remove the filter on Year 2005. If you invoke the Quick Filter dialog and simply remove 2005 from the right hand box, Web Intelligence will attempt to filter the years for nulls. Display the left panel by selecting view > Left Panel, or click the arrow icon. From the left Panel drop-down, select Document Structure and Filters. Analyzing the Data

Removing the Filter

To remove the filter, you must use the left panel, Document Structure And Filters. You cannot use the quick Filter button. For example, assume you want to remove the filter on Year 2005. If you invoke the Quick Filter dialog and simply remove 2005 from the right hand box, Web Intelligence will attempt to filter the years for nulls.

Display the left panel by selecting view > Left Panel, or click the arrow icon.

From the left Panel drop-down, select Document Structure and Filters.

Removing the Filter Here you can see the underlying component of each report. The top row gives the name of the document. Immediately beneath this are the prompts or query filters. This is different from report filters that affect the display only. Here we are working with report filters. In this example, there is one report tab called “Breaks, Sums and percent” There are two blocks, a table block and a pie Block. Move your mouse pointer to this filter until it is highlighted with a red box. Note the filter on the Table for Year in List 2005. Analyzing the Data

Removing the Filter

Here you can see the underlying component of each report. The top row gives the name of the document. Immediately beneath this are the prompts or query filters. This is different from report filters that affect the display only. Here we are working with report filters. In this example, there is one report tab called “Breaks, Sums and percent” There are two blocks, a table block and a pie Block. Move your mouse pointer to this filter until it is highlighted with a red box.

Note the filter on the Table for Year in List 2005.

Removing the Filter Right-click to invoke a pop-up menu and select Remove Filter. Analyzing the Data Report tab Document title Filter

Removing the Filter

Right-click to invoke a pop-up menu and select Remove Filter.

Measure Filters Filters in Web Intelligence XI Release 2 are simpler in many respects from filters in previous versions of the full client. Measure filters used to require a defining a formula as did nesting filters. Now, you easily filter on measures by entering a value to compare to. For example, to find which states have a number of incidents less than 3,000 per quarter do the following. Select the SR Count column. Click Apply Filter from the Report toolbar or right-click to invoke the pop-up menu and select Quick Filter. Analyzing the Data

Measure Filters

Filters in Web Intelligence XI Release 2 are simpler in many respects from filters in previous versions of the full client. Measure filters used to require a defining a formula as did nesting filters. Now, you easily filter on measures by entering a value to compare to. For example, to find which states have a number of incidents less than 3,000 per quarter do the following.

Select the SR Count column.

Click Apply Filter from the Report toolbar or right-click to invoke the pop-up menu and select Quick Filter.

Measure Filters Note the list of values is not available for measures. Enter the value in the left hand box, in this case 3000, and then click>>. Change the operator form the default of Greater than to Less than or Equal to. Click OK to apply the filter and close the dialog. Analyzing the Data Enter Value here

Measure Filters

Note the list of values is not available for measures. Enter the value in the left hand box, in this case 3000, and then click>>.

Change the operator form the default of Greater than to Less than or Equal to.

Click OK to apply the filter and close the dialog.

Report Filters Report Filters are global filters that apply in all blocks in a report. In the section “Removing the Filter”, you saw that the report had both a tabular block and a pie block. Each block contains a separate filter on year for 2005. When you want all existing blocks and new blocks to inherit the same filter, apply them to the report via the Document Structure and Filters panel. Select the component page Body or the report tab (not the individual report block) and right click to select Quick Filter. This dialog now contains all the dimensions and measures for this report, as shown. Analyzing the Data

Report Filters

Report Filters are global filters that apply in all blocks in a report. In the section “Removing the Filter”, you saw that the report had both a tabular block and a pie block. Each block contains a separate filter on year for 2005. When you want all existing blocks and new blocks to inherit the same filter, apply them to the report via the Document Structure and Filters panel.

Select the component page Body or the report tab (not the individual report block) and right click to select Quick Filter. This dialog now contains all the dimensions and measures for this report, as shown.

Report Filters Under the column Available objects, these objects exist in the query but may not necessarily appear in one of your report blocks. Drag the object for which you want to filter from the left panel, Result Objects, to the right, Report Filters. To choose a filter value from a list, click Values. To add a filter on a measure, enter the numeric value and then click Update Filter. Select OK to close the Report Filter dialog. Analyzing the Data

Report Filters

Under the column Available objects, these objects exist in the query but may not necessarily appear in one of your report blocks.

Drag the object for which you want to filter from the left panel, Result Objects, to the right, Report Filters.

To choose a filter value from a list, click Values.

To add a filter on a measure, enter the numeric value and then click Update Filter.

Select OK to close the Report Filter dialog.

Nested Filters Nested filters within a report are new in Web Intelligence. Previously, you could create a nested filter in a query but not within a report. You use nested filters when you need to group sets of conditions. For example, you have seen that locations California and Colorado have the highest incidents. They may be missing incident targets only when incident counts are below 3,000 in a given quarter. For low incident locations, though, the incident targets, you want to filter the report for (California and Colorado with incidents greater than 10,000) or (incidents in other states with revenue less than 3,000). Analyzing the Data

Nested Filters

Nested filters within a report are new in Web Intelligence. Previously, you could create a nested filter in a query but not within a report. You use nested filters when you need to group sets of conditions. For example, you have seen that locations California and Colorado have the highest incidents. They may be missing incident targets only when incident counts are below 3,000 in a given quarter. For low incident locations, though, the incident targets, you want to filter the report for (California and Colorado with incidents greater than 10,000) or (incidents in other states with revenue less than 3,000).

Nested Filters Analyzing the Data Double-click to toggle AND / OR Add Nested filters Move line up or down

Nested Filters

Nested Filters Nesting filters can be rather tricky. First and foremost, you must have a clear understanding of what you want nested and what filters you wanted connected with an AND or OR. To add a nesting or another AND / OR connector, select the block from within the Documents Structure And Filters on the left, and then select Filter to call the Filter Editor. If you have selected just an individual column, your dialog will be different from that shown in the filter editor. Click the Add Nested Filter button on the right of the Filter dialog. This will insert an AND connector leftmost. Double-click the AND to toggle it to OR. Use drag and drop to reposition the connectors and filters. Click Apply. Analyzing the Data

Nested Filters

Nesting filters can be rather tricky. First and foremost, you must have a clear understanding of what you want nested and what filters you wanted connected with an AND or OR.

To add a nesting or another AND / OR connector, select the block from within the Documents Structure And Filters on the left, and then select Filter to call the Filter Editor. If you have selected just an individual column, your dialog will be different from that shown in the filter editor.

Click the Add Nested Filter button on the right of the Filter dialog. This will insert an AND connector leftmost.

Double-click the AND to toggle it to OR. Use drag and drop to reposition the connectors and filters.

Click Apply.

Nested Filters Analyzing the Data

Nested Filters

Ranking Where as filters limit the rows returned in accordance with specific selection criteria. Ranking enables you to limit the rows according to top to bottom values of measures. Note Ranking is only available in the java Report panel; it is not available in the Interactive viewer. To access the java Report panel, your default InfoView preferences for Web Intelligence must be set to use the Java Report panel for modifying reports (rather than the Query-html or the HTML Report panel … not to be confused with DHMTL Interactive Viewer that you have used so far). Select Web Intelligence Document tab from the Preferences link on the main toolbar, select the java Report panel and apply. Select Edit from the main toolbar to launch the java report panel. Analyzing the Data

Ranking

Where as filters limit the rows returned in accordance with specific selection criteria. Ranking enables you to limit the rows according to top to bottom values of measures.

Note Ranking is only available in the java Report panel; it is not available in the Interactive viewer. To access the java Report panel, your default InfoView preferences for Web Intelligence must be set to use the Java Report panel for modifying reports (rather than the Query-html or the HTML Report panel … not to be confused with DHMTL Interactive Viewer that you have used so far). Select Web Intelligence Document tab from the Preferences link on the main toolbar, select the java Report panel and apply. Select Edit from the main toolbar to launch the java report panel.

Ranking Analyzing the Data Select Edit to launch the Java Report panel

Ranking

Ranking When you apply a ranking, you apply it in terms of the measure you are trying to analyze and whether or not the rank should be within breaks on dimensions. The following table gives some business questions that show which measure you would base the ranking on. Analyzing the Data

Ranking

When you apply a ranking, you apply it in terms of the measure you are trying to analyze and whether or not the rank should be within breaks on dimensions. The following table gives some business questions that show which measure you would base the ranking on.

Ranking Analyzing the Data Business Question Measure to rank Which Business Units have the Highest expense variance? Sales Variance What are the top-selling products? Sales Quantity What customers have the most Incidents? Incident Count Which warehouses have the most product on hand? Inventory Which service providers have the shortest response time? (rank the lowest) Response Time

Ranking

Ranking A challenge with the Web Intelligence ranking feature is to understand that there are different ways to rank the data. I would ague that the generally accepted approach is to rank according to a percentage of the total. For example, suppose you want the top 10 percent of incident counts. Earlier versions of Business Objects did not allow this. The ranking calculation mode of Cumulative percentage is new in Web Intelligence XI Release 2. There are four calculation modes for ranking. Analyzing the Data

Ranking

A challenge with the Web Intelligence ranking feature is to understand that there are different ways to rank the data. I would ague that the generally accepted approach is to rank according to a percentage of the total. For example, suppose you want the top 10 percent of incident counts. Earlier versions of Business Objects did not allow this. The ranking calculation mode of Cumulative percentage is new in Web Intelligence XI Release 2. There are four calculation modes for ranking.

Ranking Count the number of records to retrieve based on the measure. Percentage the percentage of records to retrieve based on the measure. Cumulative Sum the cumulative sum that the measure must not pass. Cumulative Percentage The cumulative sum of the measure, represented as a percentage of the total, that the measure must not pass. Analyzing the Data

Ranking

Count the number of records to retrieve based on the measure.

Percentage the percentage of records to retrieve based on the measure.

Cumulative Sum the cumulative sum that the measure must not pass.

Cumulative Percentage The cumulative sum of the measure, represented as a percentage of the total, that the measure must not pass.

Ranking You can add a ranking to a table or chart: Select the block you wish to rank Choose Ranking from the Java Report panel Toolbar. Web Intelligence displays the Rank dialog. Choose if you want to filter your data on the top-ranked items or bottom. In this example, select Top and enter a value such 80. In the Based On drop-down, choose the measure on which want the ranking based. Choose the Calculation Mode as described earlier. Select Cumulative Percentage. If you are working with a large data set that has multiple levels, check for Each and indicate the dimension on which to reset ranking. Click OK to apply the ranking. Analyzing the Data

Ranking

You can add a ranking to a table or chart:

Select the block you wish to rank

Choose Ranking from the Java Report panel Toolbar.

Web Intelligence displays the Rank dialog. Choose if you want to filter your data on the top-ranked items or bottom. In this example, select Top and enter a value such 80.

In the Based On drop-down, choose the measure on which want the ranking based.

Choose the Calculation Mode as described earlier. Select Cumulative Percentage.

If you are working with a large data set that has multiple levels, check for Each and indicate the dimension on which to reset ranking.

Click OK to apply the ranking.

Ranking Analyzing the Data

Ranking

Ranking Note This ranking function works only on the rows within the local document, so it is a ranking within a subset of data. If you want a genuine ranking based on all data in the source data, this must be set up at query time, as described next. Analyzing the Data

Ranking

Note This ranking function works only on the rows within the local document, so it is a ranking within a subset of data. If you want a genuine ranking based on all data in the source data, this must be set up at query time, as described next.

Server-Based Ranking Server-based ranking is new in Business Objects XI R2 and requires that your database support the analytic function RANK. When your database supports this, an Add A Database Ranking button appears on the Query toolbar from within the Java Report panel. Note this button is quite similar to the Add A Subquery button but is different in that it has a star. Analyzing the Data

Server-Based Ranking

Server-based ranking is new in Business Objects XI R2 and requires that your database support the analytic function RANK. When your database supports this, an Add A Database Ranking button appears on the Query toolbar from within the Java Report panel.

Note this button is quite similar to the Add A Subquery button but is different in that it has a star.

Server-Based Ranking Analyzing the Data Add a Database Ranking Choose Top or Bottom Place Holders

Server-Based Ranking

Server-Based Ranking In the last section, you used the report-based ranking to rank data within a report. The server-based ranking is much more powerful in that you can rank, data against the full data set. So, you can answer questions such as Who are my top ten vendors What locations have the 12 most incidents What are my bottom 5 cause codes Analyzing the Data

Server-Based Ranking

In the last section, you used the report-based ranking to rank data within a report. The server-based ranking is much more powerful in that you can rank, data against the full data set. So, you can answer questions such as

Who are my top ten vendors

What locations have the 12 most incidents

What are my bottom 5 cause codes

Server-Based Ranking To perform a server-based ranking, follow these steps. From the Java Report panel, select Edit Query. Select Add A Database Ranking form the Query toolbar. This will add a ranking row to the Query Filters section. Use the Top/Bottom toggle to select if you want the Top or Bottom ranking By default, the value of Top 10 is selected. You can change the constant of 10 or enter a prompt. Drag the dimension for which you wish to perform the ranking onto the placeholder “Drop a dimension here”, this is category. Drag the measure to base the ranking on to the placeholder “Drop a measure here.” this is SR Count. Select Run Query Analyzing the Data

Server-Based Ranking

To perform a server-based ranking, follow these steps.

From the Java Report panel, select Edit Query.

Select Add A Database Ranking form the Query toolbar.

This will add a ranking row to the Query Filters section. Use the Top/Bottom toggle to select if you want the Top or Bottom ranking

By default, the value of Top 10 is selected. You can change the constant of 10 or enter a prompt.

Drag the dimension for which you wish to perform the ranking onto the placeholder “Drop a dimension here”, this is category.

Drag the measure to base the ranking on to the placeholder “Drop a measure here.” this is SR Count.

Select Run Query

Drill So far in this module you added many meaningful breaks, sort and calculations. With multidimensional analysis, you look at the same data but from different viewpoints. The viewpoints may be from different dimensions by drilling across or different levels of detail by drilling down. A dimension is a kind of object by which you analyze numeric measures. Dimensions often have different levels or groupings associated with them called hierarchies . Multidimensional analysis is the process of analyzing data by different levels within the dimensions. Within Web Intelligence, you can perform multidimensional analysis only with Dimension objects, not with objects the designer has created as detail objects. Analyzing the Data

Drill

So far in this module you added many meaningful breaks, sort and calculations. With multidimensional analysis, you look at the same data but from different viewpoints. The viewpoints may be from different dimensions by drilling across or different levels of detail by drilling down.

A dimension is a kind of object by which you analyze numeric measures. Dimensions often have different levels or groupings associated with them called hierarchies . Multidimensional analysis is the process of analyzing data by different levels within the dimensions. Within Web Intelligence, you can perform multidimensional analysis only with Dimension objects, not with objects the designer has created as detail objects.

Drill Hierarchies allow you to analyze data by different levels of detail. Some hierarchies are very clear-cut, such as Time, Going from Year to Quarter to Month to Week to Day. There is a natural order. Geography hierarchies may also be predetermined, running from Continent to Country to State. When the Geography applies to marketing region. However, each company introduces its own variation. One company may group the Middle Ease and Africa together; another company may include Mexico as part of North America because it is part of NAFTA or will group it under a different management region such as Latin America. Many of these groupings are predetermined as part of your company’s reference data and built in to the ERP or data warehouse. Analyzing the Data

Drill

Hierarchies allow you to analyze data by different levels of detail. Some hierarchies are very clear-cut, such as Time, Going from Year to Quarter to Month to Week to Day. There is a natural order. Geography hierarchies may also be predetermined, running from Continent to Country to State. When the Geography applies to marketing region. However, each company introduces its own variation. One company may group the Middle Ease and Africa together; another company may include Mexico as part of North America because it is part of NAFTA or will group it under a different management region such as Latin America. Many of these groupings are predetermined as part of your company’s reference data and built in to the ERP or data warehouse.

Drill The universe designer uses the hierarchies to build the default drill path you use for multidimensional analysis. With Web Intelligence, you can drill down within a hierarchy, for example form year to quarter to month. You also can drill across by analyzing the current year or the past year; you are at the same level of detail, year, but you are changing the selection value that you are analyzing. You can analyze data by one dimension at a time (Time) or by several at once (Time, Geography, Product). You can also drill against multiple report formats, including tables, crosstabs, and charts. Analyzing the Data

Drill

The universe designer uses the hierarchies to build the default drill path you use for multidimensional analysis.

With Web Intelligence, you can drill down within a hierarchy, for example form year to quarter to month. You also can drill across by analyzing the current year or the past year; you are at the same level of detail, year, but you are changing the selection value that you are analyzing. You can analyze data by one dimension at a time (Time) or by several at once (Time, Geography, Product). You can also drill against multiple report formats, including tables, crosstabs, and charts.

Drill Fixed reports often deal with standard, recurring information needs and give you an overview of what is going on in your business. Multidimensional analysis is more exploratory and answers why, where, and when. For example, you may start with a standard management report that shows product sales for this year and last year. Sales for one product is lower this year than last year. You need to know why. So you begin to explore: where the sales bad for a particular region, sales person , or quarter? Analyzing the Data

Drill

Fixed reports often deal with standard, recurring information needs and give you an overview of what is going on in your business. Multidimensional analysis is more exploratory and answers why, where, and when. For example, you may start with a standard management report that shows product sales for this year and last year. Sales for one product is lower this year than last year. You need to know why. So you begin to explore: where the sales bad for a particular region, sales person , or quarter?

Understanding the Data `You can easily get lost when drilling within a report. Therefore, it’s helpful to first understand how the different universes objects relate to one another and where you are drilling from and to. Here are two sample hierarchies time and location. Analyzing the Data

Understanding the Data

`You can easily get lost when drilling within a report. Therefore, it’s helpful to first understand how the different universes objects relate to one another and where you are drilling from and to. Here are two sample hierarchies time and location.

Understanding the Data Note Understand the hierarchical nature of you dimensions before drilling within a report Analyzing the Data

Understanding the Data

Note Understand the hierarchical nature of you dimensions before drilling within a report

Understanding the Data It’s also important to understand that most drilling occurs within a local microcube. You are not querying the database again. For example, using time dimensions that contain Year, Quarter, Month. When you construct a query, you first specify which columns of data you want to retrieve from the database. Initially, the default report displays all columns of data. However, as you format the report, remove column, and create objects, you may hide certain columns. These columns still exist in the query and therefore in the microcube but are not displayed in the report. This allows you to drill from year to Quarter to Month without having to execute a new query. Analyzing the Data

Understanding the Data

It’s also important to understand that most drilling occurs within a local microcube. You are not querying the database again. For example, using time dimensions that contain Year, Quarter, Month. When you construct a query, you first specify which columns of data you want to retrieve from the database. Initially, the default report displays all columns of data. However, as you format the report, remove column, and create objects, you may hide certain columns. These columns still exist in the query and therefore in the microcube but are not displayed in the report. This allows you to drill from year to Quarter to Month without having to execute a new query.

Analyzing the Data Query Year, Qtr, Month, Count RDBMS (Data Mart or ERP)

Understanding the Data If, however you want to drill down to a level of detail that does not exist in the document, to day for example, then new in release 2 is the ability to drill through. Web Intelligence will issue a new query and seamlessly display the additional level of detail. This drill-through to detail had previously been possible in the full client but not in Web Intelligence. Analyzing the Data

Understanding the Data

If, however you want to drill down to a level of detail that does not exist in the document, to day for example, then new in release 2 is the ability to drill through. Web Intelligence will issue a new query and seamlessly display the additional level of detail. This drill-through to detail had previously been possible in the full client but not in Web Intelligence.

How is the Data Aggregated Web Intelligence aggregates measures in two ways: SQL, functions and projection aggregates are set by the universe designer. For the most part, you do not need to worry about projection aggregates if your universe has been designed correctly. Analyzing the Data

How is the Data Aggregated

Web Intelligence aggregates measures in two ways: SQL, functions and projection aggregates are set by the universe designer. For the most part, you do not need to worry about projection aggregates if your universe has been designed correctly.

What is drill? You use drill to analyze the results displayed in reports. Drilling on reports lets you look deeper into your data to discover the details behind a good or bad summary result displayed in tables, charts, or sections. Drill Down With drill-down, you are looking for lower levels of detail within an existing hierarchy. In the following example, you will use Drill to dis

Add a comment

Related presentations

Related pages

www.businessobjects.com

Hier sollte eine Beschreibung angezeigt werden, diese Seite lässt dies jedoch nicht zu.
Read more

SAP BusinessObjects Enterprise XI 3.1 Service Pack 7 ...

... SAP BusinessObjects Enterprise XI 3.1 ... Portal SAP Ariba Support Portal SAP Business One Customer Portal SAP Sybase Support Portal ... Data ...
Read more

SAP BusinessObjects Enterprise XI 3.1 SP3 for Windows ...

SAP Business Objects tests and supports any _xx ... SAP BusinessObjects Data Federator 3.0 (XI R2) ... SAP BusinessObjects Enterprise XI 3.1 SP3 for ...
Read more

Business Objects XI 3.1 on windows 7 | SCN

How Install Business Objects Enterprise XI 3.1, ... in XI 3.1 SP3 both in 32 or 64 bit mode. ... but I can´t see their data, ...
Read more

SAP Business Objects 4.1/XI 3.1 - Online IT Training in ...

SAP Business Objects 4.1/XI 3.1. ... Restricting the data returned by objects. Using @ Functions. ... Analyzing in Drill Mode.
Read more

Business Objects Tips - Web Intelligence Report - BO ...

Help with Business Objects XI/BI Web ... WebI questions through Business Objects tips for XI R2, XI 3, BI 4. ... with Query Builder and Auditing Data;
Read more

BusinessObjects Enterprise XI 3.1 Backup and Recovery Best ...

BusinessObjects Enterprise XI 3.1 Backup and Recovery Best Practices ... SAP Business Objects ... system and data files, ...
Read more

Business objects xi free

The link that was posted was probably from before XI 3.1 ... Objects you can access and analyze data ... Business Objects you can access and analyze ...
Read more