Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
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?
Thank you,
Kiruthiga
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?