TM1 Forum

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,

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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