Show TOC

Drill-ThroughLocate this document in the navigation structure

You can display information from another cube or from a SAP table, for any specific parameter that have been specified in the DrillThrough.xml file.

The DrillThrough.xml file is automatically placed in the EPM plug-in installation folder. You can use this file as a template. In order to use it, copy it at the following location: \%userprofile%\AppData\Local\EPMOfficeClient\. The parameter <Redirection> enables you specifies another file where drill-throughs are defined (a file on the network shared by several users for example). Enter the path and name to the other file. Do not define any drill-throughs in the current file; enter only the redirection information.

Drill-Through to Cube

A drill-through to cube enables you to display information from another cube, for any specific parameters that have been specified in the DrillThrough.xml file.

Note

  • The source report can be connected any connection. However, if the source report uses a SAP BusinessObjects Enterprise connection, the destination cube must also use SAP BusinessObjects Enterprise connection.

  • The source cube and the destination cube can be located either on the same server or on two different servers.
To access the drill-through information, select a data cell that belongs to the report, then select Start of the navigation path EPM Next navigation step Drill-Through Next navigation step Drill-Through to Cube End of the navigation path and the name of the drill through, which is defined in the DrillThrough.xml file. Another worksheet opens, displaying a static report. The information displayed depends on the following items:
  • The context of the data selected; the row and column members at the interersection of the data cell selected.
  • The parameters that have been specified in the DrillThrough.xml file. Here is the description of the parameters that need to be filled in:
    • <DrillThroughToCubeInfo>: defines one drill-through.
    • <MDXQuery>: MDX query of the destination report. Inside the query, you can put all the variable members between double hashes (##).
    • <DisplayName>: name of the command that will be displayed when selecting Start of the navigation path EPM Next navigation step Drill Through Next navigation step Drill-Through to Cube End of the navigation path from the EPM tab of the ribbon.
      Note The entity member and its children are mentioned as follows in the MDX query: {[ENTITY].[All].CHILDREN, [ENTITY].[All]}

      You want the entity member and its children to vary. Add double hashes (##) as follows: {## ENTITY##.CHILDREN, ##ENTITY##}

    • <VBAFunctionBeforeDrillThrough>: executes a VBA macro before executing the drill-through (for example: displaying a comment before the report). Enter the name of the macro.
    • <VBAFunctionAfterDrillThrough>: executes a VBA macro after executing the drill-through (for example: applying formatting settings). Enter the name of the macro.
    • <ConnectionInfo>: connection information of the .oqy file. Specify the connection information only if the destination cube is on another server.
    • <IsEPMSheet>: enter TRUE to make the destination worksheet an EPM worksheet. Enter FALSE to make the worksheet a Microsoft Excel standard one.
Drill-Through to SAP Table

A drill-through to SAP table enables you to display information from a SAP table, for any specific parameters that have been specified in the DrillThrough.xml file.

Note
  • The source report can use a local connection or a Planning and Consolidation connection.
  • The source cube and the destination table can be located either on the same server or on two different servers.
To access the drill-through information, select a data cell that belongs to the report, then select Start of the navigation path EPM Next navigation step Drill-Through Next navigation step Drill-Through to SAP Table End of the navigation path and the name of the drill through, which is defined in the DrillThrough.xml file. Another worksheet opens, displaying a static report. The information displayed depends on the following items:
  • The context of the data selected; the row and column members at the interersection of the data cell selected.
  • The parameters that have been specified in the DrillThrough.xml file. Here is the description of the parameters that need to be filled in:
    • <DrillThroughToSAPTableInfo>: defines one drill-through to SAP table.

    • <DisplayName>: name of the command that will be displayed when selecting Start of the navigation path EPM Next navigation step Drill Through Next navigation step Drill-Through to SAP Table End of the navigation path from the EPM tab of the ribbon.

      Note <DrillThroughToSAPTableInfo> and <DisplayName> are mandatory. If you fill in these two pieces of information, the whole content of the specified SAP table will be displayed in a new worksheet.
    • <Query>: query of the SAP table.
      • <Table>: name of the SAP table. This parameter is mandatory.
      • <Fields> <Field>: name of the column you want to request information from.
      • <Filters> <Filter>: define filters using SQL language (LIKE, NOT LIKE, etc). You can put all the variable members between double hashes (##).
      Note The information that will be retrieved from the SAP table are the following: all the rows of the column called GROUP that contain AF and that do not start with the long name property for the current entity member cell.

      <Filters><Filter>GROUP LIKE '%AF%'</Filter> <Filter>GROUP NOT LIKE '##ENTITY##PROPERTY(Long Name)##%'</Filter> </Filters>

    • <MaxRows>: maximum of rows you want to retrieve.
    • <ConnectionInfo>: connection information of the SAP table. Specify the connection information only if the destination table is on another server.
    • <VBAFunctionBeforeDrillThrough>: executes a VBA macro before executing the drill-through (for example: displaying a comment before the report). Enter the name of the macro.
    • <VBAFunctionAfterDrillThrough>: executes a VBA macro after executing the drill-through (for example: applying formatting settings). Enter the name of the macro.
    • <IsEPMSheet>: enter TRUE to make the destination worksheet an EPM worksheet. Enter FALSE to make the worksheet a Microsoft Excel standard one.