TM1 Forum

Just to add one last thing to this, I think versions 9.4 - 10 (as declanr states after that you get a meaningful error message), the error message is the classically cryptic "possible missing y after x", roughly translated as TI telling you "there's an error somewhere, go find it chum...

I think it may support up to 20, at least it used to.

Also - depending on what version of TM1 you are using, a TI script will actually save without error if you exceed the nested limit, I think any version prior to 9.4-ish.

I'd use it in any scenario where you call on dimension based logic such as the ELPAR suggestion mentioned before.

Jack

Not for the first time in a decade or so the documentation leads you up a blind alley, or, at least doesn't show you the whole route home. A basic rule on a four dimension cube that states: ['Result']=N:['Element 1']*['Element 2']; Can also be written as: ['Result']=N:DB('cubename',!dim1,!dim2,!dim3...

Yes, you can use the DB function to reference the cube that you are writing a rule for, it's not exclusive to referencing other cubes.

Hi tarry9, You can resolve this issue by highlighting all the cells that have a DBR or DBRW reference that relates to a picklist and then removing Excels data validation from the TM1 picklist reference to "Any Value". If you then save and republish your sheet back to TM1 then the #REFs wil...

Thanks a lot guys, yeah I'm having the TM1web problem, just have to live with it like all the other outstanding TM1web formatting issues. It was out of curiousity to be honest, I do a lot of work with UIs in TM1 and was just wondering if anyone knew how TM1 was telling cells that, according to the w...

Cheers Tom!

Awesome that is, solves me all sorts of UI problems - thanks ever so much!

* - This fix doesn't seem to work in TM1web, but that doesn't surprise me - was that your experience as well Tom?

Jack

Hey Dan, Thanks for the response. All the rows in this example are N level, as you can see from the values in column A. Because the active form has stacked dimensions, when TM1 builds the active form formats the cell in column B after the first row differently to the first. If one selects the cell (...

Hello everyone, I was wondering if anyone had any experience or knowledge of the following: If one creates an active form of say, 5 stacked dimensions of row, at leaf level with no consolidations an active form, by default, will create the effect of the following: http://i702.photobucket.com/albums/...

What you could consider is following this sort of approach: Rather than deleting all the existing elements, you could "unwind" the dimensions consolidations and rebuild it based on the definitions of the data source, if it's changed: dim='your dimension'; i = dimsiz(dim); x=1; While(x<=i);...

Hello, I assume that TM1 is set-up to use the Cognos8 security, and that the CAM id in question is part of the TM1 admin group? TM1Top is just saying that TM1 doesn't recognise that CAM id as a admin user, and therefore wont verify that TM1Top session as an admin session to use the other controls of...

I'd also add a ViewDestroy(cube,view) in your epilog or the next time you run your script it will abort due to the view you're trying to create already existing. Plus, that will trash the view and not leave any pesky views around for users to open. Especially if it's a server crashing monster. That ...

Thanks lotsaram, The technique I referred to before, using TM1 attribute formats as a custom dd/mm/yyyy works in TM1web and allows a user to interact with an Excel websheet and change a serial date number in the corresponding cube - just unit tested some sheets changing dates this way and can confir...

Just a quick update for anyone that also has issues along these lines: TM1web will recognise a serial date if I use TM1's custom formatting in the dimension attributes themselves, but I get some strange behaviour in TM1web with any other format other than dd/mm/yyyy. With any elements formatted in t...

Morning all, I'm currentley working with a client who are using TM1 9.5.1 installed on VMWare Server 2008, 64-bit, 32g RAM who (until now) interact with their TM1 model via various Excel input templates. One thing that they are keen to do is to facilitate some of their interaction with TM1 via the T...