Search found 248 matches

by Edward Stuart
Mon Apr 01, 2024 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 98
Views: 22629

Re: Ultimate Long TM1 quiz

1. Denial - it can't have happened I would have set logging/ backups 2. Anger - who has switched off logging on the cube. Why do we budget like this anyway. I really should have put my foot down in the last Budget review meeting 3. Bargaining - I'll email my business partner and blame them. No, I'll...
by Edward Stuart
Wed Dec 06, 2023 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mirantis and PAW
Replies: 2
Views: 9922

Re: Mirantis and PAW

It's a frustration but it's an easy install and works just as it did before it was a product this was licensed.

Pay/ Download the evaluation powershell install script, run it and you should be able to install PAW as usual
by Edward Stuart
Wed Nov 22, 2023 4:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API Dimension Clone
Replies: 16
Views: 19019

Re: REST API Dimension Clone

I've not toyed with Powershell for some time but a historical script I have used looked like this: $headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]" $headers.Add("Authorization", <Authentication Method - TM1/ CAM/ PA On Cloud/ AWS?>) $csvfolder = <M...
by Edward Stuart
Tue Sep 05, 2023 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX which takes Value from Cube
Replies: 12
Views: 7652

Re: MDX which takes Value from Cube

Wim's excellent MDX reference guide: https://www.wimgielis.com/tm1_mdxstatements_EN.htm George's excellent MDX reference guide: https://community.ibm.com/community/user/businessanalytics/blogs/george-tonkin/2022/06/11/tm1-planning-analytics-mdx-reference-guide?CommunityKey=8fde0600-e22b-4178-acf5-bf...
by Edward Stuart
Fri Nov 18, 2022 10:02 am
Forum: Free And Open Source Tools
Topic: PAjs - Planning Analytics with Watson JavaScript REST Client
Replies: 2
Views: 8265

PAjs - Planning Analytics with Watson JavaScript REST Client

PAjs - Planning Analytics with Watson JavaScript REST Client After many years of talking about creating a JavaScript frontend to Planning Analytics with Watson we are finally here! At present we have the following functionality: - Create listing of all AdminHost(s) - Displaying all running Models a...
by Edward Stuart
Thu Aug 19, 2021 3:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest Api and Workspace
Replies: 4
Views: 5034

Re: TM1 Rest Api and Workspace

If you haven't already then it would be worth reading up on Cross-Origin Resource sharing: https://developer.mozilla.org/en-US/docs/Web/HTTP/CORS and Content Security Policy (CSP): https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP To get additional help you will need to provide a fair amount mor...
by Edward Stuart
Wed Aug 11, 2021 12:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Querying the transaction log
Replies: 5
Views: 5412

Re: Querying the transaction log

Data Reservation could help you but I'd be more inclined to change the business process than engineering a whole new methodology for data input. A lot rests on how the users are inputting the data, is it directly into the cubes via Architect/ Perspectives/ PAX? This complicates things as the transac...
by Edward Stuart
Thu Apr 08, 2021 7:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Register process via RestAPI
Replies: 14
Views: 7828

Re: Register process via RestAPI

There are a few ways you 'could' do it quickly but it may be necessary to find out how you can do it first and then find a preferred method.

Are you able to install a REST Api Client like Postman? Do you have access to Powershell? Do you have access to ScriptLab in excel?
by Edward Stuart
Tue Jan 12, 2021 9:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 8031

Re: Monaco TM1 Editor with Intellisense

I'll second that, I've been tinkering with Javascript/ React interaction with the REST Api where time allows and whilst I think there is demand and space for an application like this (and I will also look to contribute). Workspace is a surprisingly comfortable place to develop once you start using i...
by Edward Stuart
Wed Nov 04, 2020 9:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A question on STET rules
Replies: 2
Views: 1693

Re: A question on STET rules

Store A and B explicitly and use an additional element C to check if a value is populated

Much clearer and also removes the ambiguity around data input, is far easier to test when you upgrade versions and you know it will work when you upgrade versions
by Edward Stuart
Fri Oct 30, 2020 11:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process doesn't return a correct value
Replies: 9
Views: 3620

Re: TI Process doesn't return a correct value

Sounds like a lot is happening and without seeing your code it will be very hard to give a helpful response. I would comment out all aspects of the process except for the ViewZeroOut to ensure that is working as expected. Then include an asciioutput to ensure the remainder of your code is aggregatin...
by Edward Stuart
Mon Oct 12, 2020 11:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Https for Tm1 Rest api
Replies: 1
Views: 2089

Re: Https for Tm1 Rest api

You will get warning messages in any browser you are using when accessing an HTTPS link to protect against unauthorized access, something along the lines of: Chrome/ Edge: NET::ERR_CERT_AUTHORITY_INVALID Firefox: Error code: MOZILLA_PKIX_ERROR_SELF_SIGNED_CERT You can bypass these messages by accept...
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: 3209

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

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

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

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: 17
Views: 11361

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: 11
Views: 10907

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: 11
Views: 10907

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: 11
Views: 10907

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