TM1 Forum

Hi, why do I see this message (Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread) for some cubes while running the model? For example: 6644 [] INFO 2025-05-25 19:29:36.668...

Hi. I have the next cube view with dims Context: Period; Rows: A, B; Column: Rate; Zero supression enable. This is a test cube to demonstrate problem. https://i.ibb.co/12KBNj0/image.png I want for slice [Period].[~AnyPeriod~] + [A].[A_C] show only [/B].[B_C] element (without B_N_*_*). In other cases...

Hi. I need your advice on the next problem. I have a cube, with dimensions: Years (Year_Total - consolidation; Year_17, Year_18... - numeric) Period (Select level-0 subset) Rates (R1, R2, R3, R4 - string elements) Look at the screenshots below. The user can set the Rates values ​​for specific elemen...

Can you try ? Except( Filter([Departments].[Departments].Members, [01_Confirmation].([Stages].[Stages].[ST_01]) = "Confirm"), TM1FilterByLevel( Descendants( FILTER( Filter( [Departments].[Departments].Members, [Departments].CurrentMember.Properties("ELEMENT_TYPE") = "3"...

Hi! I need help writing a correct MDX query to solve the following problem. I have a cube 01_Confirmations with two dimensions: Departments, Stages. Departments dimension structure: -Dep_head (Consolidation) --Dep_01 (C) ----Dep_01_01 (Numeric) ----Dep_01_02 (N) --Dep_02 (C) ----Dep_02_01 (N) ----De...

Hi, Assume this is a Typo because Admin is missing an apostrophe? [Rates:{'R1', 'R2'}] = S:DB('01_Approval', !Year, !Period, 'Admin, !Rates ); The following will feed itself, so for example User_2 r1 would feed User_2 r1, which obviously wouldn't work. ['Rates':{'R2', 'R1'}] => DB('01_Approval', !Y...

I tried following idea. Cube 01_Approval_General: FEEDSTRINGS; SKIPCHECK; FEEDERS; [Rates:{'R1', 'R2'}] => DB('01_Approval', !Year, !Period, 'Admin', !Rates); Cube 01_Approval FEEDSTRINGS; SKIPCHECK; [Rates:{'R1', 'R2'}, '}Clients':'Admin'] = S:DB('01_Approval_General', !Year, !Period, !Rates); [Rat...

If this wasn't a control dimension; you could add a consolidation to the }clients dimension and feed that - feeding a consolidation is essentially just shorthand for feeding every N-level element under the consolidation. However, I would not recommend it with a control dimension (you can add consol...

Hi, To me it wasn't clear why the "01_Approval" cube even needs the }Clients dimension? Maren Hi. In this case, it is assumed that the 01_Approval_General cube is filled by one employee (administrator/head manager/other). Next, the Rate values ​​(R_01, R_02) are transferred to cube 01_App...

Hi all. I'm new to IBM TM1, I've been working with it for a little over two months. I solved past problems and difficulties by reading IBM documentation or viewing topics on the forum. Please help me solve the following problem. I have two cubes 01_Approval and 01_Approval_General. Cube dimensions 0...