PDA

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



and.decarlo
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.

11401

I setup my datasources.xml file to reference this as follows
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DataSources>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=Pentaho</DataSourceName>
<DataSourceDescription>Pentaho BI Platform Datasources</DataSourceDescription>
<URL>http://localhost:8080/pentaho/Xmla?userid=joe&amp;password=password</URL>
<DataSourceInfo>Provider=mondrian</DataSourceInfo>
<ProviderName>PentahoXMLA</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
<Catalogs>
<Catalog name="SteelWheels">
<DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo>
<Definition>solution:steel-wheels/analysis/steelwheels.mondrian.xml</Definition>
</Catalog>
<Catalog name="SampleData">
<DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo>
<Definition>solution:steel-wheels/analysis/SampleData.mondrian.xml</Definition>
</Catalog>
<Catalog name="MockData">
<DataSourceInfo>Provider=mondrian;DataSource=MockData</DataSourceInfo>
<Definition>solution:sledgehammer/analysis/MockData.mondrian.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>



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

11406


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

11407


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.

and.decarlo
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