Hitachi Vantara Pentaho Community Forums
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Cube Designer's Quick Start

  1. #1
    Join Date
    Mar 2007
    Posts
    216

    Post Cube Designer's Quick Start

    Hi,

    This is a Cube Designer Quick Start guide for
    -Cube Designer v0.7.2.0
    -Windows XP SP2 / Windows Vista Ultimate

    Purpose : running a sample with Cube Designer.

    Note : this is not a final guide, I will update it as soon as I think it needs to be.

    Introduction

    This guide use Pentaho-demo as Pentaho server for Cube Designer.

    A. Downlaod and Install Pentaho-demo

    0) download the last pentaho-demo e.g http://dfn.dl.sourceforge.net/source....0.M1.1018.zip
    1) unzip it

    B.Download and Install Java Runtime Environment 1.5


    e.g. ftp://ftp.iem.ac.ru/java/java5/jre-1...ows-i586-p.exe

    C. Get / Install / Configure Cube Designer

    C.I.Download the last Cube Designer


    1) download http://dfn.dl.sourceforge.net/source....2.0_Win32.zip
    2) unzip it

    C.II.Create a shortcut for CubeDesigner.exe which will run with Java Runtime Environment 1.5.


    Go to your Cube Designer directory
    Right click CubeDesigner.exe
    Left click "Send to" and "Desktop (create shortcut)"
    Copy / Paste the shortcut to your Cube Designer installation folder
    Right cilck the shortcut.
    Left click "properties"
    Change the target with :
    Code:
    "C:\pentaho\CubeDesigner\CubeDesigner.exe" -vm "C:\Program Files\Java\jre1.5.0_11\bin\java.exe" -clean -ws win32
    C:\pentaho\CubeDesigner\ is my Cube Designer directory, yours may change.
    C:\Program Files\Java\jre1.5.0_11\ is my java 1.5 drectory, yours may change.

    C.III.Configure database connections

    Search for jdbc.properties in the pentaho-demo directory
    e.g. ...\pentaho-demo\pentaho-solutions\system\simple-jndi\jdbc.properties
    copy its content in the clipboard
    Run Cube Designer, Select File / New Cube Schema from the menu, and at the 1st step, close Cube Designer for a jdbc.properties file to be created empty.
    search for jdbc.properties in the cube designer folder, or in Cube Designer's shortcut folder.
    e.g. ...\CubeDesigner\resources\system\simple-jndi\jdbc.properties
    paste the clipboard content in this file. Sample :
    Code:
    # Copyright 2006 Pentaho Corporation.  All rights reserved. 
    # This software was developed by Pentaho Corporation and is provided under the terms 
    # of the Mozilla Public License, Version 1.1, or any later version. You may not use 
    # this file except in compliance with the license. If you need a copy of the license, 
    # please go to http://www.mozilla.org/MPL/MPL-1.1.txt. The Original Code is the Pentaho 
    # BI Platform.  The Initial Developer is Pentaho Corporation.
    #
    # Software distributed under the Mozilla Public License is distributed on an "AS IS" 
    # basis, WITHOUT WARRANTY OF ANY KIND, either express or  implied. Please refer to 
    # the license for the specific language governing your rights and limitations.
    SampleData/type=javax.sql.DataSource
    SampleData/driver=org.hsqldb.jdbcDriver
    SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata
    SampleData/user=pentaho_user
    SampleData/password=password
    Hibernate/type=javax.sql.DataSource
    Hibernate/driver=org.hsqldb.jdbcDriver
    Hibernate/url=jdbc:hsqldb:hsql://localhost/hibernate
    Hibernate/user=hibuser
    Hibernate/password=password
    Quartz/type=javax.sql.DataSource
    Quartz/driver=org.hsqldb.jdbcDriver
    Quartz/url=jdbc:hsqldb:hsql://localhost/quartz
    Quartz/user=pentaho_user
    Quartz/password=password
    Shark/type=javax.sql.DataSource
    Shark/driver=org.hsqldb.jdbcDriver
    Shark/url=jdbc:hsqldb:hsql://localhost/shark
    Shark/user=sa
    Shark/password=
    SampleDataAdmin/type=javax.sql.DataSource
    SampleDataAdmin/driver=org.hsqldb.jdbcDriver
    SampleDataAdmin/url=jdbc:hsqldb:hsql://localhost/sampledata
    SampleDataAdmin/user=pentaho_admin
    SampleDataAdmin/password=password
    Now you will be able to connect Pentaho_demo sample data from Cube Designer.

    C.IV.Search for publisher_config.xml in the pentaho-demo folder

    e.g. ...\pentaho-demo\pentaho-solutions\system\publisher_config.xml

    C.V.Edit publisher_config.xml to add a password in it.

    Sample :
    Code:
    <?xml version="1.0"?>
    <!--
        This file must be configured before client tools
        will be able to publish onto the server. Publishing
        involves accepting a file (action sequence, xml document,
        anything) and placing it into the solution. This
        action should only be allowed if the tool is configured
        with a server/deployment specific password. The 
        RepositoryFilePublisher is now coded to expect an MD5
        hash of the password entered here before it will allow
        publish into the server.
        
        This is a critical security measure designed to prevent
        malicious actions from being published into your server.
        Please take care to make the password sufficiently
        difficult to guess. Also take care that the contents of
        this file are not generally available
    -->
    <publisher-config>
        <publisher-password>admin</publisher-password>
    </publisher-config>
    C.VII.Get the Cube Designer User Guide

    http://downloads.sourceforge.net/mon...8&big_mirror=0

    D. Nothing here, I'm just too lazy to update following titles numbers
    E. Nothing here, I'm just too lazy to update following titles numbers


    F.Run Cube Designer

    F.I. Before 1st screen
    0) if you ran Cube Designer, close it, that was only a section title 1) run start-pentaho.bat from the Pentaho Demo folder, click Ok if prompted for version checking
    2) wait for console message BI Server is ready (1 min 30 later)
    3) open a browser to http://localhost:8080/ to check it's running.
    4) run the shortcut to CubeDesigner.exe with jre1.5
    5) open Pentaho_Cube_Designer_User_Guide_0_7_0.pdf

    F.II.1st screen "Start Here"
    1) File / New
    2) Cube Name=CubeName NO SPACE IN THE NAME
    3) Cube Description=Cube Description
    4) Select SampleData
    5) Click Next

    F.III.2nd screen "Map Tables"
    1) select Tables in the right list
    2) select public in the left list
    3) select the tables like in the PDF p.10 :
    orderfact,
    customer_w_ter,
    time.
    4) make the same links than in the doc, tick the same boxes + the ones which are highlighted in the doc p.10 :

    You should have ticked :

    --orderfact.productcode
    --orderfact.customernumber
    --orderfact.time_id
    --orderfact.priceeach
    --orderfact.totalprice

    --customer_w_ter.customernumber
    --customer_w_ter.customername
    --customer_w_ter.contactfirstname
    --customer_w_ter.contactlastname

    --time.qtr_id
    --time.time_id
    --time.month_id
    --time.year_id
    --time.month_name
    --time.qtr_name

    -links :
    --orderfact.customernumber with customer_w_ter.customernumber
    --orderfact.time_id with time.time_id
    5) Click Next

    F.IV.3rd screen "Create Measures"
    1)select ORDERFACT in Fact Table
    2)select TOTALPRICE
    3)click ==>
    4)click next

    F.V.4th screen "Create Dimensions"
    0) select customer_w_ter.CUSTOMERNAME
    1) clic "Add New Dimension"
    2) name=Customer
    click "Ok"
    3) configure the dimension
    name=CustomerName
    nameColumn=CUSTOMER_W_TER.CUSTOMERNAME (no change)
    uniqueMembers=false (no change)
    4) add the time dimension
    Select TIME.YEAR_ID in the list,
    Click Add New Dimension
    Name=Time
    Select YEAR_ID in the right
    Name=Year
    Select TIME.QTR_ID in the left
    Click ==>
    Name=Quarter
    NameColumn=TIME.QTR_NAME
    uniqueMember=false (no change)
    Select TIME.MONTH_ID in the left
    Click ==>
    Name=month
    NameColumn=TIME.MONTH_NAME
    UniqueMember=false (no change)
    6) click Next

    F.VI.5th screen "Final Steps"
    1) click View XML
    2) replace the last datatype="String" with datatype="Numeric" :
    i.e. replace
    Code:
            <Measure name="SUM of ORDERFACT.TOTALPRICE" column="TOTALPRICE" aggregator="sum" datatype="String" formatString="Standard"/>
    with
    Code:
            <Measure name="SUM of ORDERFACT.TOTALPRICE" column="TOTALPRICE" aggregator="sum" datatype="Numeric" formatString="Standard"/>
    3) close
    4) click Publish
    5) publish location = /samples/analysis
    6) web publish url = http://localhost:8080/pentaho/RepositoryFilePublisher
    7) publish password = the one you put in the xml file (admin)
    8) depending on pentaho_demo version you use : v1.60.GA.863 server userid = joe ; v1.21.GA server userid = pentaho_user
    9) server password = password
    10) ok
    11) Finish (do not preview, Cube Designer is too old to be able to preview Cube when using Pentaho Server newer than v1.2)
    12) Save location=c:\mycubes\ for example
    13) save and close

    G.Verify the sample created
    0) refresh pentaho server with F5 when on http://localhost:8080
    2) click Navigate
    3) click Solutions
    4) click Sample Analysis (last line) / Exemples d'analyse
    5) click CubeName
    nb : If you see a space in the cube name, it won't work.

    If anyone has any problem to follow this guide, please tell me so that I update it.

    Hoping this helps,

    a+, =)
    -=Clement=-
    Last edited by clement; 04-30-2008 at 03:40 AM. Reason: There still was some errors

  2. #2

    Default Changing Default port number

    Hello

    I have configured the 'start-pentaho.bat' files as per your instruction and installed rest of the supporing file. When I run this bat file everthing is executing fine, but I could not browse and see the pentaho sever

    Url I tryed http://localhost:8080/ and http://localhost:8080/pentaho

    I belive that in the port 8080 I have configured for congons, so that its not working, Is there any way chage the default (8080) port number, please guide me to fix this problem.

    Error msg: java.net.BindException: Address already in use: JVM_Bind:8080

  3. #3
    Join Date
    Jul 2007
    Posts
    2,497

    Default

    After googling:

    This is how port 8080 is changed on JBoss 4.

    1. Goto the deploy folder of the server instance you use.
    2. Goto the jbossweb-tomcat55.sar inside that deploy folder.
    3. Find the file named server.xml inside that folder. (tomcat service file).


    Look for the HTTP Connector section inside the server.xml where 8080 configuration is available. Change the port value to what ever the required port number.

    This change wiill be available when JBoss is restarted.
    Last edited by pmalves; 10-10-2007 at 09:32 AM.
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  4. #4
    Join Date
    Mar 2007
    Posts
    216

    Smile

    Hi,

    In pentaho-demo v1.6.0.GA.823 directory, there are 54 files with 8080 in them. Only 5 system xml files with 8080 as a port and uncommented :
    pentaho-demo\pentaho-solutions\system\olap\datasources.xml
    pentaho-demo\jboss\server\default\deploy\pentaho.war\WEB-INF\web.xml
    pentaho-demo\jboss\server\default\deploy\jboss-web.deployer\server.xml
    pentaho-demo\jboss\server\default\deploy\jboss-portal.sar\portal-wsrp.sar\default-wsrp.xml
    pentaho-demo\jboss\server\default\deploy\http-invoker.sar\META-INF\jboss-service.xml

    a+, =)
    -=Clément=-

  5. #5

    Default

    Clement,

    You guide is great my problem is that I can not publish the Cube designer report to the BI Server I am getting the error:

    "Your login failed verify your login and publish password and make sure Pentaho BI server is running".
    I changed my publish password under:
    C:\...\pentaho_solutions-1.6.0.GA.863\pentaho-solutions\system\publisher_xml
    Start-Pentaho.bat is running for mysql DB (pentaho_demo_mysql5-1.6.0.GA.863)
    I have tried Server UserID: joe / password or pentaho_user/password but still getting the same error

    Publish location is:/samples/analysis
    Web publish URL : http://localhost:8080/pentaho/RepositoryFilePublisher

    What am I doing wrong that is not allowing me to export Cube to BI server ?

    Thanks for your help

  6. #6
    Join Date
    Mar 2007
    Posts
    216

    Smile

    Hi,

    Quote Originally Posted by fabien Zanchi View Post
    (...)I changed my publish password under:
    C:\...\pentaho_solutions-1.6.0.GA.863\pentaho-solutions\system\publisher_xml
    Start-Pentaho.bat is running for mysql DB (pentaho_demo_mysql5-1.6.0.GA.863)
    I have tried Server UserID: joe / password or pentaho_user/password but still getting the same error(...)
    The name of the publisher_config.xml file you wrote is not valid, I guess that is a not actually the case. You seem to use pentaho-solutions instead of pentaho-demo.
    You may check twice that the file \pentaho-solutions\system\publisher_config.xml is ok.
    You may check if there is not case sensitivity problems (using 'A' in a password may not be the same that 'a').

    a+, =)
    -=Clément=-

  7. #7

    Default

    Merci Clement en effet j'avais modifie le mauvais fichier.

  8. #8

    Default

    Clement,

    I managed to do the following form Cube Designer.

    12) Save location=c:\mycubes\ Pentaho
    13) save and close


    How can I view the exported report when I am in
    http://localhost:8080/pentaho/Home

    You mentioned in a previous post
    click Navigate
    click Solutions


    I can't seem to find Navigate or Solutions in
    http://localhost:8080/pentaho/Home

    Cheers

  9. #9

    Default

    Please disregard my last post I have found where to go. My only issue is my report is not returning any data even thought there is some in the DB. I guess that is unrelated to my original query

  10. #10
    Join Date
    Mar 2008
    Posts
    2

    Default All ready the same problem

    Hello my friends;

    I can't see any result; i did all steps to make my cube but after visiting this adress http://localhost:8080/pentaho then 'solutions' then 'exemple d'analyse' efter i clik on my cube name and i see an empty paper on mozilla; where is my diagrams and my tables?? i don't know please help me !!

    i used pentaho_demo_hsqldb_1.7.0.M1.1018 and pentaho cube designer 0.7
    thanks a lot!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.