Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Calculated member

  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Default Calculated member

    Just want to know whether Mondrian supports calculated members. If yes, could you please explain how to use this feature. Thanks a lot.

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: Calculated member

    Mondrian supports calculated members defined within queries (that is WITH MEMBER ... SELECT) but not defined within cubes.
    For documentation, search MSDN:
    http://www.google.com/search?q=site:...ated+member%22

  3. #3
    Join Date
    Nov 2003
    Posts
    6

    Default RE: Calculated member

    I saw there were some calculated member definition in FoodMart. They look like:
    <CalculatedMember name="Employee Salary" dimension="[Measures]" formatString="Currency"
    formula="(employees.currentmember.datamember, [Measures].[Org Salary])"/>
    <CalculatedMember name="Avg Salary" dimension="[Measures]" formatString="Currency"
    formula="[Measures].[Org Salary]/[Measures].[Number of Employees]"/>
    Can I use these members.
    Thanks for your previous reply

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.