Search found 248 matches

by Edward Stuart
Mon May 21, 2018 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting started with REST API (issue)
Replies: 8
Views: 5144

Re: Getting started with REST API (issue)

You will need to set the installation/ configuration details in the manual:

https://www.ibm.com/support/knowledgece ... stall.html

Specifically the httpportnumber
by Edward Stuart
Fri May 18, 2018 4:12 pm
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: 8225

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

Given that your subset is empty it is safe to say something is not working as you expect it too. I would copy out the subset creation code into a temporary process and then start debugging to ascertain exactly what is not working. Either by creating a testing subset or via AsciiOutput. As for findin...
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: 7469

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

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

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 h...
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: 7469

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

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

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

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

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

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

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

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: 9
Views: 7792

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

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

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

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

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

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

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...