Feeds:
Posts
Comments

Archive for March, 2010

The following mdx query works, which uses the combination of subselect and WHERE clause for multiple values of the report parameter.
 

SELECT

NON EMPTY [Measures].[Event Value] ON COLUMNS

,

NON EMPTY {(StrToMember(‘[Date].[Calendar].[Date].[2010-02-01]’):StrToMember(‘[Date].[Calendar].[Date].[2010-02-28]’))}

*

StrToSet(‘[Measure].[Measures].[Measure].&[JOHNSON]’)

* [Scenario].[Scenarios].[Scenario].&[BES]
* [Equipment].[Equipments].[Equipment].

MEMBERS

ON

ROWS

FROM

( SELECT ( STRTOSET(‘[Equipment].[Equipment Type].&[JUMBO]’, CONSTRAINED) ) ON COLUMNS

FROM [InSiteCube])

WHERE

( IIF( STRTOSET(‘[Equipment].[Equipment Type].&[JUMBO]’, CONSTRAINED).Count = 1, STRTOMEMBER(‘[Equipment].[Equipment Type].&[JUMBO]’, CONSTRAINED), [Equipment].[Equipment Type].currentmember ) )

Advertisements

Read Full Post »

%d bloggers like this: