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

How to find the right primary key for DSO from Business Content

According to best practice design, it is reccomended to make a DSO where all fields from Business COntent Datasources are transferred.

But, how to find the right primary indeks ?

Any good suggestions ?

For many of the Business Content dataflows there are not DSOs present, so ther e is no tip to get from the dokumentations as gfar as I have found.

best Regards

Ingrid

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 02, 2008 at 10:11 AM

    Hi,

    depending on your datasource, identify the source tables in your source system and apply use the same keyfields.

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you Siegfried,

      but sometimes it is not a table which is the source, but a view or a structure.

      Maybe the Business Content people should dokument it in the Business Content Documentation og the datasource.

      Ingrid

  • author's profile photo Former Member
    Former Member
    Posted on Apr 07, 2008 at 07:16 AM

    Ok Ingrid ....the DSO objective is maintain the TRNSACTIONAL data (it means documents) at lower level in BI, infocubes are structures that not allow a line actualization...by example if you need to maintain a infocube with invoices....you must use a DSO because in certain moments you may try to update a single document, the DSO update records when find another record with the same key....the key in this case would be the document number....

    If you do not are interested in maintain the data at document level you must use an infocube....DSO are not obligatory for all the cases....

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In case you are using a view, then the selection condition that you specify in the view will tell you what the primary key should be.

      Say for example you are using the join condition in the view with say Kunnr. Now, kunnr will become the primary key.

  • author's profile photo Former Member
    Former Member
    Posted on Apr 02, 2008 at 10:25 AM

    Hi,

    if you are installaling business content, why you need to think about key fields? it will automatically take care..!!

    But if you wanted to create custom DSO, always keep primary keys in key fields in your DSO..

    cheers,

    VSN.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 28, 2008 at 10:32 AM

    Well no easy way it seems. In some cases we have just inserted one single field in the key area, and makes sure it is always getting a unique GUID.

    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.