I have a transaction fact with customers and trans_id which is connected to dimension product_table via prod_id. When I try to create a chart for customer's trans_id count for the products, I always end up in out of memory due to high volume of trans_id associated for a customer. I can't split this report further down as this is at the aggr level we are looking for.
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?