Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Joining two cubes and get specific measure

  1. #1
    Join Date
    Aug 2014
    Posts
    1

    Default Joining two cubes and get specific measure

    Hi Every One,


    I´m very new in pentaho and I have spent a lot of time searching for a solution.


    The problem is related to how to join two cubes and get a measure of one cube in another one while I am in olap report, something like this:

    Name:  Cubes.jpg
Views: 30
Size:  19.5 KB


    The measure that I want is MEASURE_Y of the CUBE GOALS, which is related to the dimension DIM_PRODUCT of the CUBE SALES, and it is only showed when CUBE SALES is on PRODUCT Level of DIM_PRODUCT.

    I dont know how to resolve this, so if anyone can help me or guide me how to resolve this I would be great.



    Thanks a lot
    Last edited by Jaro; 08-08-2014 at 12:26 PM.

  2. #2
    Join Date
    Jan 2013
    Posts
    796

    Default

    Virtual cubes allow combining measures from multiple cubes, linked by shared dimensionality. See http://mondrian.pentaho.com/document...#Virtual_cubes

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.