Charts Non-Recalc

Post Reply
User avatar
rafaewolie
Posts: 22
Joined: Wed May 11, 2016 2:16 pm
OLAP Product: IBM Cognos TM1
Version: TM1 PA 2.0
Excel Version: Excel 2013
Location: Anywhere, BR
Contact:

Charts Non-Recalc

Post by rafaewolie » Mon Sep 04, 2017 9:08 pm

Hi,

I'm putting some charts at the top of some perspectives that are been published at TM1WEB and Contributor.

The issue is, at first time I open the application, the charts does not appear at all, I need to Recalc to show them.

Someone knows Why it happens and How Do I Solve this?

My Web Config xml is:

<add value="false" key="UseBookRecalcSetting"/>
<add value="true" key="RecalcOnActivate"/>
<add value="True" key="RecalcOnDataValidationChange"/>
<add value="True" key="RecalcOnPicklistChange"/>

Thanks.

st2000
Posts: 57
Joined: Mon Aug 15, 2016 8:48 am
OLAP Product: TM1 (Windows) & SSAS 2014 Ent.
Version: 10.2.0 FP3
Excel Version: Excel 2013
Location: Hamburg, DE, EU
Contact:

Re: Charts Non-Recalc

Post by st2000 » Mon Sep 11, 2017 7:49 am

Your calculation option in Excel is on automatic?
Could be done by this setting via code: https://msdn.microsoft.com/VBA/Excel-VB ... erty-excel
or in the ribbon Formula/watch out for the calculator-symbol, here in german, but might look similar in english:
EXCEL_2017-09-11_09-46-52.png
EXCEL_2017-09-11_09-46-52.png (7.25 KiB) Viewed 129 times
-----------------------------------
Best regards,
Stefan

User avatar
rafaewolie
Posts: 22
Joined: Wed May 11, 2016 2:16 pm
OLAP Product: IBM Cognos TM1
Version: TM1 PA 2.0
Excel Version: Excel 2013
Location: Anywhere, BR
Contact:

Re: Charts Non-Recalc

Post by rafaewolie » Mon Sep 11, 2017 1:44 pm

Hi st2000,

I already Changed the Calc Options to Automatic before publishing.

But Even When I turn to Automatic, Tm1 seems to change again to manual When published.

Thanks for Your Help

Post Reply