Search found 246 matches

by Mike Cowie
Wed Feb 16, 2022 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW with alternative hierarchies
Replies: 18
Views: 20386

Re: DBRW with alternative hierarchies

I've only seen DBR's with nested parentheses once "in the wild" and I remember wondering: what is this madness? I expect it's very, very uncommon out there.
by Mike Cowie
Mon Feb 14, 2022 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW with alternative hierarchies
Replies: 18
Views: 20386

Re: DBRW with alternative hierarchies

Hi Wim, This had been bugging me, too, and I now think I understand what these are meant do do after some help from Matt Hopkins @ QueBIT tracking down someone at IBM to get further clarification. The short answer is that these are functions designed to help clean up existing TM1 Perspectives Excel ...
by Mike Cowie
Tue Jan 25, 2022 4:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Subset and Alias
Replies: 2
Views: 12336

Re: REST API: Subset and Alias

Hi Dimix, The Alias isn't an official, documented property of a subset in the REST API, but it's accessible if you explicitly ask for the "Alias" property like so (threw in a quick element count example as well for you): .../api/v1/Dimensions('plan_business_unit')/Hierarchies('plan_busines...
by Mike Cowie
Mon Jul 26, 2021 9:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Integration With Google Sheets
Replies: 7
Views: 9136

Re: Planning Analytics Integration With Google Sheets

If you already have TM1 Excel reports that you've created with Perspectives or Planning Analytics for Excel (PAfE) and you'd like to generate/convert to nicely-formatted versions of the same in Google Sheets then have a look over at the "Commercial & Events" subforum for a recent post ...
by Mike Cowie
Mon Jul 26, 2021 8:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Jmeter setup
Replies: 8
Views: 8153

Re: Jmeter setup

I don't think I have a copy or alternate link to the old Jar files anymore, but I'd bet IBM isn't actively developing or supporting that JMeter plugin anymore and that's why it's disappeared. Depending on what you're hoping to monitor you would be better off looking instead at leveraging the TM1 RES...
by Mike Cowie
Mon Jul 26, 2021 7:33 pm
Forum: Commercial and Events
Topic: ReportWORQ: Enterprise TM1/Planning Analytics Excel Report Distribution
Replies: 0
Views: 81118

ReportWORQ: Enterprise TM1/Planning Analytics Excel Report Distribution

How often do you have to work late to distribute Excel reports from TM1? Do you worry about making mistakes? Have you built rich Excel-based reports and dashboards using TM1 Perspectives or Planning Analytics for Excel (PAfE), but struggle to get that reporting data refreshed and distributed in the ...
by Mike Cowie
Tue Jun 01, 2021 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API - close the active session
Replies: 4
Views: 2669

Re: TM1 REST API - close the active session

Hi Wim,

When you say it stops, what do you mean?

If it's hitting your error check code note that the expected success status codes are different (not 201/Created) for logout call options:
  • api/v1/ActiveSession/tm1.Close: 204/No Content
  • api/logout: 200/OK
Regards,
Mike
by Mike Cowie
Thu May 13, 2021 4:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Escaping } in REST API query
Replies: 3
Views: 3004

Re: Escaping } in REST API query

Hi Dan, You are not missing anything if you're talking about accessing element attribute values in general. However, if all you're hoping to do is to get the display name of the user there is a FriendlyName property of a User that takes care of retrieving this value for you. As for why you can't add...
by Mike Cowie
Tue Jul 14, 2020 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Stack Frame for Function Returns
Replies: 2
Views: 1758

Re: TM1 Stack Frame for Function Returns

Wow, bravo for seeing this through and thanks for sharing! I did something similar once in a small stack data structure (in temp cube + dimensions, of course) to help recurse through a hierarchy regardless of the numbers of levels of depth. While I was proud it worked without a lot of TI script code...
by Mike Cowie
Fri Jun 19, 2020 4:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.9 Upgrade Concerns
Replies: 3
Views: 2038

Re: PA 2.0.9 Upgrade Concerns

As lotsa says, this otherwise seems to be a really good release with a lot of fixes and the added benefit of being designated a long-term support release, meaning IBM will continue to fix bugs and support the 2.0.9.x release for a total of 3 years . The MDX / Element Security change is a pretty majo...
by Mike Cowie
Thu Dec 12, 2019 8:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API CAM Authentication - PA (Cloud)
Replies: 8
Views: 4815

Re: REST API CAM Authentication - PA (Cloud)

Is there any way to encrypt password in REST API CAM authentication rather than Base64 encoding? To encrypt those credentials just make sure you're sending requests to the REST API over HTTPS and NOT HTTP . That is the basic difference between encrypting or not. Setting UseSSL=T in TM1S.CFG will fo...
by Mike Cowie
Thu Dec 05, 2019 11:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: More info on TM1Project.json file
Replies: 17
Views: 7666

Re: More info on TM1Project.json file

Hello: The only way to work with the project file that I'm aware of is via the REST API-- I don't believe it can be managed directly with a file in the data directory structure. To create/update that project file create json which defines your tm1project spec, for instance: { "Version": &q...
by Mike Cowie
Mon Jun 17, 2019 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API - tm1.Execute return 278 error
Replies: 2
Views: 3154

Re: TM1 Rest API - tm1.Execute return 278 error

Hi danz: I know many TM1 error messages aren't that helpful, but in this case it is telling you exactly what you need to do. You need to add a Header in Postman for Content-Type and specify the value it's asking for: content-type-example.jpg This header is part of the request that makes its way to T...
by Mike Cowie
Sun Jan 13, 2019 10:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 18150

Re: TM1 REST API

Hi Wim:

Add this to your Accept header to tell TM1 not to return the OData metadata etags:
odata.metadata=none

Hope that helps cut down on some of the noise for you!

Best,
Mike
by Mike Cowie
Mon Nov 05, 2018 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TIEXECUTE
Replies: 2
Views: 2902

Re: TIEXECUTE

Hello: I think you're referring to the TIExecute command-line utility that I shared many, many years ago on this forum. That tool isn't being updated or supported at this point because IBM have since released their own, supported TM1RunTI command-line application that covers the same functionality a...
by Mike Cowie
Mon Aug 06, 2018 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 43
Views: 40092

Re: Planning Analytics using twice the memory of 10.1

Big thanks to Lotsa, Paul and others for this-- has been a really interesting thread. If anyone needs a pre-REST API method of counting MUNs, just create an MDX subset like this and count/SUBSIZ the elements in that dynamic subset: GENERATE( TM1SUBSETALL( [Your Dimension Name] ), DESCENDANTS( [Your ...
by Mike Cowie
Tue Nov 01, 2016 5:31 pm
Forum: General
Topic: World of Watson 2016
Replies: 4
Views: 22056

Re: World of Watson 2016

Jim:

Sorry I missed you among the 20K or so people! I saw Mr. Waters a few times, but that was about the only familiar non-IBM'er face I saw.

-Mike
by Mike Cowie
Tue Oct 20, 2015 12:09 pm
Forum: General
Topic: Insight 2015
Replies: 2
Views: 14488

Re: Insight 2015

Hi Jim:

I didn't realize you had to be at the booth both days - that's rough! If you need rescuing or especially refreshments (we'll have cotton candy at the QueBIT booth) let me know. I'll be happy to "buy" you a beer during one of the expo receptions.

Regards,
Mike
by Mike Cowie
Fri Aug 29, 2014 4:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 SDK JavaExtensions ( Any early adopters )
Replies: 9
Views: 9775

Re: TM1 SDK JavaExtensions ( Any early adopters )

In general, because you have access to nearly all TI functions in Java Extensions you should not need to access other TM1 APIs, whether it be the TM1 Java API or new REST API, from Java Extensions. Java Extensions are still quite powerful, but I don't think are meant to replace TI process writing a...
by Mike Cowie
Fri Aug 29, 2014 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 SDK JavaExtensions ( Any early adopters )
Replies: 9
Views: 9775

Re: TM1 SDK JavaExtensions ( Any early adopters )

Hi Uchow10: First, I don't think the description of Java Extensions on the IBM DeveloperWorks site is accurate: "Most TurboIntegrator functions are supported in Java and can be used like any other Java method. You can create TurboIntegrator processes with Java and use Java’s libraries to furthe...