Granularity issue

[#1]

Hi,

I got one dimension in my pivot chart whose granularity is per row. When number of rows grows bigger then report loads very slow. This dimension is one of the columns in the fact table.

May I know the reason behind it?

This

Saurabh

[its_anandrjs]

Check in the expression if there nested if condition that may cause that the chart is load slowly. If expression contains if nested condition time increases in the chart and ram is consumed also if so then use SET analysis in the chart for the expression.

Regards

[#3]

I have a simple If statement and when i replace this highest granular dimension with lesser one then reports works very fast.

[#4]

If you have lot of Text values and all unique then rendering would be slow on UI