Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Is there any constructs in metadata which is comparable to virtual cubes in mondrian?

  1. #1

    Default Is there any constructs in metadata which is comparable to virtual cubes in mondrian?

    Hi,

    Is there any constructs in metadaata which is comparable to virtual cubes(idea is to join 2 or more facts) in mondrian??If not, is this doable in metadata ??

  2. #2
    Join Date
    Apr 2009
    Posts
    337

    Default

    Fetching from two facts must be a straight through process, unless you are joining a fact to a fact!! I do not think even virtual cubes do them for you, it is just to get data between facts which have certain conformed dimensions!

    Any ways, to join a fact with a fact, read this post by diethard steiner:
    http://diethardsteiner.blogspot.com/...ng-two_04.html
    Regards,
    Madhu

  3. #3

    Default

    Thanks Madhu,

    Is there any equivalent construct of the Mondrian MDX "ValidMeasure" present in Metadata(the idea being to see the measure aggregated across an irrelevant dimension rather than showing empty result set).

  4. #4
    Join Date
    Apr 2009
    Posts
    337

    Default

    I'm not aware of such a thing, but what is the use case ? It should be do-able through other ways..
    Regards,
    Madhu

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.