Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Virtual cube MondrianException

  1. #1

    Default Virtual cube MondrianException

    Hi guys,

    when designing my application of a booking-report I created a cube including two dimensions: the bookings themselfes and the users. As the underlying tables have many attributes that I do not want to add in one single table, I normalised the booking-table by extracting the user-information to another table referred by a userID. When joining both together via a virtual cube I wanted to reuse the measures of both dimension but here comes the error: allthough there is a measure - let´s call it bookings - inside the booking-dimension and a measure users inside user-dimension, I cannot reuse them in the virtual cube.
    Here is a cut-off of my data-cube:
    Code:
    <Schema name="Test">
        <Cube name="Bookings" cache="true" enabled="true">
            <Table name="bookings" schema="public">
            </Table>
            <Dimension type="StandardDimension" foreignKey="fid" highCardinality="false" name="FZ">
                ...
            </Dimension>
            <Dimension type="StandardDimension" foreignKey="rid" highCardinality="false" name="reservations">
                ...
            </Dimension>
            <Measure name="Number Bookings" column="pidn" datatype="Integer" aggregator="count" visible="true">
            </Measure>
        </Cube>
    
        <VirtualCube enabled="true" name="Bookings Users">
            <VirtualCubeDimension cubeName="Bookings" foreignKey="rid" highCardinality="false" name="reservations">
            </VirtualCubeDimension>
            <VirtualCubeDimension cubeName="Bookings" foreignKey="fid" highCardinality="false" name="FZ">
            </VirtualCubeDimension>
            </VirtualCubeMeasure>
            <VirtualCubeMeasure cubeName="Bookings" name="Number Bookings" visible="true">
            </VirtualCubeMeasure>
        </VirtualCube>
    </Schema>
    Where rid and fid are the IDs used in the dimension-tables of bookings resp. users.

    When connecting to this cube I allways get the following exception:
    Code:
    Exception: Mondrian Error:Internal error: could not find measure 'Number Bookings' in cube 'Bookings'
    On the other hand, when I perform a query on the real-cube, f.eg. the following:
    Code:
    select [Measures].[Number Bookings] on columns,
    [FZ.Type].Children on rows
    from [Bookings]
    I recieve no errors but a complete table of my table as demanded so the measure exists inside the cube allthough the mentioned error claims sth. different.

    How can I achieve using the measures from my real-world cube inside the virtaul cube?


    This issue is referred to Schema Workbench 3.2.1.
    Last edited by HimBromBeere; 09-25-2012 at 03:04 AM.

  2. #2

    Default

    OK, I answer my own question by just linking to another thread I just found on this forum for all those who run into the same issue. Adding the key-word [Measures] to the name-attribute of the virtaul measure resolved this problem.
    Last edited by HimBromBeere; 09-25-2012 at 03:16 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.