I'm using Pentaho 4.8 with Saiku, and would like to know how I set up a cube (xml file created in Schema Workbench).
Previously I was using Pentaho 5, it was enough for me to add Datasource and Analysis to DataSource Manager, but in Pentaho 4.8 I'm having difficulty.
I do not know if I understood the question well, but I imagine what you're saying is that in Pentaho 5 it's possible to upload XML, and you're not getting it in 4.8, am I sure?
Assuming it's what I understood.
Prior to version 5 of Pentaho it was necessary to prepare the environment only after publishing the solutions created in the Pentaho Schema Workbench (PSW). To do this, do the following:
a) Stop your server (if it's on the air)
b) Open the publisher_config.xml file that is inside a subfolder 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.
a) With your PSW already open go to File - > Publish.
b) On the screen that opens, enter the URL of the BI Server, the publisher password (which was configured in the previous step) and user and password to access Pentaho.
c) If you have logged in correctly, you will be able to choose which datasource the XML you are publishing will be related to, and you can choose the folder that will be saved to xml.
a) Now just go to the BI Server, and test the cube you've published in any analysis tool you have, either jPivot, Saiku.