Auto Recalculate for Cube Viewer

Post Reply
User avatar
macsir
Community Contributor
Posts: 639
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: 2116
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.7
Excel Version: Office 365 - latest
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: Set up a TM1 service with AutoHotKey

kangkc
Community Contributor
Posts: 190
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

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

Re: Auto Recalculate for Cube Viewer

Post by Wim Gielis » Fri Apr 26, 2019 10:18 am

I was looking at a way to do this using the TM1 REST API. With this command:

http://localhost:8001/api/v1/Cubes('JM')/Views('Default')

I find the details of the Default view on the JM cube. I get back:

Code: Select all

{
@odata.context: "../$metadata#Cubes('JM')/Views/ibm.tm1.api.v1.NativeView/$entity",
@odata.etag: "W/"df29494e10347e0a4961c00715af05d5d2d4f1bd"",
Name: "Default",
Attributes: {
Caption: "Default",
test: "Default"
},
Columns: [
{ }
],
Rows: [
{ }
],
Titles: [ ],
[b]SuppressEmptyColumns: true,
SuppressEmptyRows: true,
FormatString: "0.00"
}
The (3) properties at the bottom are the ones that I find back with:

http://localhost:8001/api/v1/$metadata

Does this mean that other properties are not accessible ? I am using PAL 2.0.6

Thanks,

Wim
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: Set up a TM1 service with AutoHotKey

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

Re: Auto Recalculate for Cube Viewer

Post by macsir » Mon Apr 29, 2019 4:02 am

I don't think it is available via rest api at this stage as I checked. Perhaps we can request IBM to add missing feature by voting? :lol:
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

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

Re: Auto Recalculate for Cube Viewer

Post by macsir » Mon Apr 29, 2019 4:03 am

kangkc wrote:
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
Thanks, good finding! At least we can have a workaround to achieve it. :D
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

Post Reply