Search found 782 matches

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: 8012

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: 2638

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: 2638

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: 1779

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: 1779

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: 1238

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: 1178

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: 1178

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: 3529

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: 963

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: 2096

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: 2198

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: 34342

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: 3843

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: 3843

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: 3843

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...
by macsir
Mon Jul 27, 2020 9:38 pm
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: 3843

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

Yes, I have checked ports and using latest 64-bit Chrome. Now, I can reproduce the issue and almost sure it is still a bug since v49. PH20627 CAN'T LOAD THE VISUALIZATION BECAUSE ITS ASSOCIATED DATA SET ISN'T AVAILABLE https://www.ibm.com/support/pages/ibm-planning-analytics-pa-workspace-and-pa-micr...
by macsir
Mon Jul 27, 2020 8:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax - Commit
Replies: 5
Views: 3232

Re: Pax - Commit

Thanks for sharing.
by macsir
Fri Jul 24, 2020 5:51 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: 3843

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

No, upgrading into 11.1.6 with IF2 still doesn't work. Although it is not popping that error now, the chart is still not showing. It is always blank over VPN. Everything works fine within the company network. I am wondering if the VPN has filtered something for me in the backend.