Results 1 to 2 of 2

Thread: Member Properties Calculation

  1. #1
    Join Date
    Feb 2005

    Member Properties Calculation

    Hi everybody!!! I have the folowing problem:

    Iīve created a dimension with a member properties, this member propertie is a number.. Ex: dimension EMPLOYEE, and member propertie AGE.

    Then i create a Calculate Member like this:
    (I called it EmployeeAge)"age")

    Now i want to make an operation with this new member like sum this member to another.
    Ex: NewMeber = [Measure].[EmployeeAge]+[Measure].[Salary]
    I couldnīt do this, i get an #ERR

    Someone can help me?


  2. #2
    Join Date
    Jun 2004
    Atlanta and Manhattan

    You likely need only to convert the text-string member property (that's just the way they're stored) to a numerical value so you can perform math with it.

    See my example on Page 3 of the article I published at this Database Journal URL:

    Let us know if ot works for you ...

    Good Luck!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts