Pentaho 4.8 - Importing a Schema (Cube)

Asked

Viewed 1,049 times

0

I am using Pentaho 4.8 with Saiku, and would like to know how I configure a cube (xml file created in Schema Workbench).

Previously I was using Pentaho 5, it was enough to add Datasource and Analysis in Datasource Manager, but in Pentaho 4.8 I’m having difficulty.

xml-schema pentaho

  • I would like to understand the downvote in this question considering that questions related to BI has a great acceptance as on-topic.

1 answer

2

I’m not sure I understand the question, but I imagine what you’re saying is that in Pentaho 5 you can upload XML, and you’re not getting that in 4.8, I’m sure?

Supposing that’s what I understood.

Before version 5 of Pentaho it was necessary to prepare the environment and only then manage to publish the solutions created in Pentaho Schema Workbench (PSW). To do this, do it:

Step 1: Preparing the BI Server Environment:

a) Stop your server (if you are in the air)

b) Open the file publisher_config.xml that is inside a sub-folder of Pentaho BI Server: pentaho/biserver-ce-4.8.0/biserver-ce/pentaho-solutions/system/publisher_config.xml

c) Add your Publisher password: 

<publisher-config>
    <publisher-password>AQUI_VAI_SUA_SENHA_DE_PUBLISHER</publisher-password>
</publisher-config>

d) Restart your server.

Step 2: Using PSW to Publish Mondrian xml.

a) With your PSW already open go to File -> Publish.

b) On the screen that opens, enter the URL of the BI Server, the password of Publisher (which was configured in the previous step) and user and password access to Pentaho.

c) If you have logged in correctly, on the next screen you can choose which datasource the XML you are publishing will be related to, and you can choose the folder that will be saved xml.

Step 3: Testing.

a) Now just go to BI Server, and test the cube you have published in any analysis tool you have, be it jPivot, Saiku.

Browser other questions tagged xml-schema pentaho

You are not signed in. Login or sign up in order to post.