Chart Calc time is high

[santhosh_k_n]

Hi All,

I am facing problem while opening a chart in access point.

I had used a pivot table chart, the sheet has similar pivot tables.

What the issue is the new pivot table is having long calc time if i check in, settings > Doc Properties > sheets

the particular chart is taking a huge time and also through allocated memory exceeded in desktop clint and it not at all getting opened in access point.

Please guide me

[ashfaq_haseeb]

Hi,

It depends on the many factors like.

1. Data model design
2. Calculation used
3. Virtual Server used
4. Type of expression used
5. No. of fields used to display in your Pivot table.

May be you have to increase your ram and cpu core. It depends.

Regards

ASHFAQ

[tresesco]

I would start from two basic points to trace down the issue:

• Check chart expression and try to optimize it if there is any scope
• Data model    

[jagan]

Hi Santosh,

Try below points

- If you are using any calculations in front end, move it to script and avoid Calculated dimensions if any.

- Use Set Analysis, if any If is there

- Aggr will take more time to evaluate, if you are using Aggr(), try to remove it

- If you are displaying huge data in Pivot, restrict the chart to load only if certain filters are selected.

- Check your Data model, try to make it as Start Schema.

Hope this helps you.

Regards,

Jagan.

[Anonymous]

I have like 50 dimensions Im showing in a straight table. how would I go about reducing calc time for this table?

[jagan]

Hi Stefan,

Don't display all the records at a times, force user to do some selections in field by using Calculation Condition option in Properties tab using GetSelectedCount()

Example: GetSelectedCount(Year) > 0

Now if user selects year in Year field then only the chart loads.

Regards,

Jagan.