I am trying to explore the hybrid approach of qlikview where in I am using direct discovery to load data from HANA and create reports. I have 5 dimension fields and 2 measure fields. but when i create a pivot table , i get error "allocated memory exceeded' and for table box , "Direct query failed" error .
I am running a sample data set of approx 23k rows. When I use the classic approach , I can easily read data from the underlying HANA system.