Profile

Werther Dryden

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 9 of 9 total

RE: Mondrian 4: Performance and high cardinality dimensions

Posted By Werther Dryden 08-12-2021 13:38
Found In Community: Pentaho \ view thread
@Carlos Lopez​ : Hi 😃 , just wanted to ask if there is any update on this topic?

RE: Mondrian 4: Performance and high cardinality dimensions

Posted By Werther Dryden 04-30-2021 08:03
Found In Community: Pentaho \ view thread
saiku_ui.png

RE: Mondrian 4: Performance and high cardinality dimensions

Posted By Werther Dryden 04-30-2021 08:00
Found In Community: Pentaho \ view thread
Hello Carlos,     I built a small Mondrian 3 Cube containing only the necessary Dimensions and Measures: mondrian3_schema.xml (see above) Here my mondrian.propertis (see above) file which I´ve used for this test. I know it´s quite messy because I´ve tried a lot of things to solve my performance problem ...

RE: Mondrian 4: Performance and high cardinality dimensions

Posted By Werther Dryden 04-30-2021 07:57
Found In Community: Pentaho \ view thread
postgres.log

RE: Mondrian 4: Performance and high cardinality dimensions

Posted By Werther Dryden 04-30-2021 07:57
Found In Community: Pentaho \ view thread
mondrian.log

RE: Mondrian 4: Performance and high cardinality dimensions

Posted By Werther Dryden 04-30-2021 07:56
Found In Community: Pentaho \ view thread
mondrian3_schema.xml

RE: Mondrian 4: Performance and high cardinality dimensions

Posted By Werther Dryden 04-30-2021 07:56
Found In Community: Pentaho \ view thread
mondrian.properties

RE: Mondrian 4: Performance and high cardinality dimensions

Posted By Werther Dryden 04-15-2021 20:00
Found In Community: Pentaho \ view thread
Thanks @Carlos Lopez​  for the feedback :) We will try it next week with Mondrian 3 and I will let you know.

Mondrian 4: Performance and high cardinality dimensions

Posted By Werther Dryden 03-20-2021 15:20
Found In Community: Pentaho \ view thread
Hello,   I have a Customer Dimension with about 900000 entries and a fact table with about 1.5 million entries. Everything implemented in a star schema with a simple Mondrian 4 Schema structure. In the MDX Query below I am (actually it is automatically generated by Saiku) trying to display all the customer ...