TM1 Forum

If this is how you are thinking about building your reports then it is clear that as of now you and your company definitely don't "get it" in terms of how to utilize TM1 to automate GL reporting and remove maintenance overhead. You may get to the end of the process in a month or 2 and the...

I would suggest experimenting with the record feature in the subset editor with the expression window visible. Displaying all elements and then filtering to include everything except level 1 should give you an MDX statement along the lines of what rmackenzie has suggested. Tweak this if necessary a...

If you go down the active form/ dynamic subset route then the TM1FilterByLevel function may help: {TM1FILTERBYLEVEL( {TM1SUBSETALL( [YOUR_ACCOUNT_DIMENSION_NAME] )}, 0,2,3,4,5,6,7,8,9)} This won't 'make the level 0 accounts roll into the level 2 accounts' but will have the effect of the level 1 acc...

I'm not entirely sure what you're proposing with SUBNM but guess you're talking about using the element indexes to try to get a full list of elements? I've not really tried this. Personally, I'd still suggest you try with an active form. With a bit of practise you can build some pretty flexible rep...

I think I got my answer. It doesn't look like I can create an active form from a dimension, only from a cube. If that is correct, I will have to go by SUBNM.

Thanks everyone for your help! This has taught me a lot!

One major problem here, is that I don't have access to creating public subsets, I just do the reporting, and our "TM1 guy" does the subsets. This might change but we want as little as possible tampering, thus handing it over to one person. He created a dynamic subset, but I don't see any c...

This is only the base, and I am building a HUGE report on top of this. It has to be as simple as possible, with the least, or without any at all, calculation time... I will look into the activeform option and see where this takes me. One reason I can think of now, is because I want to filter out cer...

I want to work in excel, could be formulas or VBA. The reason why I do not want a dynamic subset, is because I don't want to keep creating subsets for each report I create. This will just mess up the TM1 database with extra junk. I want all accounts, including the lowest level, but not the second to...

I am trying to create a macro in Excel VBA, which will list our chart of accounts hierarchy from our database into one excel column. I want to do something like "while this has components, list me all components". Something like a loop within a loop. There are like 12 levels, and I want to...