Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problem opening cube

  1. #1
    Join Date
    Nov 2007
    Posts
    12

    Question Problem opening cube

    Hi:

    I hope someone can help me with my problem. Im new pentaho and i wish to learn as much as i can.

    I have created a cube using the cube designer but when i try to open it in my server the following message appears:

    var controller = null; var newActionName = null; var newSolution = null; var newActionPath = null; function cursor_wait() { document.body.style.cursor = 'wait'; } function cursor_clear() { document.body.style.cursor = 'default'; } function load(){ cursor_wait(); controller = new PivotRepositoryBrowserController(); controller.setOnAfterSaveCallback( function() { newActionName = controller.getActionName(); newSolution = controller.getSolution(); newActionPath = controller.getActionPath(); document.location.href='Pivot?save-action=saveAs&save-path='+newSolution +'/'+newActionPath+'&save-file='+newActionName+'&save-title='+newActionName; }); cursor_clear(); } function save() { cursor_wait(); newActionName = "

    I dont know whats happening. I made a report (not cube) before without problems but the cube is not working. I have a postgresql database. I have a fact table and 4 dimensions. But with the cube designer i only register the fact and 2 dimensions for the cube (this is because when a put all dimensions, the cube designer didint create an xml file at all).

    Another thing, if i make manually a cube (xml file) how can i publish it to my server? Is there any manual way to publish a report/cube?

    Thanks in advance, any help will be appreciated


    Saludos de Peru

  2. #2
    Join Date
    Mar 2007
    Posts
    216

    Smile

    Hi,

    Quote Originally Posted by avo_liao View Post
    (...)I dont know whats happening.(...)
    Your Cube is bad. Note that if you have snowflake schema with the larger groups on the borders cubedesigner will generate unusable xml.

    Another thing, if i make manually a cube (xml file) how can i publish it to my server? Is there any manual way to publish a report/cube?(...)
    -add your datasource-ds.xml file in jboss/server/default/deploy
    -add your datasource lines in jboss/server/default/deploy/pentaho.war/WEB-INF/web.xml and jboss-web.xml
    -copy/paste your cube (3 files) in /pentaho-solutions/samples/analysis/ directory

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

  3. #3
    Join Date
    Nov 2007
    Posts
    12

    Default

    Thanks for the response

    Yep, maybe my cube is bad because i ate 2 of the 4 dimensions, but the complete cube works because i have tried it before with others OLAP servers.

    Does this means cube designer doesnt support snowflake schema? Im using a hybrid betwwen snowflake and star schema.

    What do you mean by saying: snowflake schema with the larger groups on the borders? Sorry, maybe my english is not helping here

    Lots of thanks

  4. #4
    Join Date
    Nov 2007
    Posts
    12

    Default

    Heh, you were right. i made an error while defining my dimensions. But i had another error which was that i named my cube with a "space" in the name

    thx for the help

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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.