Skip to Content
author's profile photo Former Member
Former Member

BI LSO - use of business content: problem and limitation

Hi,

we are working on BI to develop some reports from LSO data. We are using 0HR_LSO_1 and 0HR_LSO_3 for participation and resource reservation and a lot of custom datasources from infotype 1001, 1000, 1042, 5007, and so on.

We have met lot of problem in modelling a simple and flexible BI data model, because of lack of information from business content and time dependent maintenance of many information.

Just to report few of the problem we have, we notice that

1. no link between EK and D object is extracted by standard datasource, so no information is there if a D as been attemped as a single course or as a course between several from an EK object;

2. no master data is there for the 0LEARNER characteristic and no link is there with 0EMPLOYEE to better describe P object; if participant is not a P object, you don't have any information about it (!);

3.no master data is there for the 0TRAINTYPE characteristic; we needed to add lot of information to better describe the D object (!);

3. presence of 0TRAINGROUP in participation datasource may cause doubled of information (doubled count of participation) if D object is located under several L object in ovelapping time interval;

3. resource reservation datasource is not able to extract data if resource type is not defined in LSO;

4. performance is quite poor caused by lot of calculation doing by FM "read_infotype_1001" type;

5. no pre-enrolment is considered in business content;

6. no link between resource and participant is there, so you cannot provide any report of type "who partecipate to the edition with this reource type" in a simple way;

...

We have to develop lot of custom to handle lot of problem like those; so I would like to share experience in BI LSO data flow design and development: please let me have your observation.

thanks in advance.

L

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 11, 2011 at 09:02 AM

    Any experiences / contributions / documentations to share ?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.