Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problems when publishing cube, it is published but it is not displayed.

  1. #1
    Join Date
    Nov 2015
    Posts
    8

    Default Problems when publishing cube, it is published but it is not displayed.

    Hi.

    I have a cube published in a B.D. Oracle, that works for me.

    Another Oracle Database server has been mounted. In the Workbench scheme, the new connection is taken into account, and the Oracle schema also changes.

    The tables have been copied to the new B.D.


    In the Workbench scheme it does not give any errors, it publishes correctly, but when in the BI console, I create a new saiku, it does not visualize the cube.

    The connection is correct in both Workbench and BI, since the test gives me ok.

    In the catalina logs or I see nothing, that tells me not to like the cube.

    How can I find out where the problem is?

    Thank you

  2. #2
    Join Date
    Nov 2015
    Posts
    8

    Default

    I have detected that the problem is in the role section. If I remove this the cube is displayed well. That section is correct, since published in another BD oracle, same version, same model of tables, works, having well the data of connection and scheme of the same.

    When a cube is published, and this is not visualized by some problem in saiku, there is some log or site where you can see what the problem is, what it does not like. In the log of catalina I do not see anything about it. ??

  3. #3
    Join Date
    Nov 2009
    Posts
    652

    Default

    You have to enable the Mondrian logging in the log4j.xml (..\pentaho-server\tomcat\webapps\pentaho\WEB-INF\classes)
    Can you see the cube in the JPivot view?

  4. #4
    Join Date
    Nov 2015
    Posts
    8

    Default

    Hi.

    I have already found the solution, I had detected that the problem was given by the "Role" section in the scheme. I have removed it, I have redefined it and it works.

    When I removed the role section, it worked in mondrian and jpivot.

    Thank you.

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.