TM1 Forum

Luckily it's still early in the development phase, so rebuilding is still an option.

Thanks for the help!

If you have a dimension with brackets in it's name, say "Dim1 (Brand)" for example, how to you specify the dimension in a function as: =N: DB("Cube1",!Dim1(Brand), ...) You get an error if you try to do it as above. Putting quotations in won't work either. Has anybody encountered...

Hey guys, I've got a weird problem that I don't quite understand. When doing a dynamic slice on a view into excel I get my list of dimensions first (About 40 dimensions) with the data following after that. If I cut the section with all my dimensions and move it say from column B to column C the form...

Thanks for the replies!

We're using TM1 9.1 SP3. So unfortunately no Active forms.

I'll play around with the proposals and see if I can figure it out.

Hi, I need to set up an Excel Report that (Simplified) needs to look like something like this: ITEM VALUE-1 VALUE-2 Item001 20 10000 Item002 15 20000 Total Brand-01 35 30000 There are a number of Items linked to each Brand. The report should show the Items that contain values within the Brand, as we...

Okay. I've spent some time with the problem trying all sorts of ways of feeding the calculation. But basically the only way I can get it to work is by feeding it as I did in the beginning. Now my question is this: Are there situations within TM1 where you're feeders end up consuming a lot of memory ...

Thanks for replying guys. Herman, That's actually the first way I tried to feed it. Did not work. I didn't get any values. lotsaram, I think I did actually try it that way at some point but it didn't really make a difference. Still used up a lot of memory. I'll try it again as soon as I get a chance...

Hi, I'm struggling to figure out what the feeder should look like for the following rule: ['Site - 1','Account A',Attribute5:'Allocation'] =N: ROUNDP(['Sales Sites','EXPENSES','All Attributes (2)','All Attributes (5)']* ['Allocated Site','Turnover %','Allocation2','Allocation3','Allocation4','Alloca...

Thanks for the help guys, it did the trick Andy. It always seems to be something silly you're missing.

Hi, I believe the following to be a Feeder issue but for the life of me I can't figure it out. Any help on the matter would be appreciated. PART 1 - RULE: [{'Actual','Budget'},'20','S2 - Site':'Allocation','S4 - Account':'Fixed %','S5-Brand':'Allocation',Attribute1:'Allocation',Attribute3:'Allocatio...

I'm working on 9.0 SP3 actually...anyway it's not a major issue. Just a very annoying one. Hopefully it doesn't happen again.

While working on my rules and making a chance, literally just changing “ATTRS('Cul Customer Market',!CulCustomerMarket,'Adhoc') @= ' RET '” to “ATTRS('Cul Customer Market',!CulCustomerMarket,'Adhoc') @= ' W/S '’ and clicking on Save, TM1 Froze up on me. After getting back into my Rules Edito...