PDA

View Full Version : MDX help (member properties)



abz_diego
10-08-2003, 07:28 AM
this is my MDX query:
with member [product].[height] as 'product.[All products].[line1].[product2].Properties("height")'
select {[product].[height]} ON columns
from [sales]
the question is: with this mdx query i can see product's heigth but only for product 2.
How can be a MDX query that let me see the heigth for all products in this specific level?
thanks

jhyde
10-08-2003, 09:01 AM
Here is a query which does what you are asking:
WITH
MEMBER [Measures].[Store Type] AS
'[Store].CurrentMember.Properties("Store Type")'
SELECT
{ [Measures].[Store Sales], [Measures].[Store Type] } ON COLUMNS,
{ [Store].[Store Name].members} ON ROWS
FROM Sales
I get the impression that you are trying to approach the problem as you would a SQL query. Forget about SQL. MDX is a very different language. Most MDX queries have two axes, so you should at least add an 'ON rows' clause to your query. Get it working with regular measures (e.g. [Measures].[Unit Sales]) first, then add property-based members to it.