"Go" Pentaho Sample cube configuration in detail (SQL Server version)

Source: Internet
Author: User

1 Download the JDBC driver for SQL Server first. See the following link address: [1] http://msdn.microsoft.com/en-us/data/aa937724.aspx[2] Google input into SQL Server JDBC is also available. [3] Here Sqljdbc4.jar is the jar package we need  2 download Pentaho of the multidimensional data server  mondrian and [1] http://sourceforge.net/→ input Mondrian Download { As of press time, the latest version of  mondrian 3.5.0} backup address is as follows: http://nchc.dl.sourceforge.net/project/mondrian/mondrian/ mondrian-3.3.0.14703/mondrian-3.3.0.14703.zipor http://nchc.dl.sourceforge.net/project/mondrian/mondrian/ Mondrian-3.5.0/mondrian-3.5.0.zip [2] About Mondrian: Mondrian are an OLAP (online analytical Processing) engine Written in Java. It reads from JDBC data sources, aggregates data in a memory cache, and implements the MDX language and the olap4j and XML /a apis. 3 download BI server and schema Workbench3.1 download Pentaho bi server,bi server,  mondrian can also download here, link under:/http community.pentaho.com/projects/bi_platform/ 3.2 Download Multidimensional schema Definition Tool schema workbenchhttp://mondrian.pentaho.com/  4 prepare the sample database for SQL Server Edition. [1] First build the  foodmart library on SQL Server. [2] will  d:\Program Files\mondrian-3.3.0.14703\demo\access\mondrianfoodmart.mdb Import to SQL Server FoodMart library   partial steps see: 4.3 Right-click Data Foodmark Select Import Data function    4.4 Select Access as the imported data source  4.5 Select the database to import into, see the following settings . 

4.6 See data query results

 5 Configure cube corresponding data source 5.1 into  \biserver-ce-4.5.0-stable directory, open bi Serverd:\program files\biserver-ce-4.5.0-stable\ Biserver-ce\start-pentaho.batd:\program files\biserver-ce-4.5.0-stable\biserver-ce\start-pentaho.sh  5.2-In  administration-console directory, open the Administrator window to set the data source. That is, D:\Program Files\biserver-ce-4.5.0-stable\administration-console\start-pac.bat if it is Linux, it is  d:\program Files\ biserver-ce-4.5.0-stable\administration-console\start-pac.sh 5.3 input http://localhost:8099 into database Connections, the new data source is like Foodmark. Click Test until you see the connection test success message as follows:   6 add jar package and modify the XML file for Multidimensional Analysis mode That is, foodmart.xml 6.1 copies the JDBC jar package for SQL Server in 1 steps, which is the Sqljdbc4.jar file, respectively, to the following folder 1)  d:\program files\ BISERVER-CE-4.5.0-STABLE\ADMINISTRATION-CONSOLE\JDBC 2)  d:\program files\biserver-ce-4.5.0-stable\ Biserver-ce\tomcat\lib 3)  d:\program files\schema-workbench\drivers 6.2 will D:\Program files\mondrian-3.3.0.14703 \demo\foodmart.xml Copy to D:\Program FILES\BISERVER-CE-4.5.0-STABLE\BISERVER-CE\TOMCAT\webapps\mondrian\web-inf\queries Folder 6.3 Modify the Foodmart.xml file, at the table name containing the new  schema= "dbo" (that is, the foodmark corresponding to the DB Owner, default is dbo). Like this: <table name= "sales_fact_1997"   schema= "dbo"> 6.4 Open the Foodmart.xml file with Schema-workbench and publish it and see the Publish success message.  7 view multidimensional data on the server.   7.1 Entrance to the first souvenir. Where warehouse and sales are virtual cubes. 7.2 Of course this schema also supports virtual cube. A slightly more complex pattern. See section Foodmart.xml for a definition of virtual cube. <virtualcube enabled= "true" Name= "Warehouse and Sales" defaultmeasure= "Store Sales" visible= "true" > Following is a snapshot of cube hr .

"Go" Pentaho Sample cube configuration in detail (SQL Server version)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.