Search found 226 matches

by Edward Stuart
Thu May 17, 2018 2:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 1931

Re: PAW - missing dimensions and processes

It looks like you are a consumer/ analyst in PAW, it doesn't matter what rights you have in TM1 User Roles in PAW: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_paw_user_roles.html#concept_phc_bts_rcb If you are a modeler/ administrator th...
by Edward Stuart
Thu May 17, 2018 11:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 1931

Re: PAW - missing dimensions and processes

Do you know what permissions the user has on Planning Analytics workspace?

Consumer, Analyst, Modeler, Administrator?

What type of security are you using? CAM?

Were there any errors on the setup screen post installation?
by Edward Stuart
Thu May 17, 2018 10:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transfer data within cubes for a particular month and future set of months in a year
Replies: 12
Views: 1958

Re: Transfer data within cubes for a particular month and future set of months in a year

Error: Prolog procedure line (148): Dimension: Month created an empty subset - What code is there on line 148 of the Prolog - What do you think "Dimension: Month created an empty subset" means? Have a look at the Source View created (if it is not deleted as part of the process, which is highly like...
by Edward Stuart
Thu May 17, 2018 9:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 1931

Re: PAW - missing dimensions and processes

Have you installed Planning Analytics Workspace Local? (i.e. can you change the settings required) and what user are you logged in as?
by Edward Stuart
Thu Jan 18, 2018 7:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: add part of dimension to a new dimension
Replies: 5
Views: 1297

Re: add part of dimension to a new dimension

Do the values derive from a source file? What are the other parent child relationships in the dimension?
by Edward Stuart
Wed Jan 10, 2018 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: no format within IBM TM1 Applications
Replies: 2
Views: 918

Re: no format within IBM TM1 Applications

Does the same issue occur in alternative browsers? Are you using a supported browser from the software compatibility report? IBM Software Compatibility Report For PA 2.0.3 Local, Internet Explorer 11 is the prerequisite minimum required although you could expect some/ most of the functionality to wo...
by Edward Stuart
Wed Jan 03, 2018 8:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics on Windows better or on Linux?
Replies: 1
Views: 722

Re: Planning Analytics on Windows better or on Linux?

This is well documented and available in the installation and configuration guide.

https://www.ibm.com/support/knowledgece ... rview.html
by Edward Stuart
Wed Dec 20, 2017 12:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 3584

Re: Count in rules

I know you have created another topic regarding the feeders but for completeness I will post here. Source data: PersonResponsible Processor Month CaseID AverageTimeCount ABC C1 Aug 2017 C1234 30days ABC C2 Aug 2017 C1235 56 days ABC C3 Aug 2017 C3456 0 ABC C4 Aug 2017 C4567 24 days ABC C2 Aug 2017 C...
by Edward Stuart
Sun Dec 17, 2017 10:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 3584

Re: Count in rules

Developerworks TM1 Feeders When I'm having issues with Feeders I tend to set all elements to the N level and pick a single dimension to contain a consolidation. Verify that this works and then scale the feeders up. However, as gtonkin says you need to feed from the correct element. A rough rule is ...
by Edward Stuart
Fri Dec 15, 2017 6:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 3584

Re: Count in rules

If you remove SKIPCHECK the values should resolve as expected. You will need to resolve the feeders and I would suggest reading up on the Feeders documentation on Developerworks to get a better understanding Values not consolidating need to be fed from the source values. Typically this means reversi...
by Edward Stuart
Thu Dec 14, 2017 8:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 3584

Re: Count in rules

The official IBM training has a similar challenge and uses a Hold element and a Count element. Create an additional element alongside AverageTimeCount with a rule [`NewCount`]=N: IF ( [`AverageTimeCount`] > 0 ) , 1, 0 ) ; This will give the appropriate consolidated count to be used as a divisor. Thi...
by Edward Stuart
Wed Dec 13, 2017 9:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
Replies: 6
Views: 1462

Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working

Are you opening Planning Analytics for Excel (from the Stat menu) or are you opening Excel?

Have you configured Excel to load the Planning Analytics for Excel add-in on startup?
by Edward Stuart
Fri Dec 08, 2017 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "ObjectDuplicate" in Ops console and cube error in TM1 apps web
Replies: 2
Views: 647

Re: "ObjectDuplicate" in Ops console and cube error in TM1 apps web

Couple of posts in the forum around ObjectDuplicate, seems that adding a parameter to your tm1s.cfg file should help

Script to kill TM1TOP Process

What do your log files say?
What action precedes the issue?
Can you replicate the issue?
by Edward Stuart
Fri Dec 08, 2017 7:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Replies: 10
Views: 2282

Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!

Did the changes made to the dropdowns affect the cell(s) the action button references when it runs? If you adjust the location of the parameters the action button does not automatically update to reflect these changes. If you run the TI process independently does it work as expected? What changes di...
by Edward Stuart
Sat Nov 25, 2017 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos TM1 Active Directory
Replies: 1
Views: 714

Re: Cognos TM1 Active Directory

Are you looking to hook directly into active directory or to utilise LDAP? There are many guides online for setting up security in TM1 and this is a useful starting point: http://www-01.ibm.com/support/docview.wss?uid=swg21456988 Looking at your existing configuration is your AD/ LDAP server called ...
by Edward Stuart
Mon Oct 16, 2017 5:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Date Display Using Attribute Format
Replies: 7
Views: 2367

Re: TM1 Date Display Using Attribute Format

A good starting point is this comprehensive post on Dates and Times in the Useful Code section of the forum:

Working with Dates and Times
by Edward Stuart
Sat Sep 30, 2017 7:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form Drill down help
Replies: 9
Views: 2108

Re: Active Form Drill down help

My interpretation was that users have access to all levels of dimension through perspectives but the requirement was to restrict access in active forms. If it is across the model then element security as per Tomok's suggestion would work. However I'm still not convinced this isn't a question relatin...
by Edward Stuart
Sat Sep 30, 2017 6:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form Drill down help
Replies: 9
Views: 2108

Re: Active Form Drill down help

AFAIK it is only possible to restrict dimension security between TM1 front ends via contributor applications I would question why? (Performance? Usability? Asthetic?) But it could be achieved by generating a replica dimension to the required level. This obviously brings a level of additional mainten...
by Edward Stuart
Wed Sep 20, 2017 6:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Feed this Rule ??? pls help!!!
Replies: 3
Views: 827

Re: How to Feed this Rule ??? pls help!!!

If you haven't already then check the rules guide which contains examples that match your query:

https://www.ibm.com/support/knowledgece ... -gen5.html