Drilling Through to Underlying Relational Data –New feature in SAP Business Objects 4.1 SP06.

[kannan_andireddi]

Current problem:

BOE XI3.0 provides capability of drilling through the transactional data. It is very important to know the transactional data from the business perspective as it always gives the completeness and more visibility of actual real time transaction. But this feature was not supported in AOLAP from BOW XI4.0.

Please note that it is only available with Microsoft SQL Server 2008 Analysis Services or Microsoft SQL Server’s later versions.

Procedure:

Starting from SP06 on wards we have added the drill through context menu for the measure, It is not available for calculated measure. User can right click on the measure value and if we would like to drill through user can click on drill through which pops up the drill through.

See the below screen shot and now user want to know how the “Internet Order Quantity “ for Customer “Aaron Bryant” is aggregated value is 5.

1. Select the cell value (5), right click and select drill through.
2. 2. If relational data is available, the underlying data appears in a popup window, and user can navigate between pages and export to CSV or XLS file format.

After drill through on cell value now user will get the drill through result as pop up window.

See below screen shot how “Internet Order Quantity “ for Customer “Aaron Bryant” is aggregated value is 5 is came from transactional data.

Note:

With Microsoft SQL Server Analysis Services, drill-through functionality must be enabled at the cube level by your database administrator. You must also be granted permission to perform a drill-through operation in a cube role by the database administrator.

Exporting Relational Data to CSV and Microsoft Excel:

1. Choose the export icon that appears on the left upper corner of the dialog box. A drop down bar appears.
2. User can export the data to Microsoft Excel or CSV by choosing the relevant options on the drop down.

How to change the default mdas.properties:

By default maximum number for rows to fetch from Relational database is 10000 and maximum number of rows per page is 100, and user can change these default properties as per his requirement in mdas.properties.

To change the number of rows in each page, perform the following steps:

Navigate to the following mdas.properties file: <BOE INSTALL DIRECTORY>/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/java/pjs/services/MDAS/resources/com/businessobjects/multidimensional/services.

-to set the maximum number for rows to fetch from database (default value is 10000):

multidimensional.services.drillthrough.maxrows=10000

-to set the maximum number of rows per page (default value is 100):

multidimensional.services.drillthrough.pagesize=100