TM1 Forum

Hi all! I am testing out the PAX APIs based on: https://ibm.github.io/paxapi/#logon My intention is to schedule weekly refresh & auto email of TM1 reports to non-tm1 users with the following steps: 1. Log on 2. Refresh all data 3. Unlink 4. Save as 5. email When I have excel open and run the mac...

These type of issues are almost always due to permission issues between you physically being logged into the desktop of the server (and thus executing the batch under your ID) versus running it via TI which executes the batch under the service account TM1 runs under. Thank you for this! it was perm...

DimensionDeleteElements (DimensionName, Subset ) That's it ! I knew it exists but I missed the name. Thanks. Really appreciate all the responses I am getting for this 🙏 Forgive me if I am being slow here but does this mean I can create my temporary subset in prolog with all the items with the crite...

Hi all, I've tried pushing data from TM1 directly into Redshift via ODBC connection. It works however it takes way too long. I've been offered an alternative solution by the data engineers. I am exporting the required data from TM1 into a CSV and then executing a batch file to push the data up into ...

If it's a one-off exercise, why would you bother about 1 minute ? Or is 1 minute only for a small part of your dimension ? Regarding deleting elements, you could identify them with an attribute value (AttrPutS), then create an MDX to grab the elements based on the attribute (Filter). Next steps is ...

Nothing in metadata, data, or epilog tabs and the datasource is set to none? How long would it take to return a value in cubeview that your CellGetN for sTotalRev is querying? I've modified your code by splitting the IF statements and putting LogOutput statements at each step so you can see the tim...

You don't need to use a subset as a datasource for the TI and code in metadata. Your metadata also appears to be updating an attribute and then querying the just updated attribute. Why not skip the attribute update/query entirely and simply delete the element if sTotalRev = 0 and sSubstring > 0? I ...

Hi ascheevel - Thank you so much for replying. I have input the following into the prolog and didnt use any data sources. I had put in between 454 and 456 as a tester as one of the elements I want removed is index = 455 (assuming my understanding of the loop is correct). However the code runs for ab...

Hi all! I am fairly new to TM1 so please bear with my very newbie scripting and question. We have a cube which has not been maintained for a long time. It has accumulated a lot of of dimension elements which contains no values in any of the cube measures (i'm talking millions). I have been researchi...