You can have a number of JDBC connections defined. Set properties for connection to your cube database by clicking Tools > Connection. In Linux/Unix, you may need to set execute permissions on Workbench.sh in order to Start the Designer by running Workbench.bat (Windows) or Workbench.sh (for Unix/Linux) in the directory where This document and the Mondrian Technical Guide are included in the /docs directory.
YouĬan include your cube database’s JDBC driver in the /drivers directory in the Designer installation, so that the In the J aspersoft OLAP Community Edition, J DBC drivers are provided for MySQL, PostgreSQL and Ingres. If your data is stored in a different RDBMS, you can add the appropriate JDBC driver to the /drivers directory in theĭesigner installation, then select Other as the type of database when you define a connection. The Professional Edition includes drivers for MySQL, PostgreSQL, Ingres, Oracle, Microsoft SQL Server, and.The Community Edition includes drivers for MySQL, PostgreSQL and Ingres.The RDBMS drivers J aspersoft provides vary with the edition of the Designer: The Designer needs a JDBC connection to the database that stores the data you want to describe in OLAP terms. Once installed,Ĭonfigure a J DBC connection that points to your data. To install the J aspersoft OLAP Designer, unzip its archive into a directory on your hard drive. Once you have a schema XML file, you can upload it into any application that uses Mondrian, such asĢ. It is found in the /docs directory of the Designer See the Mondrian Technical Guide for information about schemas. The Professional Edition includes the Community Edition and adds support for creating security files that canīe used in J aspersoft OLAP to secure data according to user roles.The Community Edition provides the majority of the functionality, such as support for OLAP schemas and.J DBC Explorer: Browses underlying database’s structure.MDX Query: Tests MDX queries against schema and database.Schema Explorer: An editor integrated with the underlying data source for validation.The J aspersoft OLAP Designer allows you to visually create and test Mondrian OLAP cube schemas. 16ģ.5.1 Getting Started.17ģ.5.2 Defining a Database Connection.17ģ.5.3 Creating a Simple Schema.18 11ģ.2.5 Access Grants for J aspersoft OLAP Professional.13ģ.3 MDX Query. 7ģ.2.1 Overview.7ģ.2.2 Adding Elements.8ģ.2.3 Navigating an OLAP Schema.10ģ.2.4 Working with Existing OLAP Schemas.
0 kommentar(er)
