Auto Recalculate for Cube Viewer

Post Reply
User avatar
macsir
Community Contributor
Posts: 591
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Auto Recalculate for Cube Viewer

Post by macsir » Tue Feb 05, 2019 5:34 am

Hi, all
I am just wondering if there is any hidden or undocumented function to enable Auto Recalculate for a Cube Viewer? So that when a user open a default view with that enabled already.
Similar to other functions, like ViewRowSuppressZeroesSet, ViewRowDimensionSet etc.
The reason is that all our cube views are rebuilt overnight using that group of functions based on definition in a centralized view management cube.
If it has, then it would be nice.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

Wim Gielis
MVP
Posts: 2011
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.6
Excel Version: 2016 - Office 365
Location: Brussels, Belgium
Contact:

Re: Auto Recalculate for Cube Viewer

Post by Wim Gielis » Tue Feb 05, 2019 11:23 am

Hello,

I haven't found it and I would be happy to use it !
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Active form claustrophobia

kangkc
Community Contributor
Posts: 184
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

Re: Auto Recalculate for Cube Viewer

Post by kangkc » Tue Feb 12, 2019 4:41 am

Was bored with the long rule I am writing currently and decided to take a break and investigate this.
If you edit the .vue file directly, the auto-calc flag is at code 376. A value of "1" means auto-recalc.
Problem is public view won't work after you manually edit until a server restart. I presume you can write a external program to modify this flag while server is on schedule down time. Did some testing by changing this between restart and seems to be switching correctly from auto to manual recal.

389,100
390,"By Country auto"
370,0
361,1
362,1
363,0
364,0
365,
366,
367,0
376,1
375,b:0.#########G|0|
374,1
7,actvsbud
270,3
Variance
Actual
Budget

Post Reply