sap businessobjects analysis edition for microsoft office
How to Add a Chart?
Here is how to create a dynamic chart to your workbook. Start by clicking the Office Button and selecting New. Then, click on the Analysis Ribbon, if it is already activated. Choose Select Data Source… after clicking on the Insert. Double-click on the RWB System Connection from the dropdown-box Show Connection. Double-click on the query Country Sales Analysis after searching for P_QD_Country_Sales. Clicking on the Chart button will display the data from the table as a chart.
Here is what you do to display the data as an Area-Chart and format it in the ways you please:
- From the context menu of the chart, select Chart Series Chart Type
- Select the 4th chart from the left after selecting Area at the left side of the screen
Then, you have to navigate within the data to see the changes in the chart you created. Exchange the following:
- Sold-toPartyCountry -> Division
- Division -> Calendar year/Month
- Calendar year/Month -> Sales Organization
Then remove the measure Incoming Orders from the dropdown. And finally, save your workbook by clicking on the button with the Office logo and selecting Save Workbook. Click Continue and you are done.
How to filter by measure?
First, create a New Workbook with the query Country Sales Analysis. Then, click on the button with the Office logo and select New. Click on the Analysis Ribbon, then on Insert and choose Select Data Source… Double-click on RWB System Connection and search for P_QD_Country_Sales. Double-click on the query named Country Sales Analysis.
Then filter rows with more than 10,000 sales revenue EUR. Open the context menu for the measure Sales Volume EUR. Then choose Filter by Measure menu, choose All Dimensions Independently and click Edit. Select Greater than and type in 10000. Click on Add and confirm the dialog. Add a new filter for more than 20,000 incoming order EUR:
- Click to open the context menu for Incoming Order EUR and then select Filter by measure, All Dimensions Independently and click Edit…
- Select Greater than and type in the value 20000 and click the Add
You can change the filter to use the OR operator instead of the AND by doing the following:
- Filter By Measure -> All Dimensions Independently -> Edit…
- Select OR to be the logic instead of AND
Finally, save your Workbook by clicking the Office logo button and selecting Save Workbook.
How to work with Hierarchies?
Start by clicking the Office logo button and selecting New. Then click on the Analysis Ribbon -> Insert -> Select Data Source… Double-click the RWB System Configuration from the Show Connection. Look for U00_QD_HIER002 and double-click the query named U00 Query Hierarchy 002. Examine the displayed data and the default hierarchy which is Product Hierarchy for material MARA. If you want to hide Level 2 of the hierarchy you start by clicking on cell A2 and selecting Hierarchy, then Show Levels and de-select Level 2.
Click here for our business objects training.
To exchange the current default hierarchy with the High Tech Products follow these steps:
- From the Design Panel, open the Material folder.
- From the available hierarchies, find the High Tech Products and drag it onto the Material in the Rows area.
To revert the hierarchy back to the default U00 Query Hierarchy 002, you can use the Undo button. To hide hierarchies you don’t want to see anymore, select the Material on the grip and choose Filter, and then Filter By Members. De-select all the hierarchies you want to hide.
You can use the Design Panel or the menu to display Material without hierarchies – drag the Flat Presentation entry onto Material. To undo the Row hierarchy from the Query Definition, first deactivate the Compact Display in Rows, and then use the undo button.
Finally, save your Workbook by clicking on Save Workbook from the Office button logo and clicking Continue.
Download article below
[purchase_link id=”546″ style=”button” color=”blue” text=”sap businessobjects analysis edition for microsoft office”]