TM1 Forum

I recently was playing around with some of the new (and by "new" I mean "new to me") TM1 rule functions, and stumbled across something that may be interesting to others. Thank you PavoGa for your help in testing and validating this thing! For a while, we've known about the abilit...

@asutcliffe Thank you for checking out the project! You hit on a couple points that I thought would be good to address in order to clarify the state of application. Compiling and Installing: The Makefile is admittedly very lightweight. I do plan on adding some dependency checking and better handling...

A while back I started playing around with GUI design using the GTK library (completely unrelated), and used TM1's Architect as a simple model. Fast forward a few months of on/off (mostly off) development, and I ended up with a project that actually had a bit of potential. What I now have is a GUI f...

* Mods feel free to move this if it is in the wrong place! In an attempt to simplify child -> parent return data, I decided to see if I could implement a reliable stack structure within TM1 to easily pass values between functions without having to write anything to a cube. My main requirements were:...

I apologize in advance for necro-ing a very, very old thread, but I felt the need to clear the air on how TM1 implements random numbers. The article referenced in the previous post (everanalytics) misses the entire point of the RAND implementation, and quite frankly is establishing the obvious truth...

Hi Everyone! I may be the only one on the planet that uses VIM as their go-to text editor, but in case there are others, hopefully this syntax highlighter helps! I threw this together a little over a year ago for basic "quality of life" improvements when looking at .pro files in VIM, and i...

Hi Everyone, I recently came across an interesting situation where I had an Active Form with 2 tm1rptrow columns, one of which was based off of the results of the first tm1rptrow function. I saw a few posts discussing how this either wasn't possible, or there were some workarounds dealing with tempo...

Hi Wim, I had a chance to play with the REST API a little more and narrowed down your question number 4 to the "ActiveConfiguration" metadata parent. Basically, everything is summed up under 4 categories: Active Configuration: Access Administration (this is what you are looking for) Modell...

@Wim - sorry! This is my last post, I promise :) @Lotsa Thank you for taking the time to respond! I realize maybe my posts were too blunt, and I apologize, I hope there are no hard feelings. I must say I did not expect tm1py to have such a strong support network. If the community here thinks that I'...

@Alan Kirk,

My god that explains the random macros that I stumbled across!! These are still hanging around as of PA 2.0 under the name "IMPEXP_WORKS" and can still be mapped into the Quick Access Ribbon by looking under the "Macros" drop-down.

Hi!

Would you be able to post the code that is encountering the error? If you have a variable that is holding the file path, could you also post the declaration of that as well? The more the better!

@David, I'll start by saying I full agree, and that by no means did I intend to downplay the significant improvement to the REST API that tm1py has managed to implement. I respect Marius' commitment to the community and can only imagine how difficult it must be to maintain opensource projects (espec...

Hi Wim, Another good exercise! I don't have time to test this out right now, but I will definitely take a stab at it when I get some time! I found the following function in the VBA API that looks like it _could_ be the function that returns the right information to build out the hierarchy. Again, th...

Just my 2 cents, tm1py is a great library, but its biggest downfall is that it is not heavily supported. I've experimented with it throughout the years, but even now it looks like it's last update was almost a month ago. Depending on what your use case is, it could be a perfect fit. As a general rul...

WOW!!! Great job on digging that one up! I'm honestly surprised that this is the first time it's come up (with the variety of keyboards/layouts that exist in the wild), but either way, I guess we can look forward to an update in the next fix pack Nicely done!

Not a problem! Feel free to send any verification requests over my way!

Hi Wim, This sounded like a pretty interesting problem to kick off the new year with, so I figured I'd give it a go. Unfortunately, I was unable to reproduce the issue you are encountering. The following are the things I've tried (please let me know if I didn't recreate a step correctly): Opened Exc...

Great summary! For the sake of sharing, my personal preference is to edit rules and TIs using VIM :o You'd be surprised how powerful it can be. Delete everything inside the parenthesis (or brackets, quotes, etc.) using 3 characters "d+i+*char*". But yes, notepad++ does have better syntax h...

Hi Everyone, Maybe I'm misunderstanding, but this is extremely easy to do with a custom add-in (however I agree that I don't quite understand why this would be needed). Create a new module in a blank workbook and put the following code in there: Private Sub Auto_Open() Dim wb As Workbook Set wb = Wo...

A few ideas come to mind, but nothing pretty. Excel will prompt you to save an open workbook if you have made a change to it, which means we could potentially use that in our favor through one of two options: A) Put a space or some random character into a cell of the blank workbook that opens on sta...