We believe that we may have found the issue with regard to this
The problem lies in our QlikView Application. I believe
that when a QlikView application passes a certain volume of data, the
application does not behave as it should.
In this instance, our application’s data structure is made up of
multiple tables. (please see below)
When a user selects dimensions that represent different
granularities of data, for example selecting BIR Flag in the Bet
Table, Event in the Selection Table, Affiliate Name in the Customer
Table and a Date Time dimension, the issue described
below occurs. The solution to this is to try and amalgamate the majority of these data
tables (Customer, Selection and Bet) in to 1 fact table.
If you have any queries I would be more than happy to help.
Thanks very much.