Hi,
I use a TI process to re-create a few default views after rollover. I was surprised to find out that I forgot to turn on Auto Recalc. and couldn't find a way to do it in TI.
Is there any way to accomplish this without manually opening and saving each view?
Thanks!
Kenneth
Cube View Created by TI with Automatic Recalculation On
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: Cube View Created by TI with Automatic Recalculation On
Hi,
I don’t think you can set this in a TI or the API, which is a bit of an oversight (unless I missed something).
If you look in the actual .vue file then you should see the line 376,0.
This, I think, indicates that the auto reclac is off. To switch it on change to 376,1.
So maybe some sort of powershell script to replace 376,0 with 376,1 in the Default views?
Or if there are not too many views then do it manually!
regards,
Mark
I don’t think you can set this in a TI or the API, which is a bit of an oversight (unless I missed something).
If you look in the actual .vue file then you should see the line 376,0.
This, I think, indicates that the auto reclac is off. To switch it on change to 376,1.
So maybe some sort of powershell script to replace 376,0 with 376,1 in the Default views?
Or if there are not too many views then do it manually!
regards,
Mark
-
- Regular Participant
- Posts: 194
- Joined: Thu May 30, 2013 1:41 pm
- OLAP Product: Cognos
- Version: Planning Analytics 2.0.7
- Excel Version: 2010
Re: Cube View Created by TI with Automatic Recalculation On
Thanks Mark. It's disappointing but I guess I will live with it.
Ken
Ken