March 30, 2007 at 12:56 pm
In reporting services, I want the equivalent of this sql squery for a field, but in MDX:
Select SUM(weeklybalintran) when Intran = 31
April 1, 2007 at 8:57 pm
Try this (I'm no expert on MDX, but hopefully this will get you started).
Firstly, you'll need to have a measure for WeeklyBalIntran. You then need to compare this measure against a dimension, which might be customers, account numbers or products. Clearly you're after a total here and not interested in what it's compared against - since they all should be the same if not using any filters. Either way, you need to specify a ROWS component in your MDX. I'll assume you have a Customers dimension with an All level as the parent and a measure called WeeklyBalIntran. Finally, you'll need to have the types of InTran in another dimension. I'll assume you have a dimension called Intran, which includes an "All" level as the parent. I'll call your cube "MyCube".
Putting all this together, your MDX query might look like:
SELECT
{[Customers].[All Customers]} ON ROWS,
{[Measures].[WeeklyBalIntran]} ON COLUMNS
FROM [MyCube]
WHERE ([Intran].[All Intran].[31])
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply