Search found 222 matches

by Edward Stuart
Mon Nov 05, 2018 11:09 am
Forum: Useful code, tips and tricks
Topic: Deactivating chores in Architect takes time
Replies: 9
Views: 314

Re: Deactivating chores in Architect takes time

TM1PY, in my opinion, should be a starting point for anyone looking to get more involved with the REST Api. That said, the challenge you have is re-setting chores according to Daily Saving Time. Handily enough one of the properties of a Chore in the REST Api is "DSTSensitive" Below is Postman output...
by Edward Stuart
Tue Oct 30, 2018 10:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rules - Request your guidance please!
Replies: 4
Views: 212

Re: TM1 Rules - Request your guidance please!

Please i request your help in starting with the change in Rules, i do not know how and where to begin.
What error message(s) are you getting when you open/ save the rules?
by Edward Stuart
Thu Aug 16, 2018 2:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to know last cube updated time in TM1
Replies: 7
Views: 856

Re: How to know last cube updated time in TM1

How is your source cube updated? From ODBC? User Input? You could write out the total value in the cube each 15 minutes to a control cube (for example) and validate the export based on the total value matching every 15 minutes or not sExistingTotal = cellGetN ('myControlCube', 'ValueEvery15Minutes',...
by Edward Stuart
Wed Jul 25, 2018 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Refreshing of planning Analytics Workspace filters.
Replies: 1
Views: 383

Re: Refreshing of planning Analytics Workspace filters.

Can you rephrase the question(s) as it is not very clear what you are asking?

I assume you mean your Planning Analytics Workspace filter(s) are not updating where your Planning Analytics cube(s) filter(s) are updating?
by Edward Stuart
Thu Jul 19, 2018 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Azure VM Type for Planning Analytics
Replies: 10
Views: 602

Re: Best Azure VM Type for Planning Analytics

Your business partner should be able to help with the licensing questions and may also be able to provide infrastructure for testing your models in a cloud environment. The memory requirements should be reasonably clear from the onsite server and you should also be able to monitor this server for pr...
by Edward Stuart
Tue Jul 17, 2018 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset
Replies: 5
Views: 594

Re: Dynamic Subset

What happens when you input the MDX into an expression window and run it manually?
by Edward Stuart
Tue Jul 17, 2018 1:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 1142

Re: PAx - DBRW/DBRS only when requested

When using TM1Top/ Operations Console can you see how much activity is taking place on TM1 when refreshing these sheets? What kind of performance are you experiencing? (5 seconds, 60 seconds?) Frequently I've encountered scenarios where the excel calculations/ network speeds have been the bottleneck...
by Edward Stuart
Tue Jul 17, 2018 10:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos TM1 Performance Modeler 10.2.2.0
Replies: 9
Views: 651

Re: Cognos TM1 Performance Modeler 10.2.2.0

You mention that you downloaded Performance Modeler and then amended the SSL certificates and now it is not working. Have you tried uninstalling Performance Modeler and re-installing from post SSL certificate change? What else have you tried? Your second set of errors, it indicates that it cannot fi...
by Edward Stuart
Fri Jun 22, 2018 8:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA when running TI processes Kick out RDP
Replies: 6
Views: 556

Re: PA when running TI processes Kick out RDP

Is it possible to spin up another server to confirm the issue(s)? sometimes it works perfectly sometimes it happens Are there other programs/ services running on the server that could take resources away from TM1 during processing? Is it possible to shut down/ restrict all other services for the dur...
by Edward Stuart
Tue Jun 12, 2018 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issues with new instance
Replies: 9
Views: 552

Re: Issues with new instance

You can only have one local server running on a machine but local servers are increasingly rarely used. You can, however, run as many instances/ servers/ models on a single virtual/ physical server (providing you have the license to do so) I'm confused as to what you are doing, are you copying last ...
by Edward Stuart
Thu Jun 07, 2018 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tracing cube load after unload
Replies: 6
Views: 427

Re: Tracing cube load after unload

Do these cubes have Feeders? IBM Support Note: DemandLoad property The Load on Demand feature only works if the cube has no feeders. If the cube has feeders, it will be loaded on server start, no matter if its Load on Demand property is set. If the cube has feeders, rules or dependencies, Load on De...
by Edward Stuart
Tue May 22, 2018 12:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting started with REST API (issue)
Replies: 8
Views: 599

Re: Getting started with REST API (issue)

Are the firewall ports open for port number 5895 or 5898? Have you re-started the adminhost and verified the port number settings? What have you input for UseSSL? http://localhost:5895/api/v1/Servers https://localhost:5898/api/v1/Servers What version of TM1 are you using, is it still 10.2.2? Which F...
by Edward Stuart
Mon May 21, 2018 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting started with REST API (issue)
Replies: 8
Views: 599

Re: Getting started with REST API (issue)

Can you give some further indications as to what you have tried, does the link work with localhost when on the server?

Request for assistance guidelines
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: 599

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

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

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

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

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

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?