Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

Publishing an Analysis Schema Using Schema Workbench

You can publish an analysis schema you created using the Schema Workbench on the Pentaho BI Platform. Follow the instructions below to publish your analysis schema:

  1. In Schema Workbench go to Save > File and save the schema to the Pentaho Solutions repository, as in ..\pentaho-solutions\samples\analysis. You can also save the file on your local device and then transfer it to the Pentaho solutions repository on a remote BI server. Make sure you specify *.mondrian.xml when you save the file.
     
  2. To test a simple MDX query, go to File > New > MDX Query. A success message appears.
     
  3. Enter a query in the top portion of the MDX Query window.
     

     

    Note: If query fails to return data then there may be an issue. Adjust the schema design accordingly and retest. Most common problems are the data types being used. It is possible for the schema to still run successfully when deployed to the Pentaho Platform.

  4. To begin the publishing process, in the Schema Workbench go to File > Publish. If you have not saved your schema a warning message appears.
     

     
  5. In the Repository Login dialog box enter the appropriate information and credentials to log on to the the BI server. You must provide the server's publish password, which is located in publish_config.xml in pentaho-solutions/system, and valid Pentaho user credentials (User ID and Password). If you are publishing against the open source server you must enter the server's publish password only. You do not need to enter user ID or password when publishing to an open source server as there is no additional security.
     

     
  6. After logging on to the server, in the Publish Schema dialog box, select the appropriate location to publish your schema. If you are not sure where to publish the schema, click the browse button to display a tree view of the entire solution repository.
     

     
  7. In the JNDI Data Source field, enter the JNDI name.
     
  8. Click Enable XMLA Data Source if you want your schema exposed as an XMLA Web Service.
  • No labels