TM1 Forum

http://www.tm1forum.com/viewtopic.php?f ... 22&start=0

Same error message, any of it help?

DimensionElementComponentAdd() is a metadata function and as such you should process it in the metadata tab. I beg to differ. There is no commandment not to use this function on other tabs (bar the Data tab). That however does not take from the fact that the OP's code should all be put on the Metad...

DimensionElementComponentAdd() is a metadata function and as such you should process it in the metadata tab.

HTH

Search the TM1 reference guide for "round" and the first 2 options are:
# "Round"
# "RoundP"

Hi All, I am new to the TM1 but I have attended training 8 months back. Now i want to practise on TM1 and revise all the concept. Does anybody know how to download TM1 free version? My reply might be irrelevant to the current post but your answer would be a great help. Thanks in advance. This is pr...

hi Guys i have a drop down box with a list of options the user can choose on aa active form. i would like the cell to be locked if they choose 'appointment'. ie. they can select any option they want and change it, but if they select appointment, they cannot write back any information to that cell o...

If you want to know how oracle is storing the numbers surely your best option is to query directly without using TM1 as a medium?
Just run a basic sql query to pull the top 1000 rows etc and see what you get.

If I have understood your post correctly I don't think you are experiencing a bug.

TM1 stores values as binary floating point values; some 2 decimal place values can't be stored in this format which is when you start seeing the .0000000001s etc

regedit will do the trick.

I have seen this when trying to access through an unsupported browser (believe it was chrome or opera) flipped over to one of the supported versions of IE and everything was fine. Can see you're using IE from your screenshots but what version is it? Is it one of those listed by IBM as compatible? Ha...

http://www.bedrocktm1.org/resources/files/BedrockCubeViewPublish.html This allows view to be made public but I seem to remember not really liking it for some reason... If you just want to copy to one user or indeed if you do want to make public I would still probably go with Steve's method and copy ...

Yes, the spreading has been accomplished and works quite well. I tried your approach before, and while it does force the adjustment to be the difference between FINAL and PRELIMINARY, I don't think I explained the situation clearly enough. What the end user wants of course is to use the following f...

So you have already done the spreading portion of your problem? The third section is quite simple and doesn't really require a third cube, just an extra dimension on the second one so values are spread straight to "preliminary" (although a third cube can be used if you want)... then TI the...

You can just have a control cube and send a 1 to that via TI via action button... so basically the same concept.

Or if you didn't want a control cube just have them change a 1 or a 0 using an excel list?

Thank you, qml. is there any difference between two strings: if ( condition statement , DB ( ...... el1 , el2, ..... ) , continue ); and DB ( .... , if ( condition statement , el1 , '' ) , el2 , .....); ioscat, I don't mean to insult with this one but the questions you are asking are quite straight...

It just became a requirement to identify if certain dims are part of certain cubes. And I wanted to make it general and simpler via rules. But then, based on comments, it's the only solution which is as you said very simple to do. Thanks. :D From what I recall there was a TI knocking about (possibl...

The function you want is TABDIM. If it returns 0 then the dimension is not part of the cube. TABDIM only gives you the dimension name for the specified index. TABDIM doesn't accept a dimension name as a parameter. A small helper cube would be the best solution in my opinion. Which can purely be bui...

Presuming that you don't create cubes that often you could just create a 2d cube using }Dimensions and }cubes then have a 1 or 0 to determine if the dim exists in the cube.

You can even automate the population of 1s and 0s via TI using the tabdim function and a loop.

Have you ran a transaction log to see if anyone is changing data (if you have logging enabled)?

Also has the server been restarted? And If so do you have a SaveDataAll scheduled?

They generally get called "Conditional Feeders" or "Variable Feeders"; if you search the forum using those terms you will find a load of topics.