Results 1 to 2 of 2

Thread: Member Properties Calculation

  1. #1
    Join Date
    Feb 2005
    Posts
    16

    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)

    employee.currentmember.properties("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?

    Tks!
    Pablo

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607
    Hi:

    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:

    http://www.databasejournal.com/featu...le.php/3107081

    Let us know if ot works for you ...

    Good Luck!

    Bill

Posting Permissions

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