Search found 249 matches

by Mike Cowie
Wed Feb 22, 2023 5:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Print Report function for PAfE
Replies: 3
Views: 615

Re: Print Report function for PAfE

Hi John,

Sent you a pm, and in case it's helpful to anyone else here's a link to QueBIT's free Print Reports tool and a post about ReportWORQ in the commercial forum (which has built-in support for things like email distribution of Perspectives / PAfE-built reports).

Regards,
by Mike Cowie
Mon Dec 05, 2022 2:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook
Replies: 2
Views: 1135

Re: Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook

I'm wondering if there is any existing method / has anyone written and VBA code to basically scan a worksheet/workbook and extract a list of all DBRW's/ DBR's (Maybe other worksheet functions) and the parameters being referenced (If they are formula parameters then the values that the parameters co...
by Mike Cowie
Mon Oct 10, 2022 1:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Disclosure Management
Replies: 5
Views: 1714

Re: Cognos Disclosure Management

Has anyone generated an automated reporting package similar to CDM in PAW, PAX or any other alternatives that is as good as or similar to CDM ? When IBM got rid of CDM...was the intention to have the same capability in PAX or PAW or did they expect TM1 users to go to the new owners of CDM ? Appreci...
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: 22037

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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