Two parts of HR Personnel Report

[sachin_v_joshi]

A] To whether an employee is In-Line Manager or not ?
We have an existing Personnel list BO document.
There are columns Personnel ID as well as Line Manager's Personnel ID;
If for any employee,if Line Manager's ID matches with personnel ID, then we need to provide it by char 'X' in that column

How will I achieve this by adding a new colum to indicate whether the employee is a Line Manager himself/herself?

B] Dynamically Adding Columns based on input contol value

In this existing report, in the current format we have
Org Lvl1 ID | Org Lvl1 Name | Org Lvl2 ID | Org Lvl2 Name | Org Lvl3 ID | Org Lvl3 Name | Soon and so forth until | Lowest Org ID | Lowest Lvl Name and rest columns
Now there is requirement from Business user to have input control on Org Lvl ID which user can enter from 1 to max value of say 20 which are existing in current Productiion env.If user chooses 6, then
Dynamically Add columns which would result in below headers
Org Lvl1 ID | Org Lvl1 Name | Org Lvl2 ID | Org Lvl2 Name | Org Lvl3 ID | Org Lvl3 Name | Org Lvl4 ID | Org Lvl4 Name | Org Lvl5 ID | Org Lvl5 Name | Org Lvl6 ID | Org Lvl6 Name and rest columns

If user chooses 12 then,below would be the output of headers
Org Lvl1 ID | Org Lvl1 Name | Org Lvl2 ID | Org Lvl2 Name | Org Lvl3 ID | Org Lvl3 Name | Org Lvl4 ID | Org Lvl4 Name | Org Lvl5 ID | Org Lvl5 Name | Org Lvl6 ID | Org Lvl6 Name | Org Lvl7 ID | Org Lvl7 Name | Org Lvl8 ID | Org Lvl8 Name | Org Lvl9 ID | Org Lvl9 Name | Org Lvl10 ID | Org Lvl10 Name

There are a max of 15 hierarchies present in the current prod system
How to achieve this too ?

[kohesco]

Hi,

I hope these blogs can help you out or inspire you

1. https://blogs.sap.com/2017/08/18/how-to-create-a-search-engine-in-webi/
2. https://blogs.sap.com/2014/05/07/dynamic-visibility-within-a-webi-report/

If questions remain, please ask

Grtz

Koen