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

how to manualy create SID for infocube while loading data from psa ti IC

HIII frnz

M talking about BI 7.0 extraction,when i load data from psa to infocube one error has came,in dtp it show that error msg is "no SID is created for cube",,so frnds plz tell me how to create SID manualy..

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 04:31 AM

    Did you loaded yours master data first?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 04:47 AM

    Hi rosi

    First u load master data this helps to generating of SID and then after u want to load transaction data

    this helps to no errors occur in Sid generation

    THANKS AND REGARDS.

    RAJASEKHAR

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 05:03 AM

    Hi,

    First of all, SIDs are never created manually. These are created automatically at the time of data load. You are getting this error most probably because you have not loaded master data before loading the transactional data in the cube.

    Hence first load the master data and then try to execute data load for the concerned cube. This would solve your problem.

    Navesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 06:18 AM

    hi

    Whatever the business (HR, FI/CO, SD, MM etc) u use, in SAP BI, it is the best practice to master data first and then the transaction data.

    check this links will help to load master data

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/1049343f-45bf-2e10-a78f-cc60acda867a?QuickLink=index&overridelayout=true

    Loading Master data in BI

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 13, 2011 at 01:02 PM

    Hi,

    SIDs are never created manually.

    They are created while data loading. So in your case see what is error in SM64.

    You can load your master data and activate it and see if error get resolved.

    Go to RSRV and check your cube and master data if you found error with any master data.

    Thanks and regards

    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.