Search found 77 matches

by pandinus
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: 4267

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...
by pandinus
Wed Nov 22, 2017 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cells not calculating unless edited
Replies: 7
Views: 5005

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.
by pandinus
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: 3379

Re: Installation of TM1 Perspectives: Excel crash

Wim, did you run the installer by right-click and then 'Run as administrator'?
by pandinus
Tue Nov 07, 2017 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionSecurity Rules not being fired
Replies: 14
Views: 8570

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...
by pandinus
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: 2812

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 ...
by pandinus
Mon Oct 02, 2017 1:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Message on TM1 Web
Replies: 6
Views: 4967

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....
by pandinus
Mon Jul 10, 2017 1:48 pm
Forum: Useful code, tips and tricks
Topic: TM1 Challenge
Replies: 5
Views: 16984

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...
by pandinus
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: 6101

Re: Things I can't do in Performance Modeler

PavoGa wrote:We actually do not allow our development team to use PM. Es ist verboten.
I take it you are not using TM1 Applications or any of the fancy metrics things then, right?
by pandinus
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: 2955

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...
by pandinus
Tue Feb 28, 2017 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF Statement
Replies: 4
Views: 3788

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 ...
by pandinus
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: 3347

Re: How to create dimension with multilevel element from cube

This happens because the interim level is not year-specific.
by pandinus
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: 1808

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.
by pandinus
Fri Feb 24, 2017 7:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionElementDelete performance
Replies: 14
Views: 9383

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 ...
by pandinus
Mon Feb 06, 2017 10:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Please help with Expand Function
Replies: 14
Views: 9420

Re: Please help with Expand Function

With EXPAND you:
  • can only assign a dynamic value to a variable.
  • cannot make the variable name itself dynamic.
edit:
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.
by pandinus
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: 2182

Re: Send data based on 2 dimensions

Try this:

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');
This way you take input hours from the site as stated in the attributes of your cost center.
by pandinus
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: 5696

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
  • ...
by pandinus
Tue Oct 04, 2016 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder statement not working correctly
Replies: 4
Views: 3314

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 ...
by pandinus
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: 5787

Re: Wait:IXCur on user login during TI data load

4rtem wrote:Can CubeSetLogChanges(vCube,0) drive such behavior?
Yes.
And also metadata updates may be blocking.