Yes, I have considered support for parametric queries in MDX Studio - this is why MDX Studio supports parametric queries since version 0.2.5 :) All the functionality of MDX Studio works fine with parametric queries - Execute, Profile, Debug, Parse, Format, Analyze etc.
The way MDX Studio supports parametric queries makes it very simple to take verbatim from the profiler trace and paste into MDX Studio editor. Here is an example for typical Reporting Services query:
| Code: |
WITH
MEMBER [Measures].[Profit] AS
[Measures].[Sales Amount] - [Measures].[Standard Product Cost]
SELECT
NON EMPTY
{
[Measures].[Internet Sales Amount]
,[Measures].[Internet Total Product Cost]
,[Measures].[Internet Order Quantity]
} ON COLUMNS
FROM
(
SELECT
StrToSet
(@ProductCategory
,CONSTRAINED
) ON COLUMNS
FROM [Adventure Works]
)
WHERE
IIF
(
StrToSet(@ProductCategory,CONSTRAINED).Count = 1
,StrToSet
(@ProductCategory
,CONSTRAINED
)
,[Product].[Category].CurrentMember
)
CELL PROPERTIES
VALUE
,BACK_COLOR
,FORE_COLOR
,FORMATTED_VALUE
,FORMAT_STRING
,FONT_NAME
,FONT_SIZE
,FONT_FLAGS;
<Parameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:schemas-microsoft-com:xml-analysis">
<Parameter>
<Name>ProductCategory</Name>
<Value xsi:type="xsd:string">{ [Product].[Category].&[1],[Product].[Category].&[2] }</Value>
</Parameter>
</Parameters>
|
