PDA

View Full Version : Calculated member



huyhoang
11-17-2003, 03:16 PM
Just want to know whether Mondrian supports calculated members. If yes, could you please explain how to use this feature. Thanks a lot.

jhyde
11-17-2003, 03:31 PM
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:msdn%2Emicrosoft%2Ecom+%22calculated+member%22

huyhoang
11-17-2003, 04:08 PM
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