Performance issue

[udaya_kumar]

Hi,

I have the fact table with 252 million rows and it is joined with other dimension tables.

I have a combo chart with product and month as the dimension and count(distinct id) as the expression.

I have a listbox with month and product selection. If i select few months in a listbox, then the chart takes nearly 40 - 60 secs to calculate the count. And when i check the value in Calctime of chart in sheet properties, it gives the value in millisecs as 41340 or 60432.

How to improve the performance of the chart?

[udaya_kumar]

Yes, there are two fields joined bw two fact tables, out of those one field is a key field in the data model.

I am using that key field to count the distinct id's based on month and the product wise.