Databases Reference
In-Depth Information
[Date].[Fiscal].CurrentMember, IIF ( STRTOSET
(@CustomerTotalChildren,
CONSTRAINED).Count = 1, STRTOSET
(@CustomerTotalChildren, CONSTRAINED),
[Customer].[Total Children].currentmember ) ) CELL
PROPERTIES VALUE, BACK_COLOR,
FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING,
FONT_NAME, FONT_SIZE, FONT_FLAGS
Your client application would send the preceding query along with the list of
parameters and values. When you execute the query you will get the results
similar to executing regular queries. The following is an XMLA script that
shows how the parameters are sent to Analysis Services. You have a name
and value pair specified for each parameter in the query under the Paramet-
ers section of the XMLA script for query execution.
<Envelope xmlns=";http://schemas.xmlsoap.org/soap/
envelope/">
<Body>
<Execute
xmlns="urn:schemas-microsoft-com:xml-analysis">
<Command>
<Statement>
select [Measures].members on 0,
Filter (Customer.[Customer
Geography].Country.members,
Customer.[Customer
Geography].CurrentMember.Name = @CountryName) on 1
from [Adventure Works]
</Statement>
</Command>
<Properties />
<Parameters>
<Parameter>
<Name>CountryName</Name>
<Value>'United Kingdom'</Value>
</Parameter>
</Parameters>
</Execute>
Search WWH ::
Custom Search