Search found 785 matches

by macsir
Thu Oct 08, 2020 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How you would explain what is TM1 to your mom ?
Replies: 6
Views: 2688

Re: How you would explain what is TM1 to your mom ?

I build lots of rubik's cubes in a company so that people can play with. That's my job.
by macsir
Thu Oct 01, 2020 8:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 17
Views: 8032

Re: PA 2.07 - }ClientProperties cube

Thanks, I am using CAM. Maybe that's the reason?
by macsir
Wed Sep 30, 2020 8:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 17
Views: 8032

Re: PA 2.07 - }ClientProperties cube

Thanks, Wim.
I tested it as well in Perspectives but not working. Do you need to reboot the server after this change?
What does the TM1 Perspectives say after disabling? How about PAfe and PAW?
by macsir
Tue Sep 29, 2020 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 17
Views: 8032

Re: PA 2.07 - }ClientProperties cube

That is interesting to know. However, this property doesn't seem to work properly at least in 2.0.9.1.
by macsir
Sun Sep 27, 2020 8:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX views, where / how are they evaluated?
Replies: 6
Views: 2648

Re: MDX views, where / how are they evaluated?

Maybe reduce the number of crossjoin and starts from the minimum?
by macsir
Thu Sep 24, 2020 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX views, where / how are they evaluated?
Replies: 6
Views: 2648

Re: MDX views, where / how are they evaluated?

Hi, do you want to share your MDX first and how did you display the MDX view in PAW?
by macsir
Thu Sep 24, 2020 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security on Alternate Hierarchy?
Replies: 2
Views: 1783

Re: Security on Alternate Hierarchy?

PavoGa wrote: Thu Sep 24, 2020 7:52 pm A shot in the dark here, but have you tried applying security to the }Hierarchies_dimname dimension?
Thanks, yes, I have tried and TM1 actually created that security cube for me but still doesn't work. According to IBM's reply, it hasn't been implemented yet but on their roadmap.
by macsir
Sun Sep 20, 2020 11:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security on Alternate Hierarchy?
Replies: 2
Views: 1783

Security on Alternate Hierarchy?

I can see the alternate hierarchy is in }DimensionSecurity cube. I thought I can put some securities on them but apparently it doesn't work in PAW. Users with NONE access can still see and use the hierarchies normally. As long as the user has READ access on dimension, then he can use alternate hiera...
by macsir
Thu Sep 17, 2020 8:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW export and send by mail automatically
Replies: 2
Views: 1243

Re: PAW export and send by mail automatically

I remember PAW cloud version has email sharing function but don't do it automatically.
by macsir
Wed Sep 09, 2020 1:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Design Mode
Replies: 2
Views: 1183

Re: Design Mode

Thanks, Steve. After several testing, I just realized this function doesn't work with just only one cell's copying and pasting. If more than one cells, it works as expected. :)
by macsir
Tue Sep 08, 2020 4:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Design Mode
Replies: 2
Views: 1183

Design Mode

Hi, I am trying to test the design mode in Custom Report or Dynamic Report. But neither of them work as to the descriptions from the document. Whenever I copy and past any static value into cells with DBRW formulas inside it already in the reports, it always replace it with those static values. It d...
by macsir
Thu Sep 03, 2020 9:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW License
Replies: 8
Views: 3536

Re: PAW License

An admin license is still required if you want to modify objects or other admin tasks through PAW.
by macsir
Wed Sep 02, 2020 9:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UNDEFVALs in PAX vs Websheets
Replies: 1
Views: 965

Re: UNDEFVALs in PAX vs Websheets

PAL 2.0.9.1 has no issue. I use same example you did and the web didn't show 0 for null values and it is just blanks. 0 is shown as 0 anyway. BTW, we enabled the new cell formatting although I don't think it is relevant. https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cogn...
by macsir
Mon Aug 24, 2020 10:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Login - Perspectives or PAx or PAW or Contributor
Replies: 3
Views: 2099

Re: User Login - Perspectives or PAx or PAW or Contributor

Not really, all you have is tm1login.log file which captures all logins from all client software.
The only thing I did is dig up the log file from PAW to know the client is on that platform.
by macsir
Wed Aug 19, 2020 8:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Time Series Line Chart with Separate Year and Month Dimensions
Replies: 5
Views: 2202

Re: PAW Time Series Line Chart with Separate Year and Month Dimensions

Hi, I don't think you do it simply in PAW.
1. Possible to create another cube with just one time dimension and use it in PAW?
2. Export data into PowerBI via tm1py and present from there?
by macsir
Thu Aug 06, 2020 8:33 pm
Forum: Free And Open Source Tools
Topic: TM1py 1.5.0
Replies: 4
Views: 34363

Re: TM1py 1.5.0

Thank you, Marius.
by macsir
Tue Jul 28, 2020 8:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: We can’t load the visualization, because the associated data set isn’t available?
Replies: 10
Views: 3854

Re: We can’t load the visualization, because the associated data set isn’t available?

I don't want to waste more time on this. IBM doesn't pay me to fix bugs. I am rolling back to v46.
by macsir
Tue Jul 28, 2020 8:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: We can’t load the visualization, because the associated data set isn’t available?
Replies: 10
Views: 3854

Re: We can’t load the visualization, because the associated data set isn’t available?

What happens if you use Internet Explorer 11 over the VPN ? And is the version of Chrome you are using the supported one for PAW and for your VPN ? IE couldn't show any graph either but not showing this error, just blanks. Version 84.0.4147.105 (Official Build) (64-bit) should be the latest one. Fi...
by macsir
Tue Jul 28, 2020 12:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: We can’t load the visualization, because the associated data set isn’t available?
Replies: 10
Views: 3854

Re: We can’t load the visualization, because the associated data set isn’t available?

It is still the same in v54. So, as long as I clear all the cache from the Chrome and reconnect PAW to refresh all reports. All graphs in the reports won't be shown. It shows either this error or blank at all. But if I kept reloading book or refreshing Chrome for a couple of times. Then all graphs s...