The cause was a stupid mistake in a rules definition...
Everything seems to works fine now.
Search found 50 matches
- Wed Sep 02, 2015 8:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: cell security with TM1User()
- Replies: 1
- Views: 2256
- Mon Aug 31, 2015 6:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security - default view
- Replies: 7
- Views: 5742
Re: Security - default view
Hello qml, are there limits to your technique to have different values for different users in the same cell? We used it, too, for our cell security, but in TM1 10.2.2 it seems to cause Problems that I described in this thread: http://www.tm1forum.com/viewtopic.php?f=3&t=11943&p=57215#p57215 ...
- Mon Aug 31, 2015 4:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: cell security with TM1User()
- Replies: 1
- Views: 2256
cell security with TM1User()
Hello Forum, in the past (10.2.0) we used cell security where the cell security values were calculated with TM1User(). At runtime this means that a cell of the cell security cube would contain a WRITE for certain users and the same cell for other users would contain nothing. This worked very well wi...
- Wed Jul 01, 2015 1:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cell type is real
- Replies: 14
- Views: 10406
Re: Cell type is real
Yes, it was pseudo code - regarding the Dimension Names. But the Dimension and the variable containing the dimension elements have the same name and that is what I wanted to be reflected. Who knows if this could not have been a Problem, too... I do TM1 Support for Consulting customers and inhouse fo...
- Tue Jun 30, 2015 4:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cell type is real
- Replies: 14
- Views: 10406
Re: Cell type is real
I actually meant ""Why do I get THIS error, though I "made sure" that I cannot get it"". If I do not trust why should I not also consider that an error message could be misleading. I have seen this in my life. I should have mentioned that I checked the Cube order before...
- Tue Jun 30, 2015 2:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cell type is real
- Replies: 14
- Views: 10406
Re: Cell type is real
I have checked the threads referring to the error "cell type is real". My Problem is that I have a check for the cell type and still get the error. I copy data within a cube - string and numeric values. A cube view is used as source. Consolidated, calculated and zero value cells are exclud...
- Mon Feb 23, 2015 5:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exponential Problem with Natural Consolidation
- Replies: 18
- Views: 14812
Re: Exponential Problem with Natural Consolidation
IBM states that this would be fixed in TM1 10.2 but it is not entirely if even or IBM means a Version above 10.2.0. Create a formula as follows: ['a'] = N: ['b']; where values for 'a' are entered directly and afterwards there is plain consolidation. Then put 'a' and 'b' into a consolidation 'c' wher...
- Mon Feb 23, 2015 5:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX subset sort by Alias
- Replies: 9
- Views: 27662
Re: MDX subset sort by Alias
Thanks to both. That sounds very reasonable.
- Wed Feb 18, 2015 3:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Stack Overflow Evaluating Feeders
- Replies: 7
- Views: 8222
Re: Stack Overflow Evaluating Feeders
We do have this Problem in 10.2.0 FP1 already - when we use conditional Feeders "too much".
- Wed Feb 18, 2015 3:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Stack Overflow Evaluating Feeders
- Replies: 7
- Views: 8222
Re: Stack Overflow Evaluating Feeders
3 APARS have been issued: ************************************************************************************************************************************************************************************ *********************************************************************************************...
- Mon Dec 08, 2014 12:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX subset sort by Alias
- Replies: 9
- Views: 27662
Re: MDX subset sort by Alias
I sorted a Dimension by an alias. a) {TM1SORT( {TM1SUBSETALL( [DimName].[Alias] )}, ASC)} b) {ORDER( {TM1SUBSETALL( [DimName] )}, [DimName].[Alias], ASC)} Result: Both mdx-Statements sort the dimension. Both mdx-Statements sort differently. Does somebody know the differences between TM1SORT and ORDE...
- Thu Nov 27, 2014 1:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using Picklist in Control Cube
- Replies: 5
- Views: 6664
Re: Using Picklist in Control Cube
IBM (2014-11-27)
"After discussing with PM, it was decided that picklists would only be applied to control cubes if and only if they came from the control cube's picklist cube (ie. Picklists coming from control cube dimensions are ignored)."
"After discussing with PM, it was decided that picklists would only be applied to control cubes if and only if they came from the control cube's picklist cube (ie. Picklists coming from control cube dimensions are ignored)."
- Tue Oct 07, 2014 8:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Equivalent of TM1User() function in Rules
- Replies: 23
- Views: 19742
Re: Equivalent of TM1User() function in Rules
IBM supports the function TM1User() in Rules - means you can open tickets.
The rule function is just not documented.
The Syntax is "TM1User" or TM1User().
TM1User can be very helpful in (cell) security cube rules.
The rule function is just not documented.
The Syntax is "TM1User" or TM1User().
TM1User can be very helpful in (cell) security cube rules.
- Thu Aug 21, 2014 11:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Automatic recalculation websheets in Cognos Express 10.2
- Replies: 2
- Views: 4035
Re: Automatic recalculation websheets in Cognos Express 10.2
From IBM:
Since the Interim Fix 4 for TM1 10.2.0 Fix Pack 1 aka TM1 10.2.0.1.4 the TM1 Web configuration parameters "RecalcOnActivate" und "UseBookRecalcSetting" are supported.
Check it out.
Since the Interim Fix 4 for TM1 10.2.0 Fix Pack 1 aka TM1 10.2.0.1.4 the TM1 Web configuration parameters "RecalcOnActivate" und "UseBookRecalcSetting" are supported.
Check it out.
- Sat Aug 02, 2014 6:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with umlauts in calculations
- Replies: 3
- Views: 3877
Re: Problem with umlauts in calculations
TM1 10.2.0 FP1 and TM1 10.2.0 FP2 are case sensitive with Umlauts like ä, ü, ö or á, ò in object names. Just try entering element names in the Dimension Editor. With "normal" letters you will not succeed. When using DBRW() and entering the element names with the wrong case of the Umlaut, y...
- Sun Jul 20, 2014 12:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Change Element Order Using Element Editor Window
- Replies: 9
- Views: 7584
Re: Change Element Order Using Element Editor Window
I have the same problem in TM1 10.2. I would like to change the order of the dimension elements of a dimension with about 1000 elements, as I accidentially ordered it in a TI-Process. My goal is that all children of all consolidated elements have a certain order, that our Controllin wants to have. T...
- Thu Mar 27, 2014 11:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Order
- Replies: 12
- Views: 19858
Re: Dimension Order
Hello lotsaram and declanr, thank you for your answers. **************** lotsaram rote: If you don't have data then by definition an empty cube is 100% sparse. The data in the cube determines the density (or inversely sparsity), ergo without data you cannot optimize properly as all you could do is s...
- Wed Mar 26, 2014 8:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Order
- Replies: 12
- Views: 19858
Re: Dimension Order
Sorry, again something came to my mind afterwards.
How about optimizing dimension order in system cubes?
According to the proposition of "system" our large element attribute cubes could save 40-80% of memory...
Is there a risk/gain optimizing there dimensions order?
Thanks
Tilo
How about optimizing dimension order in system cubes?
According to the proposition of "system" our large element attribute cubes could save 40-80% of memory...
Is there a risk/gain optimizing there dimensions order?
Thanks
Tilo
- Wed Mar 26, 2014 8:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Order
- Replies: 12
- Views: 19858
Re: Dimension Order
Best Practice Guide by Bedrock for Desinging Cubes:
http://www.bedrocktm1.org/resources/fil ... Design.pdf
http://www.bedrocktm1.org/resources/fil ... Design.pdf
- Wed Mar 26, 2014 8:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Order
- Replies: 12
- Views: 19858
Re: Dimension Order
I forgot to add something: I know that parts of the cube are sparse and some are not - eg. the past years are dense and the actual years are not. The usage of cube cells could have a correlation to that density/sparsity - eg. the actual year is used for input and showing actual figures, the past yea...