I appreciate your time. I am looking for a best approach to handle my below scenario.
I have a transaction fact with customers and trans_id connected to product_table via prod_id. When I try to create a chart for customer count with resp to trans_id for the products, I always end up in out of memory due to high volume of transactions.
As of now I am creating a straight table and using the product_id as dim and count(trans_id) as exp.
Instead can we do some thing in the qvd layer to get the count of transactions and display in a table box will resolve this issue?
could you let me know your suggestions or feedback?
I'd also be interested in hearing how other folks handle large transactional datasets. I kno that ODAG is an option, but are folks implementing other strategies to optimize performance (both front end and back end) of large transactional data sets?
