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)