Hello All,

I am having a big problem with analyzer performance. The Date set is around 4000k rows, is this a problem for Pentaho!!?
when i am performing a simple query (ID + Place name) it takes a very long time, around 20m!! the more fields added to the report the worst it is
This is the cube:
Code:
  <Cube name="Zdaten" visible="true" cache="true" enabled="true">
    <Table name="F_ZTZ1">
      <SQL dialect="oracle">
        <![CDATA[(F_ZTZ1.id in (%Client%))]]>
      </SQL>
    </Table>
    <DimensionUsage source="Mnt" name="Mt" visible="true" foreignKey="EN_ID" highCardinality="false"></DimensionUsage>
    <DimensionUsage source="Kinn" name="Kinn" visible="true" foreignKey="EN_ID" highCardinality="false"></DimensionUsage>
    <DimensionUsage source="Kh" name="Koh" visible="true" foreignKey="EN_ID" highCardinality="false"></DimensionUsage>

    <Measure name="Anhl" column="ANLE" formatString="#" aggregator="count"></Measure>

  </Cube>

can anyone help, PLz ?
Thanks