Search found 77 matches
- Fri Jan 12, 2018 2:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security Mode 5 with TM1 Native Groups
- Replies: 6
- Views: 4467
Re: Security Mode 5 with TM1 Native Groups
My memory may be a little rusty here, but aren't you able to add clients from the Cients/Groups screen when you're connected via CAM? The BI user selection window pops up, search for the users in the desired AD and add them to the TM1 Clients. Now all that's left is to set any group assignments (lin...
- Wed Nov 22, 2017 10:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cells not calculating unless edited
- Replies: 7
- Views: 5163
Re: Cells not calculating unless edited
This can also happen when you somewhere have a DBRW formula which points to an intersection in the cube that is not part of the VIEW formula that you refer to in the DBRW.
- Fri Nov 10, 2017 1:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Installation of TM1 Perspectives: Excel crash
- Replies: 3
- Views: 3607
Re: Installation of TM1 Perspectives: Excel crash
Wim, did you run the installer by right-click and then 'Run as administrator'?
- Tue Nov 07, 2017 2:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DimensionSecurity Rules not being fired
- Replies: 14
- Views: 8773
Re: DimensionSecurity Rules not being fired
This is possibly because the rule also applies security to the ADMIN, DataAdmin and SecurityAdmin groups. This cannot be and TM1 does not know how to handle this correctly, leading to strange and inconsistent behavior. Same weird stuff happens when you run a TI process and try to set security for on...
- Tue Nov 07, 2017 11:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem after upgrading from TM1 10.2.2 to 10.3
- Replies: 3
- Views: 2857
Re: Problem after upgrading from TM1 10.2.2 to 10.3
Since TM1 10.2.2 FP6 (and also in Planning Analytics 2.x) there is an issue (IBM calls this a feature) with the StringToNumber functionality in some cases where a specific decimal-separator is defined on the server OS level. This may be the cause for what you are seeing right now. The solution that ...
- Mon Oct 02, 2017 1:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Message on TM1 Web
- Replies: 6
- Views: 5031
Re: Message on TM1 Web
Another option would be to create an additional websheet called 'Access Denied' or something like that. Now, when a user clicks a button, the reference to the websheet is dynamic. In case the user belongs to any of the groups with access to the target sheet, the reference is set to the target sheet....
- Mon Jul 10, 2017 1:48 pm
- Forum: Useful code, tips and tricks
- Topic: TM1 Challenge
- Replies: 5
- Views: 18312
Re: TM1 Challenge
It should not be too hard actually. All the required ingredients are available, just a matter of mixing them in the right manner to get to your required result. With slice and active form you have the DBRW formulas which you can have a look at to determine the dimensions in your 'row columns'. No is...
- Mon Apr 24, 2017 2:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Things I can't do in Performance Modeler
- Replies: 8
- Views: 6144
Re: Things I can't do in Performance Modeler
I take it you are not using TM1 Applications or any of the fancy metrics things then, right?PavoGa wrote:We actually do not allow our development team to use PM. Es ist verboten.
- Wed Mar 08, 2017 12:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: only after ownership at total level in contributor, user can edit in TM1 web??
- Replies: 3
- Views: 2982
Re: only after ownership at total level in contributor, user can edit in TM1 web??
In the }CubeProperties cube there is a measure named DATARESERVATIONMODE. When using TM1 Applications this mode is set to REQUIRED or REQUIREDSHARED by default for each cube that is used in the application. You are free to change this value as you wish. For example, you can set this to OFF to no lon...
- Tue Feb 28, 2017 2:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IF Statement
- Replies: 4
- Views: 3814
Re: IF Statement
Performance wise it might be better to split the IF statement: IF(vAccount @= '620000'); IF(CellIsUpdateable(...)=1); # Do things ENDIF; ENDIF; This way the CellIsUpdateable check is only performed when vAccount equals 620000 and not for every item in your Data tab. Of course the absolute impact on ...
- Tue Feb 28, 2017 1:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to create dimension with multilevel element from cube
- Replies: 4
- Views: 3370
Re: How to create dimension with multilevel element from cube
This happens because the interim level is not year-specific.
- Tue Feb 28, 2017 1:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Deploying TM1RunTI on an ETL Machine
- Replies: 1
- Views: 1822
Re: Deploying TM1RunTI on an ETL Machine
Installing the client software (API in components list) should be sufficient.
Oh and don't forget the SSL certificates.
Oh and don't forget the SSL certificates.
- Fri Feb 24, 2017 7:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DimensionElementDelete performance
- Replies: 14
- Views: 9466
Re: DimensionElementDelete performance
My suggestion is to keep this as simple as possible by using the following code in the prolog of your process instead of using subsets as datasources and using metadata tab to run through them. I estimate this will not take longer than 5 seconds to run. Of course you could perform additional checks ...
- Fri Feb 17, 2017 12:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Real SSO with TM1Web Kerberos/Integrated Login
- Replies: 10
- Views: 7108
Re: Real SSO with TM1Web Kerberos/Integrated Login
Why not use CAM?
- Mon Feb 06, 2017 10:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Please help with Expand Function
- Replies: 14
- Views: 9465
Re: Please help with Expand Function
With EXPAND you:
In case you really really really would like dynamic variable names including dynamic values you're best of building a temporary cube to hold the information.
- can only assign a dynamic value to a variable.
- cannot make the variable name itself dynamic.
In case you really really really would like dynamic variable names including dynamic values you're best of building a temporary cube to hold the information.
- Mon Dec 19, 2016 12:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Send data based on 2 dimensions
- Replies: 2
- Views: 2185
Re: Send data based on 2 dimensions
Try this:
This way you take input hours from the site as stated in the attributes of your cost center.
Code: Select all
['Staff Productive Days'] = N: DB('Input Cube',ATTRS('2_Cost_Centers', !2_Cost_Centers, 'Site'), !3_Month_Year, !4_Version_Final, 'Staff Productive Days', 'Value');
- Thu Nov 10, 2016 11:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SSL Breaks RUNTI - (TM1 API Error) SystemServerClientNotFound Server connection failed
- Replies: 6
- Views: 5202
Re: SSL Breaks RUNTI - (TM1 API Error) SystemServerClientNotFound Server connection failed
Did you perform the client SSL update steps on the server containing the tm1runti.exe?
- Wed Nov 02, 2016 8:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Select an element in an MDX subset whilst keeping others
- Replies: 8
- Views: 5754
Re: Select an element in an MDX subset whilst keeping others
Why not have TI update your static subset so that it will contain the following:
- Current month
- Jan
- Feb
- Mar
- ...
- Tue Oct 04, 2016 8:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder statement not working correctly
- Replies: 4
- Views: 3341
Re: Feeder statement not working correctly
Based on your rule you should feed to the 'Directors' consolidated element of the 'People' dimension in the 'Labour Costs' cube from the 'Plan P&L' cube instead of feeding to !People. Also, please save yourself a lot of hassle by not using spaces or other non-alphanumeric characters in cube and ...
- Mon Aug 22, 2016 2:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Wait:IXCur on user login during TI data load
- Replies: 6
- Views: 5855
Re: Wait:IXCur on user login during TI data load
Yes.4rtem wrote:Can CubeSetLogChanges(vCube,0) drive such behavior?
And also metadata updates may be blocking.