Question

Hi.I am trying to use the new 2.2 version of saiku with my cubes and they worked correctly with version 2.1 of saiku. I am comparing the result between both versions of saiku with same catalog and the same database and the result is different when the dimension has more of one level. The mdx query is also different (logically!). The old one shows me Members and the new one shows me All Members without mind what level I choose.

Here you can see examples of my dimension; <dimension name="Operations" foreignkey="MFHCLHA"> <hierarchy name="Operations Tipos de operación" hasall="true" primarykey="ID">

The biggest one I have is this one: <dimension name="Instalaciones" foreignkey="MBV__2A"> <hierarchy name="Instalaciones Barrios" hasall="true" primarykey="ID">

<level name="Distrito" column="MKJT9XQ" type="String" uniquemembers="true"/> <level name="Barrio" column="MOOIBZQ" type="String" uniquemembers="false"/> <level name="Instalación" column="MWPVWTQ" type="String" uniquemembers="false"/> </hierarchy> <hierarchy name="Instalaciones Componente" hasall="true" primarykey="ID"> <level name="Proveedor" column="M3CXHXQ" type="String" uniquemembers="true"/> <level name="Modelo" column="MGYGCJA" type="String" uniquemembers="false"/> <level name="Componente" column="MVCTVZA" type="String" uniquemembers="false"/> <level name="Instalación" column="MWPVWTQ" type="String" uniquemembers="false"/> </hierarchy> </dimension> Can somebody help me and tell me why? is it something wrong? Thanks!!!!

Answer 1

0	can you maybe post me a screenshot of the two different resultsets and explain using them what you expect to see? thanks link answered 09 Jan, 14:25 pstoellberger ♦♦ 897●2●7 accept rate: 5%

Answer 2

Yes,of course! The first image is the result with old version of saiku and I attached the xml of saving the mdx query. alt text

<Axes>

  <Axis location="ROWS" nonEmpty="true">

    <Dimensions>

      <Dimension name="Operaciones" hierarchizeMode="PRE" hierarchyConsistent="true">

        <Inclusions>

          <Selection dimension="Operaciones" type="level" node="[Operaciones.Operaciones Tipos de operación].[Operación]" operator="MEMBERS" />

        </Inclusions>

        <Exclusions />

      </Dimension>

    </Dimensions>

  </Axis>

  <Axis location="COLUMNS" nonEmpty="true">

    <Dimensions>

      <Dimension name="Instalaciones" hierarchizeMode="PRE" hierarchyConsistent="true">

        <Inclusions>

          <Selection dimension="Instalaciones" type="level" node="[Instalaciones.Instalaciones Componente].[Componente]" operator="MEMBERS" />

        </Inclusions>

        <Exclusions />

      </Dimension>

    </Dimensions>

  </Axis>

  <Axis location="FILTER" nonEmpty="false" />

</Axes>

</querymodel>

<mdx>SELECT

NON EMPTY {Hierarchize({[Instalaciones.Instalaciones Componente].[Componente].Members})} ON COLUMNS,

NON EMPTY {Hierarchize({[Operaciones.Operaciones Tipos de operación].[Operación].Members})} ON ROWS

FROM [cube.operaciones]</mdx>

</query>

Next I show the image of the result and the xml of the saving mdx query with saiku 2.2

alt text

<Axes>

  <Axis location="ROWS" nonEmpty="true">

    <Dimensions>

      <Dimension name="Operaciones" hierarchizeMode="PRE" hierarchyConsistent="true">

        <Inclusions>

          <Selection dimension="Operaciones" type="member" node="[Operaciones.Operaciones Tipos de operación].[All Operaciones.Operaciones Tipos de operacións]" operator="MEMBER" />

        </Inclusions>

        <Exclusions />

      </Dimension>

    </Dimensions>

  </Axis>

  <Axis location="COLUMNS" nonEmpty="true">

    <Dimensions>

      <Dimension name="Instalaciones" hierarchizeMode="PRE" hierarchyConsistent="true">

        <Inclusions>

          <Selection dimension="Instalaciones" type="level" node="[Instalaciones.Instalaciones Componente].[Componente]" operator="MEMBERS" />

        </Inclusions>

        <Exclusions />

      </Dimension>

    </Dimensions>

  </Axis>

  <Axis location="FILTER" nonEmpty="false" />

</Axes>

</querymodel>

<mdx>SELECT

NON EMPTY {Hierarchize({[Instalaciones.Instalaciones Componente].[Componente].Members})} ON COLUMNS,

NON EMPTY {Hierarchize({[Operaciones.Operaciones Tipos de operación].[All Operaciones.Operaciones Tipos de operacións]})} ON ROWS

FROM [cube.operaciones]</mdx>

</query>

Both consults have been doing with the same catalog and the same datas.If you need more information, let me know please.

Thanks for your time!

Answer 3

0	I have same problem. link answered 19 Jan, 09:37 metlas 1 accept rate: 0%

Answer 4

0	your two queries are different of course you see different results..... can you click on the "operacion" level that you put on rows and show me what comes up link answered 24 Jan, 03:57 pstoellberger ♦♦ 897●2●7 accept rate: 5%

Answer 5

May be I didnt explain so good. The queries are generated by saiku, no by me. I chose the same things and saiku generated different queries in each version.Version 2.1 generated a query with members operation and version 2.2 generated a query with all operation. That is what I dont understand because everything is equal and my procedure is the same too. thanks!

Here I attach the image of what you ask me ;) alt text

Answer 6

0	You will see different datas because DB has changed this week, but it could not be a problem. link answered 24 Jan, 06:00 alorenzo 1●1●1 accept rate: 0%

Answer 7

0

sorry but i cant tell you whats going on. the mdx you showed me for 2.2 does not correspond to the UI screenshots you're posting. without having access to the system (at least the UI) i can't tell you what the problem is....

-paul

link

answered 24 Jan, 16:48

pstoellberger ♦♦
897●2●7
accept rate: 5%

Answer 8

0

Paul thanks for trying help me.I think I dont explain very well. The mdx generated in the last screenshot is the same that the first screenshot of saiku2.2.Why did you say it is different?

Any way,could you tell me if it possible that the saiku 2.2 generates different queries than 2.1 with the same cube when I choose the same dimensions,levels and measures?Thanks

link

answered 25 Jan, 03:38

alorenzo
1●1●1
accept rate: 0%

Answer 9

0	no, it should generate the same query and i meant the screenshot and the generated query are not matching, for me it looks like they dont match.... link answered 26 Jan, 07:09 pstoellberger ♦♦ 897●2●7 accept rate: 5%

Why are different results between two saiku versions?

Follow this question

Related questions