Hitachi Vantara Pentaho Community Wiki
Child pages
  • OpenOffice Calc - Adhoc Data Source
Skip to end of metadata
Go to start of metadata

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

Compare with Current View Page History

Version 1 Current »

Create a new plugin for OpenOffice calc that allows users to retrieve data from the Pentaho platform using metadata based queries.

The plugin needs to:

  • Allow the user to connect and login to a Pentaho BI server 
  • Retrieve the list of metadata models available to the user and let them pick one
  • Retrieve the details of the selected metadata model
  • Allow the user to select columns of data that they want to see
  • Submit the metadata-based query to the server and populate the sheet with the results
  • Save the connection and query information with the Calc sheet
  • Allow the user to refresh the data when a saved document is loaded
  • No labels