How to count unique records in Learning solution

[Former Member]

Hi BW experts,

I am using SAP Learning Solution. Using datasource 0HR_LSO_1(Participation) I have pulled data to BW side. I have a requirement where my user wants to see the number of employees who have gone training for that particular year (irrespective of the number of trainings). So basically what is needed is a training flag whose value willl be 0 or 1 (depending upon whether a minimum of 1 training is attended) for that particular year. Is there any existing KF or formula in the transformation or do I have to write a routine for the same? Please help if any other alternative is available.

[former_member182343 · Accepted solution]

Dear Soumya,

You can achieve your requirement through multiple ways: either through Transformation by wring Routine and populating count.

- Through exception  aggregation at Bex end and get count.

Better get at end without changing modelling.

Best wishes, Vijay

[Former Member]

Hi Guys,

Thanks for your help. Got a turnaround for the problem without routines or exception aggregation. Put a 2 DSOs before between the cube and datasource so that only 1 record exists for a particular employee. Thanks for your help anyways.

Regards.

[former_member182343]

Dear Soumya,

Pl. close the thread, if you have got desired solution.

Best wishes, Vijay

[MGrob]

Hi

Write a routine in your transformation setting the result to either 1 or 0 if the learning condition is met or not. Use that keyfigure later in your bex query as your count.

hope that helps

Martin