TM1 Forum

Dear TM1 community, please welcome a new member: SPACE (Succeedium Planning Analytics Cloud Extension). https://succeedium.com/space/ Push the boundaries of IBM Planning Analytics with Python integration and additional functionality built into IBM Planning Analytics Workspace The current version all...

You can use the Cognos REST API to check the group members:
https://developer.ibm.com/apis/catalog/ ... up_members

Then you can implement relevant logic to perform tasks such as removing users in TM1.

You can do it using the Cognos REST API:
https://developer.ibm.com/apis/catalog/ ... from_group

Send me a direct message if you consider 3rd party paid products with this functionality implemented

Yes, I created some of my demo models using the TM1 REST API only. Or even with no coding at all: https://community.ibm.com/community/user/businessanalytics/blogs/vlad-didenko/2022/04/26/create-tm1-dimensions-directly-in-google-sheets?CommunityKey=8fde0600-e22b-4178-acf5-bf4eda43146b https://succeed...

Dear TM1 community, especially all #TM1 REST API enthusiasts, the REST API opens up great opportunities for IBM PA developers to create more possibilities for IBM PA users to benefit IBM PA clients. But forcing to use non-interactive accounts does limit this A LOT! Please vote for this Request For E...

if you consider Google Workspace integration (Google Sheets/Docs/Slides ), then please look in the commercial subforum at TeamOne Google Sheets add-on for IBM Planning Analytics

Now you can embed IBM Planning Analytics data directly in Google Slides and Google Docs with an ability to refresh it anytime or let Google detect when the data has changed. #TM1 + #GoogleSheets + #GoogleSlides = #TeamOne https://youtu.be/fFhwlJ5g2vw TeamOne Google Slides thumbnail.png Read more: ht...

I've been also using TM1 Perspectives with Microsoft Office 365 no problem. Unlike the previous Office versions, you are getting Office 365 updates more often and obviously that would be challenging for IBM to catch up and commit to support each next one. Also IBM is focused more on PAfE, so I would...

A new #Python based #SAP #BW Connector for #TM1 - up to 30x faster than IBM Cognos Package Connector or IBM Cognos Integration Server. Trigger SAP BW exports from TI processes, define import logic in Metadata and Data tabs or use #TM1py Please send me a direct message if you are interested https://s...

For smaller logs, I would just use LogOutput() Then you can search the logs using TM1 REST API (or check TeamOne in the commercial subforum: https://www.tm1forum.com/viewforum.php?f=20) Another option is to write logs to a custom cube I also like the drill to file solution proposed by George and map...

Need to quickly check the server message log for your IBM Planning Analytics / TM1 Local or Cloud server? Enable TeamOne add-on for Google Sheets and do it directly from your browser, no installation is required https://succeedium.com/teamone/doc/logs.html#message-log Or if you debugging something, ...

I would also go with creating a new cube and copying the data, so you can debug\test many things in parallel. The next steps would depend on your model. Do you have rules referencing the cube you renamed? Do you have processes referencing that cube? What security you have for that cube and how it is...

You can "intersect" multiple hierarchies of the same dimension using this syntax: CellGetN( 'cubeName', 'dim1Elm', 'dim2Elm', ( 'dim3Name:hier1Name:hier1Elm', 'dim3Name:hier2Name:hier2Elm', ... ), dim4Elm, ... ); BTW, it can be all dynamic using variables, you can even "omit" som...

Hello all, Does anyone know how I can customise the TM1Web start page so that the Change password selection or the Login option are not displayed? I know that there are some CSS files, but I am not sure where exactly I can adjust what. I haven't found anything in the search here either. Thank you v...

Hi Niko, I assume you are using an action button in a TM1 Perspectives report. In the Action button properties, in the process options, you can specify to Show confirmation dialog message and add there something like This process can take 20-30min, would you like to proceed? Couldn't think of any ot...

What client/application will be calling TM1 REST API? If it is a web page, you can create a small login form and then pass the credentials in Authorization REST API request header. You can go further and implement some way of storing the credentials (encrypted cookies, browser local storage, externa...

It should be possible to change the default styles (including hiding some elements) by modifying the CSS files. I remember I had a requirement to enable separate URLs for different TM1 models, so I modified some TM1Web JS files used on the login page. The custom javascript was reading the URL parame...

Do you expect users to see the chores (they would need the corresponding permissions) or some admin account to export this information somewhere? Using TeamOne Google Sheets add-on (free for developers), you can see, search, compare and deploy chores directly from Google Sheets (no installation is r...

I use AWS and even with small instances (like t3.medium) had no issues. Though I've never compared vs on prem. I use RDP to access Architect and other stuff on the server. Assuming you have the same or similar enough server specs, I would look into running some stress test software to compare your A...

Even though we migrate corporate budgeting to IBM Planning Analytics / TM1, we never get rid of spreadsheets. Users still use spreadsheets to prepare and upload their data to TM1, they export data from TM1 and use spreadsheets to re-arrange, massage and format it. Every TM1 developer uses spreadshee...