The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

ezimanyi (3) [Avatar] Offline
#1
Hi

I am using Mondrian 4.0 and Saiku, obtained from the following address
http://ci.analytical-labs.com/job/saiku-mondrian4/

When I use the solution proposed in Section 5.1.4 Using a dimension twice in the same cube I get an error message

mondrian.olap.MondrianException: Mondrian Error:Internal error: Could not find path to time
[....]
Caused by: mondrian.rolap.RolapSchema$PhysSchemaException: Could not find a path from time as time_1 to any of [time]

Am I doing something wrong ? I can send the xml schema file or summarize it in a a message.

Regards

Esteban
william.back (28) [Avatar] Offline
#2
Re: Shared dimensions used several times in the same cube
Can you upload the XML here (not sure if the site supports uploads, bub maybe insert)? Sounds like an error in the schema.
ezimanyi (3) [Avatar] Offline
#3
Re: Shared dimensions used several times in the same cube
Many thanks for your quick reply William!

I don't know how to upload files here. If you send me an email to ezimanyi@ulb.ac.be I can send you the XML file.

In any case, the structure of the XML schema file is as follows

----------------------------
<?xml version="1.0"?>
<Schema name="NorthwindDW" metamodelVersion="4.0">
<PhysicalSchema>
<Table name="category" keyColumn="categorykey" />
<Table name="product" keyColumn="productkey" />
<Table name="sales" />
[...]
<Table name="time" keyColumn="timekey">
<ColumnDefs>
[...]
</ColumnDefs>
</Table>
<Link source="category" target="product" foreignKeyColumn="categorykey" />
[...]
<Link source="time" target="sales" foreignKeyColumn="orderdatekey" />
<Link source="time" target="sales" foreignKeyColumn="duedatekey" />
<Link source="time" target="sales" foreignKeyColumn="shippeddatekey" />
</PhysicalSchema>

<Dimension name="Time" table="time" type="TIME" key="Time Key" >
<Attributes>
[...]
</Attributes>
<Hierarchies>
[...]
</Hierarchies>
</Dimension>

<Cube name="Sales" defaultMeasure="Sales Amount">
<Dimensions>
<!-- Shared dimensions -->
<Dimension name="Order Date" source="Time" />
<Dimension name="Due Date" source="Time" />
<Dimension name="Shipped Date" source="Time" />
<!-- Dimensions -->
[...]
</Dimensions>

<MeasureGroups>
<MeasureGroup table="sales">
<Measures>
[...]
</Measures>
<DimensionLinks>
<ForeignKeyLink dimension="Customer" foreignKeyColumn="customerkey" />
<ForeignKeyLink dimension="Supplier" foreignKeyColumn="supplierkey" />
<ForeignKeyLink dimension="Employee" foreignKeyColumn="employeekey" />
<ForeignKeyLink dimension="Order Date" foreignKeyColumn="orderdatekey" />
<ForeignKeyLink dimension="Due Date" foreignKeyColumn="duedatekey" />
<ForeignKeyLink dimension="Shipped Date" foreignKeyColumn="shippeddatekey" />
<ForeignKeyLink dimension="Product" foreignKeyColumn="productkey" />
<FactLink dimension="Order" />
<ForeignKeyLink dimension="Shipper" foreignKeyColumn="shipperkey" />
</DimensionLinks>
</MeasureGroup>
</MeasureGroups>
</Cube>
</Schema>
----------------------------

Regards

Esteban
ezimanyi (3) [Avatar] Offline
#4
Re: Shared dimensions used several times in the same cube
Any news on this ? How to define a shared dimension and use it several times in the same cube ? This is a typical situation with Time dimensions ...
Any help on this is most appreciated.
Regards
Esteban
wahmed (1) [Avatar] Offline
#5
Re: Shared dimensions used several times in the same cube
I am facing the similar problem. Any solution?