Search found 552 matches

by macsir
Wed Nov 14, 2018 8:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1ELLIST with MDX
Replies: 5
Views: 269

Re: TM1ELLIST with MDX

Can you use single quotes to represent string in MDX inside double quotes?
by macsir
Thu Oct 25, 2018 9:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 426

Re: ViewZeroOut with Hierarchies in PA2.0

I think MDX view is just not mature yet at this stage.
by macsir
Thu Oct 25, 2018 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 5
Views: 249

Re: TM1 REST API

glad it works
by macsir
Wed Oct 24, 2018 9:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 5
Views: 249

Re: TM1 REST API

1. Try to add -ContentType 'application/json' into your Invoke-RestMethod command 2. Your output is basically right but because the returned json response might be too big for Invoke-RestMethod to deserialize. You need to change to JavaScriptSerializer instead 3. For https to work, you need to refer...
by macsir
Thu Oct 18, 2018 9:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing user when using CAM security
Replies: 4
Views: 254

Re: Removing user when using CAM security

There are 3 layers here. 1. Active Directory 2. Cognos CAM security 3. TM1 Native client group From what I have experienced, if any user is deleted or disabled in AD,then it will be shown "unavailable" in CAM if the user is previously setup. If a user is added into AD, I have to manually add it into...
by macsir
Wed Oct 17, 2018 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 100% Stacked Bar Chart based on Active Form?
Replies: 3
Views: 166

Re: 100% Stacked Bar Chart based on Active Form?

Hi, has anyone implemented this chart before? The problem I have is the multiple data series for the chart has to be manually fixed in advance. It can't be dynamically based on the rows or columns from the active form. Named range doesn't work. VBA doesn't work in TM1 web. Could anyone share any id...
by macsir
Tue Oct 16, 2018 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 100% Stacked Bar Chart based on Active Form?
Replies: 3
Views: 166

Re: 100% Stacked Bar Chart based on Active Form?

Alright, it ends with fixed number of data series, say top 10 or top 15. It can't be dynamic, otherwise it has to be in VBA.
by macsir
Fri Oct 12, 2018 11:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 100% Stacked Bar Chart based on Active Form?
Replies: 3
Views: 166

100% Stacked Bar Chart based on Active Form?

Hi, has anyone implemented this chart before? The problem I have is the multiple data series for the chart has to be manually fixed in advance. It can't be dynamically based on the rows or columns from the active form. Named range doesn't work. VBA doesn't work in TM1 web. Could anyone share any idea?
by macsir
Sun Oct 07, 2018 9:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP4 on Windows 10 - Subset editor items disappear when using multi-selection
Replies: 8
Views: 211

Re: TM1 10.2.2 FP4 on Windows 10 - Subset editor items disappear when using multi-selection

Thanks for the confirmation, guys.
Just got support reply saying it was also an issue with PA Client tools until PA 2.0.2.
Does anyone have any chance to test this bug in the versions after PA 2.0.2?
by macsir
Fri Oct 05, 2018 4:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP4 on Windows 10 - Subset editor items disappear when using multi-selection
Replies: 8
Views: 211

Re: TM1 10.2.2 FP4 on Windows 10 - Subset editor items disappear when using multi-selection

I have experienced this as well, but I have no clue on what causes and resolves this. So I would like to know the answer too ;-) Thanks, Wim. Most of us are on Windows 7. It is just some users have been upgraded into Windows 10. I am wondering if PA has this issue too. I don't have chance to test i...
by macsir
Fri Oct 05, 2018 3:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP4 on Windows 10 - Subset editor items disappear when using multi-selection
Replies: 8
Views: 211

TM1 10.2.2 FP4 on Windows 10 - Subset editor items disappear when using multi-selection

Hi,
Element name goes to blank when using shift or control key for multi-selection in subset editor in Perspectives.
But actually the items selected are still valid and there. The names of elements are just showing empty. Any idea?
download (2).png
download (2).png (31.05 KiB) Viewed 211 times
by macsir
Wed Oct 03, 2018 9:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: When is a "hierarchy" not a hierarchy
Replies: 10
Views: 394

Re: When is a "hierarchy" not a hierarchy

I agree. It just takes time to get used to it. Wherever we were used to saying dimension simply replace with “hierarchy“. Hierarchies contain rollups. In fact hierarchies are now the containers for elements, rollups, subsets and attributes (not dimensions, that was back then, we need to get to the n...
by macsir
Tue Oct 02, 2018 8:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset not found in dimension
Replies: 4
Views: 155

Re: Subset not found in dimension

Thanks, lotsaram for the detailed explanation. I am surprised that viewcreate is still not hierarchy aware at the moment since IBM implemented the hierarchy as a important feature. But anyway, as you said, ViewCreateByMDX still gives us lots of flexibility. I am interested to test this bit also.
by macsir
Tue Oct 02, 2018 5:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset not found in dimension
Replies: 4
Views: 155

Subset not found in dimension

Hi, all I am testing TI codes in PAW and running into "Subset not found in dimension" issue when executing at VIEWSUBSETASSIGN function. Could anyone spot it for me? The view and subset have been created via this code successfully. It looks like TI can't bind the subset under the hierarchy into the ...
by macsir
Thu Sep 27, 2018 1:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: F9 in Browser to refresh TM1 web report
Replies: 1
Views: 594

F9 in Browser to refresh TM1 web report

Hi, all Just want to share a tip for timed refreshing TM1 web report automatically. In PA web, you can press F9 to refresh automatically in a Browser. (Not supported in 10.2.2 FP4 as I tested and haven't tested in other FP.) Because of this, you can use any programming language to simulate F9 key pr...
by macsir
Wed Sep 26, 2018 10:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to delete a view via right click in PAW?
Replies: 5
Views: 444

Re: How to delete a view via right click in PAW?

dr.nybble wrote:
Wed Sep 26, 2018 12:56 pm
If you don't want to use the toolbar -- with the view selected press the "Delete" key.
It doesn't work for "Delete" key. It is just inconvenient for administrators.
by macsir
Wed Sep 26, 2018 5:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to delete a view via right click in PAW?
Replies: 5
Views: 444

How to delete a view via right click in PAW?

Looks like it is impossible. We are on PA 2.0.5.
by macsir
Thu Sep 20, 2018 9:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Java TM1 API : need help
Replies: 7
Views: 543

Re: Java TM1 API : need help

As I said before, rest api is the future. It can execute MDX as well and do more. Forget about all these old api.
by macsir
Sun Sep 16, 2018 9:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Question of the day
Replies: 9
Views: 487

Re: TM1 Question of the day

thanks, good to know.