Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: calculated measure containing 2 columns from the fact table

  1. #1
    Join Date
    May 2011
    Posts
    14

    Default calculated measure containing 2 columns from the fact table

    Hi,
    Is it possible to multiple 2 columns of the fact table in a calculated measure in schema workbench?

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    Assuming you mean "multiply", just add a Calculated Member in workbench and type in the formula. Look here for some examples of formulas.

    http://mondrian.pentaho.com/document...ulated_members
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  3. #3
    Join Date
    May 2011
    Posts
    14

    Default

    Thank you for your help..
    I did not know its that easy..

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.