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

Loading data from Flat File to SAP BW

Hi All

I am working on SAP BW 3.5 Version

  • I activated Business Contents for Sales and Distribution (SD) Module from SAP R/3 System

Data Source

Description Name of the Data Source

Sales Order Item Data (As of 2.0B) 2LIS_11_VAITM

Sales Order Header Data (As of 2.0B 2LIS_11_VAHDR

Billing Document Data: Items (As of 2.0B) 2LIS_13_VDITM

Billing Document Header Data (As of 2.0B) 2LIS_13_VDHDR

for this Standard Cube is

Info Cube 0SD_C03 Sales Overview

and for Extra Modification I Created one Customised Cube that is

Info Cube ZSD_C03 Sales Overview Detail

in this Cube I am using Standard Objects only.

now my Requirement is I need to add extra Customised Objects and load Data from Flat File Source System. That object are;

Product Group - (attribute) we need maintain in 0MATERIAL ID

Projection Value - (Key Figure) also.

now my Question is * What is Procedure for this Requirement in BW 3.5 *

Please let me know, because it is urgent Requirement.

I will Provide full points.

thanks in Advance

Suma

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 07:40 AM

    Hi SKR,

    For loading data from Flat File you have to create update rules for the same customised Info Cube.and The Info Source should be select as Flat File... source system.then only you can load data from Flat File.....

    For this you ahve to create Transfer and Communication structure..

    For adding Prod grp you ahve to maintain in 0MATARIAL object.

    Let me know details....after you did the above process..

    Reg

    Pra

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi Prakash

      what ever u said that is right, but Product Group is a Master data,that Object I need to put in 0Material Dimension.

      and I need to Load Data for Projection Value (Key Figure) also, both Product Group and Projection Values are Customised Object Only

      Based on this please let me know

      thank u

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 07:08 AM

    Hi SKR,

    If u know the extract structure(File structure how u will get to load the data) then u have to create a DS in BW by using that strucuture and the remaining will be the same......

    First create the cube and then the IS and assign the DS to that info source.... Give the update rules and create info package to that DS and give the file location and load the data....

    Assign points if it helps........

    Khaja

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 07:46 AM

    Hi SKR,

    It is normal procedure for Flat file loading.Here maintain DS,IS,IP for Flat file and assign IS for zsd_c03 infocube and make separtate update rules for them.

    It won't make any problem

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 11:14 AM

    Assigning points in SDN is the way to say thanks... Just login in your id and go to the post, there you can find the points in the left side... there you can assign the points...

    Gattu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 07:23 AM

    Suma,

    The procedure is one and the same, how you load the data from a flat file. In your case you need to create the Infosource to upload the data from flatfile with the same communication structure. Once after that, you need to create the Update rules to your customised infocube based upon the newly created Infosource. ONce after that, create the infopackage and load the data...

    Hope you understood the process..

    Regards,

    Gattu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 11:12 AM

    Suma,

    Let me tell you in a clear way,

    You have the customised cube and if you want to enhance the cube with two jmore objects then you need to delete the data from the cube first and then you need to go to the change mode of the query, there just insert your object under the dimension (Product Group) and the keyfigure under the keyfigure area. Now activate your cube and then create the update rules for the same and schedule the data from the Info Package.

    Hope its clear now...

    Gattu...

    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.