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

post regarding master data

Hi All,

I have a few questions regarding BW:

1) how does a client upload master data from a local work station into an application server?

2) Generally, if we load master data into the master data table, the SID table and text table automatically gets populated. My question is, what if master data is loaded into the text table and not in the master data table.

3) The last one is, o what basis generally an Info cube is maintained in BW?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

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

    Hi,

    1) how does a client upload master data from a local work station into an application server?

    There are many FM's and programs available to load data on applicaiton server from local workstation.

    2) Generally, if we load master data into the master data table, the SID table and text table automatically gets populated. My question is, what if master data is loaded into the text table and not in the master data table.

    When you load master data only SID table gets populated and not Text table. You will have to load text manually. And if you load text before master data then also it will be used in reports only when proper master data is present.

    3) The last one is, o what basis generally an Info cube is maintained in BW?

    Whereever we need reporting we generally creates infocubes and multiproviders.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Durgesh,

      Thanks so much for that reply. I am very new to this BW so can you pls tell me what is this FM you told me about in the first answer. And moreover, my criteris is that client is sitting in US, she is uploading the data in to the application server from her local work station.(scenario).

      Regarding the maintenance of the Infocube, i need the factors upon which a cube is maintained. Not the necessity.

  • Posted on Dec 09, 2011 at 07:59 AM

    Hi,

    You need to carry out data loads separately for master data and text data table. SID gets generated once you load master data or transaction data wrt any Infoobject.

    Text will populate only when you will load text data into text table of the object.When you are loading text for certain objects defintely you will have transaction data available for these objects which will generate SID.

    can u elaborate your last question plaese?

    it depends on your report design.what you need whether it is on two functional ares say MM,SD you need Multiprovider as well.

    How much data you have in warehouse..

    Thanks and regards

    Kiran

    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.