Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Level Properties

  1. #1
    Join Date
    Nov 2011
    Posts
    2

    Post Level Properties

    Hi i'm a BI Developer and i have an issue:




    I have a problem with a property of a dimension, i want to show a sum of it on all levels of my dimension(there are 3 levels), but i only can make this appear on the lowest level.




    The current structure of the dimension levels is Year > Month > Day, the property can be viewed in the day level, on the ancestral levels i want to see the sum of the property, at months the sum of all days and at year the sum of all months.


    Thanks

  2. #2
    Join Date
    May 2010
    Posts
    21

    Default Seems to be a bug

    Hello,

    yes, I can confirm this behaviour.
    It seems to me that this is a bug.

    A similar problem appears when you want to filter "current month" or ''Next Month".
    This only works with the highest granularity "year" and does not work with quarters, month or days.

    If soembody has a solution for that, that would be great!

    Matthias

  3. #3
    Join Date
    Sep 2009
    Posts
    810

    Default

    mkober,

    I think you'd have to usa a calculated MDX member that uses a Sum() over the property value of the Descendants() of the lowest level.

    Cheers
    Slawo

Tags for this Thread

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.