Thanks Stuart..Yes i removed the screenshots..thanks for pointing that..
Thanks for your pointers on rule documentation and a solution approach.
I am trying to use the manager flag and then if it is a 'Y', then add a 1 to consolidation..I used below formula but for some reason I am getting 2's in all the cells but it did add 1's to C level elements
# ConsolidatedCount( 2, 'Head Count Plan New', 'EXCEL', 'ACTUAL',!Global Leader_New, 'TI Alloc Participant', !Geography_New, !Time, !Job Category New, !Department_New, !Entity, !Employee_New, 'MTD')+1,'TI Alloc Participant');
------------------------------
Venkata Nori
------------------------------
Original Message:
Sent: Fri July 19, 2024 11:23 AM
From: Edward Stuart
Subject: adding a '1' to all the consolidations
Be sure not to reveal sensitive information and redact names from any screenshots
There are a lot of ways to get around this requirement but a carefully crafted C level rule could work. Something that could check if the C level contains child elements.
If you have not already then (re) familiarise yourself with how rule statements are generated:
https://www.ibm.com/docs/en/cognos-tm1/10.2.2?topic=data-guidelines-writing-tm1-rules-statements#tm1_dev_adcal_Guidelines_WritingTM1_Rules_Statements
You could check if a numeric element (e.g. headcount/ FTE) at the consolidation level is greater than 1 then populate a new element (for example 'Manager') with 1 via a rule
------------------------------
Edward Stuart
Original Message:
Sent: Fri July 19, 2024 11:05 AM
From: Venkata Nori
Subject: adding a '1' to all the consolidations
there is a manager flag. so whereever the flag says 'Y', I am trying to add a 1. The way the source file show data is such that there is a blank cell next to every manager name which means the record is the manager or leader himself
------------------------------
Venkata Nori
Original Message:
Sent: Fri July 19, 2024 11:01 AM
From: Venkata Nori
Subject: adding a '1' to all the consolidations
I get the file in .csv format. Source data is all about employee headcount and their leadership information..I have dimensions like geo,dept,entity,date,accounts,job category, time.. I have little experience in MDX and hence trying to use rules. So the thing is at every consolidation I need to add a 1 so that a manager at a level get added to the total count..My file has an unbalanced hierarchy or ragged hierarcy..I use dimensionelement insert and dimensionelementcomponentadd when forming hierarchies
------------------------------
Venkata Nori
Original Message:
Sent: Fri July 19, 2024 09:08 AM
From: Edward Stuart
Subject: adding a '1' to all the consolidations
Can you be more specific about the source data and if it is held in a cube?
You could use MDX, Zero Suppression, add a new measure with a C level rule to identify and count the managers or use a TI to loop the dimension and output counts
Are there 6 levels in the organisation structure? Do you want to count managers of managers?
------------------------------
Edward Stuart
Original Message:
Sent: Thu July 18, 2024 01:27 PM
From: Venkata Nori
Subject: adding a '1' to all the consolidations
I have an employee dimension hierarchy where there are around 6 levels in the hierarchy and each employee is rolled-up at different levels of managers..
There is a requirement where I need to show employee counts under each manager. For this, at the total consolidation I need to add the counts of all the managers themselves (there is a manager flag). How do I accomplish this?
The source file I receive has a blank space next to every manager other than direct reportees for the reasons I believe is because they want to show the manager record by itself
------------------------------
Venkata Nori
------------------------------