-
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
-
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
-
Forum Rules
|
|