Uploading Reports

To upload reports:

1. Navigate to Management > Reports, and click Upload Reports. The Upload Report window is displayed.

2. Enter the Report Name.
3. Enter the Process Name for which you are uploading the report.
4. Enter a meaningful Description.
5. From the Report Schema File section, click Choose File and select the schema file in .xml format.
6. Choose the DB Name from the drop-down list for the database. The available options are Other, Default, and RPA. 

7. Enter the DB Schema Name.
8. Enter the JDBC URL and JDBC Driver.
9. Enter the JDBC User and JDBC Password.
10. Enter the MDX Query. For more details, see the Writing an MDX Query.

11. From the Authorization tab, select the user permissions. The available options are Global, Denied, and Allow.

• Choose Global to authorize all the users to manage the report.
• Choose Denied to authorize no users to manage the report.
• Choose Allow to authorize specific users or user groups to manage the report.

To allow user permissions,

• Select Allow from the drop-down list and click Add Permission. 
• Click Empty and select the required user or user group.
• Specify the required permissions.

• Use the icon from Action column to delete a user permission.

12. Click Save. The report is uploaded and displayed in the Reports list.

Writing an MDX Query for a simple Schema

MDX query is a multi-dimensional query language, which represents data in multi-dimensional form, not only in rows and columns.

CUBE XML is a logical representation form of MDX query. It contains Dimensions, Measures, and Aggregate functions.

XML definition of a simple Schema:  

<Schema>   <Cube name="LoanDetails">     <Table name="Loan_Details"/>      <Dimension name="FirstName">       <Hierarchy hasAll="true" allMemberName="All">        <Level name="FirstName" column="FIRST_NAME" uniqueMembers="true" />       </Hierarchy>      </Dimension>         <Dimension name="LastName">       <Hierarchy hasAll="true" allMemberName="All">        <Level name="LastName" column="LAST_NAME" uniqueMembers="true" />       </Hierarchy>     </Dimension>    <Dimension name="LoanType">     <Hierarchy hasAll="true" allMemberName="All">      <Level name="LoanType" column="LOAN_TYPE" uniqueMembers="true" />     </Hierarchy>    </Dimension>  <Measure name="Total Loan" caption="Total Loan" aggregator="count" formatString="#,###">      <MeasureExpression>        <SQL>         1        </SQL>       </MeasureExpression>      </Measure>   </Cube> </Schema>

This schema contains a "LoanDetails" cube with three dimensions - "First Name", "Last Name", and "Loan Type", and one measure - "Total Loan".

You can write an MDX query for this schema:

SELECT {[Measures].[Total Loan]} ON COLUMNS,{[FirstName].[All].children} ON ROWS FROM [LoanDetails]