View Full Version : Cube shows up in Saiku but not Pentaho Analysis

07-17-2013, 06:18 PM
Hey everyone,

I want to manually create a cube using a Mondrian.xml file and use the cube for analysis in Saiku and Pentaho Analysis. I have successfully created my cube and store it in the folder <pentahosolutions>/sledgehammer/analysis/MockData.mondrian.xml.


I setup my datasources.xml file to reference this as follows
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DataSourceDescription>Pentaho BI Platform Datasources</DataSourceDescription>
<Catalog name="SteelWheels">
<Catalog name="SampleData">
<Catalog name="MockData">

Now I go into Saiku and refresh and my Cube shows up! Great! :cool:


However, when I try to go open this up in the Pentaho New Analyis the cube doesnt show up.


I have read a couple posts that say that I should restart the server and it will pick up the cube. But I have tried that and nothing changes. Does any one have any other ideas about this? I have added the new files that have been created to pro_files table as well, dont know if that helps at all, but I am stumped as to why saiku would pick it up but not Pentaho. :confused:

Any and all help would be appreciated.

07-17-2013, 06:43 PM
ah! found another post that had answered my question, I needed to refresh the Mondrian Schema Cache. Sorry I hope I didnt waste anyones time