TM1 Forum

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.

Yes, I agree with declanr. DimensionTimeLastUpdated and HIERARCHYTIMELASTUPDATED need to be converted from GMT time to local time.

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...

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?

Yes, agreed. Thanks.

Just curious, what PAW and PAL version do you use?

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...

If it is a Modeler license, it should a TM1 admin. Admin can't be readonly, I think.

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...

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...

I would expect IBM provide value for getting last access timestamp for a cube via REST API in the future.

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.

Try to disable to all unnecessary Excel addins and see?

Thanks, good to know.

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

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.

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...

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...

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.

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.