Search found 236 matches

by Edward Stuart
Thu Jul 30, 2020 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turbo Integrator - Decativate Feeder evaluation while process runs
Replies: 5
Views: 196

Re: Turbo Integrator - Decativate Feeder evaluation while process runs

If you simply want to remove the rule then you can use CubeRuleDestroy(CubeName) instead of loading an empty rule file
by Edward Stuart
Wed Jul 29, 2020 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Separate measure dimension for each cube VS one singular measure dimension for all cubes
Replies: 7
Views: 223

Re: Separate measure dimension for each cube VS one singular measure dimension for all cubes

Every cube in your model is unnecessarily sparse and places greater risks on your Rules/ Feeders needing to be on point. I'd take the one off hit of setting the formatting on an element every day over the cleanup/ maintenance requirement of a general measures dimension. My guess is this measures dim...
by Edward Stuart
Wed Jul 08, 2020 11:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adobe Flash Player phase out issue
Replies: 3
Views: 156

Re: Adobe Flash Player phase out issue

If you are using Adobe Flash to consume your models (via ActionScript calls to any of the APIs) then probably, but you won't find anything on the IBM website to tell you as much and you'll need to talk to your systems administrator/ IBM Partner. If you don't then you 'may' be checking compatibility ...
by Edward Stuart
Thu Dec 12, 2019 9:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API CAM Authentication - PA (Cloud)
Replies: 8
Views: 1058

Re: REST API CAM Authentication - PA (Cloud)

Another good resource is Mastering the TM1 REST API with Postman by Cubewise

If you are utilising Postman then I'd recomend The TM1 Rest API collection for Postman as a solid starting point
by Edward Stuart
Fri Dec 06, 2019 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: More info on TM1Project.json file
Replies: 12
Views: 1776

Re: More info on TM1Project.json file

Excellent work Mike, I'm looking forward to testing this further.

For those also looking into this Yury has posted (yet) another great blog on Git Integration

https://ykud.com/blog/cognos/tm1-cognos ... tm1-part-1
by Edward Stuart
Tue Nov 12, 2019 11:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API - GitInit
Replies: 10
Views: 1442

Re: TM1 REST API - GitInit

Seems I'd been working on 2.0.4 as well, for anyone following this thread you will need Planning Analytics 2.0.7 installed, further details can be found on the New Features listing for 2.0.7 here: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_nfg.2.0.0.doc/pa_...
by Edward Stuart
Mon Nov 11, 2019 9:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API - GitInit
Replies: 10
Views: 1442

Re: TM1 REST API - GitInit

Quick update,

I was also successful in using a local repository

Will try and get some time this week to investigate further
by Edward Stuart
Fri Nov 08, 2019 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API - GitInit
Replies: 10
Views: 1442

Re: TM1 REST API - GitInit

I've followed the same details and have a slightly different error: { "error": { "code": "289", "message": "TM1 Git failed to connect to remote. Reason: TM1 Git network connection failed." } } This returns a 400 Bad Request Error I changed the Post URL to use a lowercase i on Init: https://localhost...
by Edward Stuart
Fri Nov 08, 2019 11:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API - GitInit
Replies: 10
Views: 1442

Re: TM1 REST API - GitInit

Hi Luiz, I'm interested in testing this as well and will find some time to have a go as well. Assume you are following the manual details: https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rest_api.2.0.0.doc/tm1_md/tm1-source-specification.html#git-integration As I u...
by Edward Stuart
Fri Jul 26, 2019 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pull data from 3rd party app in Tm1 Model
Replies: 3
Views: 822

Re: Pull data from 3rd party app in Tm1 Model

You can absolutely pull data from source systems and load into TM1/ Planning analytics models via the Rest API. For me, loading in the traditional manner from within TM1 will be by far and away quicker than utilising the API. It is, however, potentially very useful and could present some real opport...
by Edward Stuart
Wed Jun 26, 2019 8:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Cloud backup to local drive
Replies: 2
Views: 680

Re: IBM Cloud backup to local drive

As part of IBM Cloud you have access to Cognos Command Centre which can be used to automatically schedule FTPS file transfer from IBM Cloud to Local Filestore.

A lot depends on what you really want to 'do'; synchronise, backup, disaster recovery etc..
by Edward Stuart
Mon Jun 10, 2019 12:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow Login in Architect
Replies: 21
Views: 3472

Re: Slow Login in Architect

Once you are logged in are there further issues or is it only login that sees the delays?

Do you have access to Cognos BI Security to see if anything odd is occuring at that end? My guess would be that the 'normal' identifiers for TM1 are clear so it could be a BI related issue?
by Edward Stuart
Fri Jun 07, 2019 1:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow Login in Architect
Replies: 21
Views: 3472

Re: Slow Login in Architect

Which IntegratedSecurityMode are you using and are you using single sign on etc..?
by Edward Stuart
Tue Jan 15, 2019 10:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 8140

Re: TM1 REST API

Have you tried using the REST API with VBA? Could be a fit for your lightweight tools and use a language you are more familiar with? This was from some testing I ran a while ago inspired by some posts on the IBM Cognos SDK Forum, Private Sub GetServers() Dim myurl As String Dim reply As String myurl...
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: 14464

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

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

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

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

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

Re: Dynamic Subset

What happens when you input the MDX into an expression window and run it manually?