http://www.tm1forum.com/viewtopic.php?f ... 22&start=0
Same error message, any of it help?
Search found 1748 matches
- Fri Sep 07, 2012 8:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: When i user slice,snapshot,export to PDF,an error window pop
- Replies: 1
- Views: 1419
- Thu Sep 06, 2012 8:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding N-Level Elements to Considation Fails
- Replies: 4
- Views: 3292
Re: Adding N-Level Elements to Considation Fails
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...
- Thu Sep 06, 2012 7:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding N-Level Elements to Considation Fails
- Replies: 4
- Views: 3292
Re: Adding N-Level Elements to Considation Fails
DimensionElementComponentAdd() is a metadata function and as such you should process it in the metadata tab.
HTH
HTH
- Thu Sep 06, 2012 3:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT : how to truncate figures
- Replies: 3
- Views: 2474
Re: ASCIIOUTPUT : how to truncate figures
Search the TM1 reference guide for "round" and the first 2 options are:
# "Round"
# "RoundP"
# "Round"
# "RoundP"
- Thu Sep 06, 2012 2:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Obtaining A "Free" (Sample) Copy of TM1
- Replies: 5
- Views: 3140
Re: If You Could ask the TM1 Development Team a Question....
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...
- Thu Sep 06, 2012 11:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: can I make a rule to lock a cell
- Replies: 2
- Views: 2900
Re: can I make a rule to lock a cell
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...
- Thu Sep 06, 2012 9:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: numbers with 13 digits ?
- Replies: 8
- Views: 3770
Re: numbers with 13 digits ?
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.
Just run a basic sql query to pull the top 1000 rows etc and see what you get.
- Thu Sep 06, 2012 7:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: numbers with 13 digits ?
- Replies: 8
- Views: 3770
Re: numbers with 13 digits ?
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
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
- Tue Aug 28, 2012 1:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to remove server without name from services?
- Replies: 5
- Views: 2925
Re: How to remove server without name from services?
regedit will do the trick.
- Wed Aug 22, 2012 8:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 10.1 Application Web(contributor) blank screen
- Replies: 7
- Views: 6365
Re: 10.1 Application Web(contributor) blank screen
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...
- Fri Aug 17, 2012 8:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Private views question
- Replies: 16
- Views: 13434
Re: Private views question
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 ...
- Thu Aug 16, 2012 9:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating a rule to adjust calculated values
- Replies: 5
- Views: 3287
Re: Creating a rule to adjust calculated values
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...
- Thu Aug 16, 2012 5:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating a rule to adjust calculated values
- Replies: 5
- Views: 3287
Re: Creating a rule to adjust calculated values
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...
- Thu Aug 16, 2012 3:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form - Activating Formulas on a Switch
- Replies: 3
- Views: 2640
Re: Active Form - Activating Formulas on a Switch
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?
Or if you didn't want a control cube just have them change a 1 or a 0 using an excel list?
- Tue Aug 14, 2012 3:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What does DB command do if several fields are blank?
- Replies: 7
- Views: 3443
Re: What does DB command do if several fields are blank?
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...
- Tue Aug 14, 2012 9:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Identify in Rule if dim is part of a cube
- Replies: 10
- Views: 5302
Re: Identify in Rule if dim is part of a cube
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...
- Tue Aug 14, 2012 8:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Identify in Rule if dim is part of a cube
- Replies: 10
- Views: 5302
Re: Identify in Rule if dim is part of a cube
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...
- Tue Aug 14, 2012 8:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Identify in Rule if dim is part of a cube
- Replies: 10
- Views: 5302
Re: Identify in Rule if dim is part of a cube
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.
You can even automate the population of 1s and 0s via TI using the tabdim function and a loop.
- Mon Aug 13, 2012 11:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Facing Strange issue
- Replies: 3
- Views: 2181
Re: Facing Strange issue
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?
Also has the server been restarted? And If so do you have a SaveDataAll scheduled?
- Mon Aug 13, 2012 10:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Logical statements in feeder expressions
- Replies: 11
- Views: 4919
Re: Logical statements in feeder expressions
They generally get called "Conditional Feeders" or "Variable Feeders"; if you search the forum using those terms you will find a load of topics.