Creating filter in MDX for use with Saiku

[Marcio Alves de Lima]

Dear,

I'm conducting tests to Saiku Enterprise use of feasibility analysis mainly exploring the use of API to send the MDX to be processed. Although I'm not getting.

I tried to mount the MDX to "Filter" and also in clause "Where" adapting information I found on forums, but without success. :(

Please can anyone help me in creating the MDX?

 

To rescue [Teste.Teste1] with values below 5, the Saiku used to generate the MDX selecting some values.

However, I have tried unsuccessfully to apply a clause in the MDX to rescue only [Teste.Teste1] which is less than 5 ([Teste.Teste1] <5).

 

Please can someone help me create the MDX to retrieve the information which [Teste.Teste1] <5, in order to not have to select values one by one as the MDX created by Saiku Analytics?

Below is the cube xml and also an MDX statement to illustrate my problem.

-- XML cube -- 

<Cube name="PJ" visible="true" cache="true" enabled="true">

    <Table name="fato_empresa" schema="public">

    </Table>

    <Dimension type="StandardDimension" visible="true" foreignKey="sk_cnae" name="Teste">

        <Hierarchy name="Teste1" visible="true" hasAll="true" primaryKey="sk_cnae">

            <Table name="dim_cnae" schema="public" alias="">

            </Table>

            <Level name="cnae_setor_econ_cod" visible="true" column="cnae_setor_econ_cod" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">

            </Level>

        </Hierarchy>

    </Dimension>

    <Measure name="Empresas (ativas)" column="flag_estab_ativo" datatype="Integer" aggregator="sum" visible="true">

    </Measure>

</Cube>

 

-- MDX created by Saiku Analytics --

WITH

SET [~ROWS] AS

    {[Teste.Teste1].[1], [Teste.Teste1].[2], [Teste.Teste1].[3], [Teste.Teste1].[4]}

SELECT

NON EMPTY {[Measures].[Empresas (ativas)]} ON COLUMNS,

NON EMPTY [~ROWS] ON ROWS

FROM [PJ]

Thanks in advance

Marcio Alves de Lima

Database Analyst