TM1 Forum

Yes, tried that. Forgot to mention it. Afterwards I can do a GitInit again with a proper result as far as I can see it. {'@odata.context': '$metadata#ibm.tm1.api.v1.Git', 'URL': 'xxx.git', 'Deployment': 'dev', 'DeployedCommit': {'ID': None, 'Summary': None, 'Author': None}, 'Remote': {'Connected': T...

I played around with the git integration on my local machine and encountered an error for which I could find nothing on the forum or the internet. I am using 2.0.9.1. {'error': {'code': '289', 'message': 'Failed to delete temporary TM1 Git directory "d:\\zz_shared\\_development\\tm1\\mysamples\...

Found something that solves #2 issue - removes single quotation mark. I think that code below can be adapted to resolve #1 issue same time.. Yes, you could do that easily with the snippet. But I would stay with Wims suggestion to add a second alias or if you only need it for your export a simple te...

Elessar wrote: ↑Thu Jun 04, 2020 10:32 am you can use TM1ELLIST function for this:

Didn’t know that one. Thanks for sharing.

AFAIK the answer is no. As both of those tools use the old C-API they need the admin server to connect. How would you tell architect to connect to your database without specifying an admin host. Rest based clients should (technically) be able to connect to the instance without the admin server. But ...

Why don't you try to use the date time functions in rules? https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/r_tm1_ref_timst.html If you can convert your cube value to a serial date you can use TIMVL(datetime, type, ExtendedYears) to calculated ...

Hi @scrumthing,

I don't think this is something we would add to TM1Py. We really want to focus on the server REST API and I am not sure accessing the PA agent is documented or officially supported.

Got a response. Seems it is not going to happen.

I took the liberty to create an issue over at github for that.
https://github.com/cubewise-code/tm1py/issues/276

Performance-wise, go for the second option. Though there is N: and N: but you will have noticed that I guess, and also a parenthesis too much. I would say second option as well. in general consolidation is faster for aggregation then rules because of the sparse consolidation algorithm and stuff... ...

David Usherwood wrote: ↑Thu Jul 09, 2020 9:19 am Perhaps Marius would be interested in adding it to TM1PY in his spare time...

I would support that motion.

I am interested in it. Could you share some more examples? I don't see any official documents to explain that. Sure. But don't expect much. A colleague of mine showed me the api. First you have to install the PAW Adminsistration Agent which allows PAW to get the information presented in the new adm...

You could try using the Planning Analytics Adminstration Agent API to get some of the information. https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_tm1_install_paa.html After installing it just call the api (example: https://localhost:9012/pakate-ag...

Paul Segal wrote: ↑Wed Jul 08, 2020 8:07 am I'm going to go with "No".

I am going to support that statement.

FWIW you can use CellGetS and CellGetN in place of DB in rules ... At first I thought: 'how cool is that. I didn't know that.' Than it settled in. DB( is way shorter and I do not need to differentiate between S and N at that point in rules if I know my data model. :-( But still... It is nice to kno...

Yes, I want that!

Thanks for the info! As always the documentation is not right.

HighKeys wrote: ↑Thu Jul 02, 2020 12:15 pm why you dont create a SQL View and just import the View?

I second that. I would keep the sql query for the data source as simple as possible. Besides string variable limits, etc. it is about performance as well. depending on your sql database views are cached for example.

As far as I understand it IBM reverted the change. Update (June 30th, 2020): The IBM Planning Analytics team will revert the change described in this Technote in an Interim Fix for Planning Analytics 2.0.9.1. This Technote will be updated as additional details about the Interim Fix are available. Th...

The other issue with PAW is the need to maintain two sets of security. For me that is the worst part. It is AFAIK still not possible to delete users in PAW in an orderly fashion. At least not if you want to the ability for every TM1 user to simply log in. Especially if you want to host different ap...

From a quick lock at the rules and feeders I would suggest you look at ['Amount', 'Forecast','time_mqy':'comment', 'Annual Salary' ] . That seems to kick it off. Check if that cells behaves differently. For everything else IMO someone has to check that cube in more detail. But it is already late so ...