TM1 Forum

EvgenyT: Yes, it should come out to -1020 but if you try it (% Change add 2%) you'll see that it comes out as -980. 2% of -1000 is -20. But it doesn't add it to the original (which would/shoud be -1000 + -20 = -1020), it adds the absolute value (so -1000 + abs(-20) = -980 ) DuncanP: Yes I was using ...

I think this is a bug. But after searching around a bit, I don't see anybody else complaining about it, so maybe it is by design. But why anybody would want it that way ... My user wanted to increase a future budget by 2% over a range of accounts, cost centres and periods. I had them do a spread, us...

Well how cool is that! I've never used the DBSS function before. I must have seen it since I've read the reference guide cover to cover umpteen times, but I never realized that that is what it was used for. So I've tried it, it works. Per my example in column E I put: =DBSS( D7, $B$1,$A7 , "Pro...

Sorry, I haven't done a search of the forum. I wouldn't even know how to compose a search argument. I made a quick slice report that has two adjacent columns. Column C = DBRW($B$1,$A7,"Process Description") Column D = DBRA("ExpenseProd:}Processes",A7,"Description") (Bas...

3952 [3c6] WARN 2012-08-09 11:26:39.455 TM1.Cube Ignoring implicit value found in cube or cube delta: "People" I have this warning in my Message log file. The message repeats thousands of times. I tried searching for the message but can't find anything. Any idea what this is about or what ...

I have in an application form a large cell. ie. I have merged 7 columns and 4 lines into a single cell. That single cell has a DBRW in it that points to a string cell in a cube. Voila! It works. (I understand there was a word wrap bug, which I had seen before, that has now been fixed in 9.5.2 FP1). ...

lotsaram ... that's brilliant.

So the row height follows the largest font in the line.
I don't even need the attribute lookup in most cases (but that's a good idea too).
Just a conditional format on a hidden column that sets the font size based on level.

I'm going to start using that.

I have often wanted this. (Well, actually, my management wants this. Formatting to senior management seems to be as important as the numbers themselves, but, I digress.) Reports just look better if there is a spacer line between one section and the next. As was pointed out, this is easy enough to do...

I'm being driven to distraction by the difference between the Browser and Excel. In Perspectives Excel, I make an Active Form. It is a thing of beauty. I have the column widths set such that there is plenty of room for the numbers. It looks great in Excel. But when I view it in the browser, large nu...

Doh! OK, I've read over the suggestions. Thanks for them. The easy answer to my problem above was to replicate the [DynamicTop] subset in the Organization dimension. [ForecastOrg].[DynamicTop] is {FILTER( {TM1SUBSETALL([ForecastOrg])} , [Forecast].CurrentMember.Name = [}ElementAttributes_}Clients].(...

{[ForecastOrg].[DynamicTop]} gives me a subset from the ForecastOrg Dimension I actually want a subset from the Organization dimension. From what I can tell, mdx relates the subset to the dimension first mentioned. ForecastOrg is shallow Total -EC4IND -EC4GB Organization is deep Total -EC4IND --7 mo...

I want a dynamic subset that is based on a value stored in another dimension-subset. I'm starting with this, which works fine: {TM1FILTERBYPATTERN( {TM1SUBSETALL( [Organization] )}, "EC4GB" )} But what I actually want to test on is in another dimension subset: [ForecastOrg].[DynamicTop] ( ...

I'm trying to create some documentation of my rules. To do this, I'm copying and pasting them into Excel. (Why? I'm writing some nice english comments for each rule and want to be able to filter by Rules, Comments and Feeders). To make my comments stand out, I have coloured various pieces. But when ...

Well, I wish I had read this thread before I tried using it. EnableBulkLoad is equivalent to having a remote car starter that allows you to start the car while outside the vehicle. It then locks all the doors, and the remote has no stop or unlock button. I just started a process after adding EnableB...

I have a Chore set up to run every 5 minutes. The process does something if it finds a trigger. In the Prolog, I determine if there are any triggers NumberofProcesses = SubsetGetSize( '}Processes' , 'ToRun' ); If there are none, it calls a ProcessBreak IF( NumberofProcesses = 0 ); ProcessBreak; ENDI...

I have a Chore set up to run every 5 minutes. The process does something if it finds a trigger. In the Prolog, I determine if there are any triggers NumberofProcesses = SubsetGetSize( '}Processes' , 'ToRun' ); If there are none, it calls a ProcessBreak IF( NumberofProcesses = 0 ); ProcessBreak; ENDI...

I have a process that deletes all of the children of a consolidation. The consolidation point is still called a consolidation. I can use an attributes dialog box to change it from Consolidated to Number but I can't see how to do it in TI. DTYPE tells me the type DimensionElementInsert lets me specif...

I would find it extremely useful to be able to write a filter on these lists: - The Perspectives viewer tree that shows: Cube ---Dimension ----- Subset1 ----- Subset2 ---Views ----- View1 ----- View2 -And/or the Subset dropdown on the Subset editor -and the View drop down on the cube viewer Filters ...

Yes, basically I'm just moaning. Having the graph in Perspectives isn't necessary. But given that it does exist on the browser, it is a shame that the publishing process wipes it out. Any idea where the parameter lives for the web that says: table, graph or both? If said parameter could be diddled b...

I only just noticed this. Da. In the browser, a view can be viewed as a table, a graph or both. There seems to be no graphing of views in Perspectives. I know, I could build a graph in an Excel active form, but this is more work than the quick and easy option on the browser. The reason this came up,...