Search found 785 matches
- Tue Jul 20, 2021 8:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CCC scheduled tasks failing on Cloud
- Replies: 4
- Views: 5094
Re: CCC scheduled tasks failing on Cloud
Just out of curiosity, how good is IBM cloud on average? (I mean PA on cloud) Seems like no one has discussed about it here.
- Tue Jul 13, 2021 9:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to calculate up to Millisecond
- Replies: 18
- Views: 68758
Re: How to calculate up to Millisecond
Yes, I agree with declanr. DimensionTimeLastUpdated and HIERARCHYTIMELASTUPDATED need to be converted from GMT time to local time.
Code: Select all
#If converted to local time, need to add 10 / 24 for hour difference
vDateTimeWithMillisec = NUMBERTOSTRING((DimensionTimeLastUpdated(DimName)) + 10/24);
- Mon Jul 05, 2021 12:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Monitor was on by itself
- Replies: 2
- Views: 3223
Re: Performance Monitor was on by itself
I’m on 2.0.9.6 and have seen the same. It seems when I turn on Performance Monitor in Architect, it persists through a restart by changing that setting to T. Yes, exactly. And it worked once when I put PerformanceMonitorOn=F explicitly in the config file. But later, somehow it was changed to Perfor...
- Sun Jul 04, 2021 8:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Monitor was on by itself
- Replies: 2
- Views: 3223
Performance Monitor was on by itself
PAL 2.0.9.4
Somehow, the configuration was turned on by itself even if I didn't do that??? I turned it off and rebooted deliberately and after a period of time, it was on again?
Somehow, the configuration
Code: Select all
PerformanceMonitorOn=T
- Thu May 20, 2021 8:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics Performance Modeler license as ReadOnlyUser
- Replies: 7
- Views: 4627
Re: Planning Analytics Performance Modeler license as ReadOnlyUser
Yes, agreed. Thanks.
- Wed May 19, 2021 8:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with CreateHierarchyByAttribute
- Replies: 6
- Views: 6137
Re: Problem with CreateHierarchyByAttribute
Just curious, what PAW and PAL version do you use?
- Wed May 19, 2021 8:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics Performance Modeler license as ReadOnlyUser
- Replies: 7
- Views: 4627
Re: Planning Analytics Performance Modeler license as ReadOnlyUser
A standard performance management user is your bog standard read/write contributor/planner. As far as IBM are concerned if you pay for someone to have write privileges but only grant them read access - that is fine as it’s lower access. You could buy an explore/read only licence that’s cheaper so I...
- Tue May 18, 2021 8:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics Performance Modeler license as ReadOnlyUser
- Replies: 7
- Views: 4627
Re: Planning Analytics Performance Modeler license as ReadOnlyUser
If it is a Modeler license, it should a TM1 admin. Admin can't be readonly, I think.
- Wed Apr 28, 2021 8:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Private views question
- Replies: 16
- Views: 13541
Re: Private views question
I can't speak for others but I always had to unload the cube in order to see it. Unless I do that I don't see it. Hi, thanks for that. I can confirm unloading the cube did the trick in PAL 2.0.9.4 using CAM without rebooting the server. The private views don't have private subsets at all. I just co...
- Wed Apr 28, 2021 3:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Private views question
- Replies: 16
- Views: 13541
Re: Private views question
I can't speak for others but I always had to unload the cube in order to see it. Unless I do that I don't see it. Hi, thanks for that. I can confirm unloading the cube did the trick in PAL 2.0.9.4 using CAM without rebooting the server. The private views don't have private subsets at all. I just co...
- Thu Apr 22, 2021 8:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube last data pull
- Replies: 14
- Views: 7810
Re: Cube last data pull
I would expect IBM provide value for getting last access timestamp for a cube via REST API in the future.
- Thu Apr 08, 2021 8:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Register process via RestAPI
- Replies: 14
- Views: 7725
Re: Register process via RestAPI
I would suggest you to setup a new instance where you put all your process files. And In powershell, use Invoke-RestMethod to call the process endpoint to copy all processes over from the new instance. The syntax should be the same as what's been used in TM1py.
- Mon Mar 22, 2021 8:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAfE: Refreshing Behaviour Issue
- Replies: 4
- Views: 3539
Re: PAfE: Refreshing Behaviour Issue
Try to disable to all unnecessary Excel addins and see?
- Thu Mar 18, 2021 9:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA 2.07 - }ClientProperties cube
- Replies: 17
- Views: 8119
Re: PA 2.07 - }ClientProperties cube
Thanks, good to know.
- Thu Feb 04, 2021 8:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API - Pull data for data warehouse
- Replies: 5
- Views: 3182
Re: REST API - Pull data for data warehouse
Have a read about one of the IBM official manuals. You definitely can implement this by any programming languages.
https://www.ibm.com/support/knowledgece ... t_api.html
https://www.ibm.com/support/knowledgece ... t_api.html
- Thu Jan 28, 2021 8:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pax - Commit
- Replies: 5
- Views: 3285
Re: Pax - Commit
Hi, ascheevel
Thank you very much for detailed testing and explanation.
Yes, I figured out later that I didn't point ActiveCell onto a Quick report area in the sheet.
Thank you very much for detailed testing and explanation.
Yes, I figured out later that I didn't point ActiveCell onto a Quick report area in the sheet.
- Thu Jan 28, 2021 2:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pax - Commit
- Replies: 5
- Views: 3285
Re: Pax - Commit
Quick Reports have a type-in refresh option but that is only for automatically refreshing data after a metadata change. I'm not aware of type-in commit as a radial option. In the couple cases I've had where the end user asked for auto-commit after entry, I've used VBA to commit the active quick rep...
- Wed Jan 27, 2021 4:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cell Number Limit for DBSW?
- Replies: 0
- Views: 7000
Cell Number Limit for DBSW?
Hi, I am experiencing an issue and it looks like there is some limit on the number of DBSW formulas when sending data back to a cube. The file originally works fine for writing data back in Perspectives and it takes around 10 minutes to complete. When I put it with PAfE v55, it refreshed but not sen...
- Thu Jan 14, 2021 8:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1.SQLAPI error message in TM1Server log
- Replies: 5
- Views: 30607
Re: TM1.SQLAPI error message in TM1Server log
What is the version of your TM1 server? I have seen some in 2.0.8 but they disappeared after upgrading to 2.0.9.1.
- Mon Dec 21, 2020 11:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBRW not showing values until pressing enter in cells
- Replies: 2
- Views: 1583
Re: DBRW not showing values until pressing enter in cells
I should say there is no sequence of wrong-refreshed sheet with a subset inside it. As long as you have a subset in DBRW references in PAfE, then all sheets are just partially refreshed no matter where the subset is.