Accessing Dimension Properties Using MDX 2005
-
I'm running the following query through SSMS:
SELECT [Measures].[Qty On Hand] ON COLUMNS,
[Current Items].[Product Category].[Item Id].Members
DIMENSION PROPERTIES [Item Id].[Source],
[Item Id].[Material Status] ON ROWS
FROM [Current]
The query only shows me the members of Item Id, and the member properties don't show on my rows. When I run the query through BIDS, I get no values for my rows at all, and the only column to be returned is the Qty On Hand measure. What am I missing here? I can use .Properties() without any problem, but I understand this should be avoided in 2005. That and it's easier to code DIMENSION PROPERTIES
-
I believe access to the dimension properties is dependent on the tool being used. I haven't found that SSMS pulls them up.
The real question, is how you're using / accessing the MDX from an application perspective. Is it working there?
-
I'm using Reporting Services to pull the values through (this is my end goal) and it doesn't show them. Looks like I might have to go back to .Properties
. Frustrating that Microsoft's own tools don't work with these new features of AS2005. -
Correct. MSRS isn't really "OLAP" aware, but can use / consume OLAP data. Hopefully, the RS team will work more closely with the AS team in the future.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply