TM1 Forum

The feeder is fine:

Are you looking at the correct cube?

Did you save the rule file?

Why doesn't the feeder work? - Are there non-zero values that are suppressed when they shouldn't be?
All cells with zero in them will be suppressed whether or not they are fed.

Hi, I wish to map a value from cell1 in sheet1 in workbook1 to a value in cell2 in sheet2 in workbook2. There seems to be no available 'Value' option from the source workbook - as a workaround I created a dummy SUBNM with the correct value. However I can't seem to get that to work - what needs to be...

Martin: a search through every cell wouldn't be possible as there are too many cells to check - I was thinking something about checking consolidated cells and only searching the children when there was nothing in the consolidation - which may or may not be effective... Perspectives is not loaded in ...

1. Can anyone think of an algorithm to search an entire cube for a specific value? Keep in mind that the possible number of cells usually far exceeds billions. 2. My VBA Macro that makes use of the TM1 API works correctly when 'Perspectives for MS Excel' has been loaded however does not work correct...

Rule-generated string values are not displayed when a view is zero-suppressed unless the string resides in a cell that is fed.
To enable feeding of string cells, insert the FEEDSTRINGS declaration as the first line of your rule:
FEEDSTRINGS;

I commonly come across errors/bugs in VBA code that suddenly seem to disappear once I use breakpoints and step through the code.

To specify a dimension for an element: dimensionName:'elementName'

eg. [account:'1000', version:'forecast'] = [version:'actual'];

Nothing wrong with some confirmation - AK.

Sounds like your feeders are not correct which could have:

a) Always been the case but you never noticed - note that even though a cell is fed, it is not necessarily being fed properly.
b) Never been the case but now you have changed dimension elements

Is there an option to turn of error message boxes popping up when the server loads?

I don't want to edit rules files, dimensions etc... I just don't want to see the error boxes.

Regards.

I imagine this will fix things also...

Why is it that VBA will 'print' the null characters instead of just taking it as a string terminator?

Edit: Erm, is there a function to null out a string?

If my strings were null terminated then 'cube1ings_Bonuses' would appear as 'cube1 ings_Bonuses'.

Take a look at the screenshot I posted - the strings are _not_ terminated with a null.

For example: cube1 is appearing as cube1ings_Bonuses

Here is the picture of output of sample code provided with the API. As you can see - left over characters are still on the string. A solution is to ReDim the String, however the proper length must be known. Does the API have a method for getting the length of the string it gives with TM1ObjectProper...

That's exactly what I've been having to do... Do you know anything about retrieving the name of say a dimension object with TM1ObjectPropertyGet and TM1ValueStringGet_VB? When I don't know the exact length of the name (practically always), the TM1ValueStringGet_VB function is returning the entire al...

I found some code (The samples provided by Cognos) that made use of the function TM1CellValueSet which is essentially the same in terms of arguments: It turns out that I needed to make these two calls in addition to everything else - Call TM1ValArraySet(elementArrayCapsule, elementArray(1), 1) Call ...

What am I suppose to use to get the integer out of a "TM1 value capsule containing an integer"? There certainly isn't a TM1ValIntegerGet() TM1ValIndexGet Purpose Retrieves the contents of an index value capsule. Definition Declare Function TM1ValIndexGet Lib "tm1api.dll" (ByVal h...

Has anyone found it very hard to debug code that makes use of the API? Has anyone discovered that the Visual Basic section of the API in the help file seems to be a copied+edited version of the C section with a lot of inconsistencies (eg. code that works in C and not in VBA)? Here's my current troub...

Are there any issues with having the other currencies in your measure dimension?