Auto Recalculate for Cube Viewer

Post Reply
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Auto Recalculate for Cube Viewer

Post by macsir »

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: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Auto Recalculate for Cube Viewer

Post by Wim Gielis »

Hello,

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

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
kangkc
Community Contributor
Posts: 206
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1, PA , TMVGate
Version: 2.x
Excel Version: 36x
Location: Singapore
Contact:

Re: Auto Recalculate for Cube Viewer

Post by kangkc »

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: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Auto Recalculate for Cube Viewer

Post by Wim Gielis »

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

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Auto Recalculate for Cube Viewer

Post by macsir »

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
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Auto Recalculate for Cube Viewer

Post by macsir »

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