Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Exception with Virtual cube in schema

  1. #1

    Default Exception with Virtual cube in schema

    Hi,

    i have the schema with 2 shared dimensions used in two distinct cubes (see bellow).
    Name:  cube.jpg
Views: 139
Size:  59.1 KB
    The schema is working fine with this MDX :

    select {[Measures].[montant_brut]} ON COLUMNS,
    {examen_ocean.type.MEMBERS} ON ROWS
    from [depenses]

    I want to join these two cubes into a virtual cube named v_depenses in my schema.

    But i have the following exception when i run the previous MDX :

    mondrian.olap.MondrianException: Mondrian Error:Internal error: could not find measure 'montant_brut' in cube 'depenses'

    mondrian.olap.MondrianException: Mondrian Error:Internal error: could not find measure 'montant_brut' in cube 'depenses'
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752)
    at mondrian.olap.Util.newInternal(Util.java:1076)
    at mondrian.rolap.RolapCube.(RolapCube.java:348)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:409)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:300)
    at mondrian.rolap.RolapSchema.(RolapSchema.java:213)
    at mondrian.rolap.RolapSchema.(RolapSchema.java:76)
    at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:835)
    at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:657)
    at mondrian.rolap.RolapConnection.(RolapConnection.java:148)
    at mondrian.rolap.RolapConnection.(RolapConnection.java:79)
    at mondrian.olap.DriverManager.getConnection(DriverManager.java:122)
    at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:472)
    at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)
    at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77)
    at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76)
    at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160)
    at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)
    at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:112)....


    Any Ideas ?

    Eric

  2. #2
    Join Date
    Oct 2007
    Posts
    255

    Default asdf

    Well, better late than never, hope you figured it out, but for the sake of others who may run into this issue (and you if you haven't solved it):

    When constructing the virtual cube and adding measures, be sure you specify the qualified schema name for a measure. For example, if a cube contains the measure "monies", when adding the measure to your virtual cube it would look like this:

    Code:
    <VirtualCubeMeasure cubeName="The Cube" name="[Measures].[monies]" visible="true">
    </VirtualCubeMeasure>

    ... note that I gave as a name for the measure [Measures].[monies], not just monies.

    -Brian

  3. #3
    Join Date
    Feb 2008
    Posts
    3

    Default

    Wow....Brian thought he was late, but here I am three and a half years latter thanking him!!!

    Thank you so very much for you belated post!!! Saved me some serious time today.

  4. #4
    Join Date
    Mar 2012
    Posts
    3

    Default

    I'm facing the same problem as you.

    Would you suggest another thing to check/verify?
    Because I've already followed Phantal's suggestion but the exception is still there

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.