How to write the where condition in MDX.

[madarapuv]

Hello,

I've designed analysis view schema and wrote the mdx query, view is running successfully but my question how to write the where condition in analysis views.


My table design is:

Property_Id,
Property_code
Brand,
Region.

MDX query:
SELECT {[Measures].[Accom Under Maint]} ON COLUMNS , {[brand].[brand]} ON ROWS FROM [Test]


For mdx query I want add where condition like “where Property_code=’H2’”

 

and here is the schema design:

<Schema name="JasperIntelligence Profiling">
   <Cube name="Test" cache="false" enabled="true">
        <Table name="Vw_Total_Attributes"/>

        <Dimension name="Brand">

<Hierarchy hasAll="true" allMemberName="Brand1" primaryKey="Property_ID">
<Table name="Vw_Total_Attributes"/>
<Level name="BrandName" column="Brand" uniqueMembers="true"/>
<Level name="RegionName" column="Region" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Measure name="Accom Under Maint" column="Property_ID" aggregator="sum" formatString="#,##0"/>
</Cube>
</Schema>

Please suggest me.

Find the attached schema design.

[shivareddyk]

some thing like this..

*u can choose those things from (change data cube),

from [your cube name] where [Property_code].[H2]

 

gudluck