Search found 12 matches

by RonLat
Wed Mar 18, 2020 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Modeler and security
Replies: 6
Views: 698

Re: Performance Modeler and security

Thank you all!

I think I understood the basics. I also solved my little problem by simply deleting the hidden cubes

}ElementSecurity_Dim_A
}ElementSecurity_Dim_B
}ElementSecurity_Dim_C

Now the users in the group have access again.
by RonLat
Wed Mar 18, 2020 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Modeler and security
Replies: 6
Views: 698

Re: Performance Modeler and security

I’m not sure if I understand you right. Once the CubeSecurity is set and I don’t need the element security, should the hidden object }CubeSecurity be deleted? What is with the objects }DimensionSecurity, }ElementSecurity_Dim_A, }ElementSecurity_Dim_B, }ElementSecurity_Dim_C? Should they be also dele...
by RonLat
Wed Mar 18, 2020 7:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Modeler and security
Replies: 6
Views: 698

Performance Modeler and security

There is a cube with three dimensions Dim_A, Dim_B and Dim_C. In the first step the CubeSecurity is set for a certain group to READ. The DimensionSecurity is set for the same group to READ. The user belonging to this group can read the view of the cube. In the next step a right click on the Dim_A an...
by RonLat
Mon Mar 16, 2020 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX connection to TM1 server
Replies: 4
Views: 415

PAX connection to TM1 server

Is it possible to establish a direct connection from Planning Analytics for Microsoft Excel (PAX) to a TM1 server in order to explore the TM1 cubes, or do I need Planning Analytics Workspace (PAW) installed first in order to use PAX with it? This site claims that PAX connects to the Planning Analyti...
by RonLat
Mon Oct 30, 2017 11:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX using TI Parameters
Replies: 3
Views: 1680

MDX using TI Parameters

using a MDX statement, it is possible to create a subset by filtering the values of a cube. However, it is necessary to explicitly name the dimensions and elements of the cube. In my case, the [Period] and [Config_Measure].[Source] are constants in the MDX statement below. I'd like to vary the eleme...
by RonLat
Fri Oct 06, 2017 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI cutting off dimension elements
Replies: 4
Views: 1656

Re: TI cutting off dimension elements

Well, finaly I found the problem. I was looking for ELPARN, ELPAR, ELWEIGHT in the target dimension instead of the source dimension. Thanks a lot for the idea. It's time for the weekend :-) The working code: vDimName = 'Tarif_Test'; vElem = Tarif; vIndex = ELPARN('Tarif', vElem); vParent = ELPAR('Ta...
by RonLat
Fri Oct 06, 2017 2:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI cutting off dimension elements
Replies: 4
Views: 1656

Re: TI cutting off dimension elements

A code modification created the additional element _EmptyParent_, but DimensionElementComponentAdd(vDimName, vParent, vElem, vWeight) still doesn't work (see Dim_Tarif_Plan_3.PNG). vDimName = 'Tarif_Test'; vElem = Tarif; vIndex = ELPARN(vDimName, vElem); vParent = ELPAR(vDimName, vElem, vIndex); vWe...
by RonLat
Fri Oct 06, 2017 1:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI cutting off dimension elements
Replies: 4
Views: 1656

Re: TI cutting off dimension elements

Thank you for the hint. The current code in the metadata tab: vDimName = 'Tarif_Test'; vElem = Tarif; vIndex = ELPARN(vDimName, vElem); vParent = ELPAR(vDimName, vElem, vIndex); vWeight = ELWEIGHT(vDimName, vParent, vElem); IF (SUBST(vElem, 1, 5) @= 'VPPT_' % SUBST(vElem, 1, 3) @= 'PT_'); itemskip; ...
by RonLat
Fri Oct 06, 2017 10:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI cutting off dimension elements
Replies: 4
Views: 1656

TI cutting off dimension elements

Hello, I've got a dimension that needs to be cloned and the VPPT_* and PT_* elements need to be deleted. The remaining structure above should stay the same and the consolidated MPPT_* elements should be changed to leaf elements (see attachment Dim_Tarif_Plan.PNG). Is there a possibility to get it do...
by RonLat
Fri Jun 23, 2017 1:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disabling consolidation in one dimension only
Replies: 3
Views: 1149

Re: Disabling consolidation in one dimension only

Setting the weightings of ElmName against all its ancestors to 0, would prevent the consolidation of ElmName in all dimensions. Now let’s imagine a cube with three dimension: dim1, dim2 and dim3. ElmName is a member of dim1. It is possible to let ElmName to be consolidated in dim1 AND dim2, but NOT ...
by RonLat
Fri Jun 23, 2017 12:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disabling consolidation in one dimension only
Replies: 3
Views: 1149

Disabling consolidation in one dimension only

If the consolidation for an element is to be generally disabled, then a simple C-level rule is sufficient. ['DimName':{'ElmName'}] = C:0; This rule will turn off the consolidation of ‘ElmName’ for all dimensions. Can the consolidation for ‘ElmName’ can be disabled only for one particular dimension, ...
by RonLat
Tue May 02, 2017 8:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Performance Modeler expression syntax
Replies: 1
Views: 916

TM1 Performance Modeler expression syntax

Hello everybody, I’m trying to implement a consolidated-level expression on a dimension using the performance modeler 10.2.2. It works fine for simple formulas. The performance modeler creates the rules and feeders in the cube, according to the dimensional expressions. The problem is with a formula ...