Search found 546 matches

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: 1
Views: 59

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: 1
Views: 59

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

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

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

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 144 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: 252

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

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

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

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

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

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

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

Re: TM1 Question of the day

thanks, good to know.
by macsir
Tue Sep 11, 2018 10:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 REST api - filter all subset except one dynamic subset
Replies: 4
Views: 222

Re: Tm1 REST api - filter all subset except one dynamic subset

you could put "not" in front of startswith function or use contains function instead. Looks like $search has not been implemented in TM1 rest api now.
by macsir
Mon Sep 10, 2018 8:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating subsets in Workspace
Replies: 6
Views: 223

Re: Creating subsets in Workspace

Even worse, even if a dimension belongs to a cube, but if you drag the dimension only into the workspace, you still can't open subset editor from there. I guess the purpose of this is to encourage you to utilize hierarchy rather than subset in the future. Am I right? :? I think maybe you are gettin...
by macsir
Mon Sep 10, 2018 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Aggregations in Rows and Columns do not work
Replies: 6
Views: 332

Re: Aggregations in Rows and Columns do not work

Do you have 0 weighting on dimensions?
by macsir
Thu Sep 06, 2018 9:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating subsets in Workspace
Replies: 6
Views: 223

Re: Creating subsets in Workspace

Even worse, even if a dimension belongs to a cube, but if you drag the dimension only into the workspace, you still can't open subset editor from there. I guess the purpose of this is to encourage you to utilize hierarchy rather than subset in the future. Am I right? :?
by macsir
Tue Aug 28, 2018 11:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to change configurations for PAW
Replies: 10
Views: 350

Re: How to change configurations for PAW

dr.nybble wrote:
Tue Aug 28, 2018 12:22 pm
Since the 401 you received was from TM1, not PAW, it appears that the underlying CAM passport timed out. You may need to also adjust that on the CA/BI side.
Thanks for that. I tried to change "Inactivity timeout in seconds" in Cognos configuration. It still didn't work.
by macsir
Mon Aug 27, 2018 9:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to change configurations for PAW
Replies: 10
Views: 350

Re: How to change configurations for PAW

CAM Security with SSO enabled in this version.