TM1 Forum

Ist there a rule that can find a previous date?

For example on 28 Feb 2023 the previous date would be 31 Jan 2023.

I have a filter on the dimension [investmentID], that shows me all Investmentelements with an attribute "creation_date" = "2022". {FILTER(TM1SubsetAll([investmentID]), ([investmentID].CURRENTMEMBER.PROPERTIES("creation_date") = "2022"))} I can get the year 202...

There is a workaround regarding this problem and it is described only in one place on the internet. IBM Framework for Office and PAfE 2.0.66 installs. https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?MessageKey=3ce54d24-904b-4fa7-bb3f-3a77...

I tried to check, what COMAddins are installed on my system. Sub refreshData() Dim var1 For Each var1 In Application.COMAddIns Debug.Print var1 Next End Sub Result Microsoft Power View for Excel IBM Framework for Office IBM Planning Analytics for Excel Addin Microsoft Power Map for Excel IBM Plannin...

Environment Microsoft Excel for Microsoft 365 MSO (16.0.13127.21210) 32-Bit IBM Planning Analytics for Microsoft Excel Version 2.0.68.4 Aktive COM-Add-In: IBM Planning Analytics for Excel Addin Aktive COM-Add-In: IBM Planning Analytics for Excel Addin (Custom Task Pane Helper) What I tried so far: ...

There is a function in PAX that allows to refresh the DBRW formula in a excel worksheet using VBA. Preparations The file CognosOfficeAutomationExample.bas is imported into the VBA project The file CognosOfficeMessageSuppressor.cls is imported into the VBA project PAX is connected to the TM1 server A...

In TM1-Perspectives there is a possibility of using the user defined consolidations. This is a subset that contains other subsets as elements and can be used as an argument in a DBRW formula. This does not work in Planning Analytics for Excel (PAX) anymore. Is there a practical solution to this prob...

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.

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...

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...

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...

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...

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...

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...

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; ...

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...

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 ...

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, ...

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 ...