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

How to create report in SAP BO using .txt files as data source

Hi,

Can anyone have an idea of using Flat files (.txt file ) as data source in SAP BO 4.0.

Requirement :

I am trying to create a report using two different flat files (.txt file) by join and sum logic. On this regard my source data is .txt files only.

Please advice how can i use .txt (Notepad Files) as data source and with this data source how will create a template.

My end user Template is Emp_Department, DEpartment_id, Salary.

Regards

DSK

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 May 20, 2013 at 06:59 AM

    Hi,

    Add Text files, Change the Qualification as required, Run Queries, Merge Dimension, Display output.

    I have used below data for First text file:

    Name Age Id

    A 10 1001

    B 32 1002

    C 25 1003

    D 15 1004

    Second text file:

    Id Salary

    1001 150000

    1002 210000

    1003 180000

    1004 200000

    PFB Screenshots:

    Add another Text File:

    Hope it helps!

    Thanks 😊


    Step1.PNG (17.8 kB)
    Text as Source.PNG (38.3 kB)
    Step3.PNG (31.4 kB)
    Step5.PNG (62.8 kB)
    Step6.PNG (23.8 kB)
    Step7.PNG (54.5 kB)
    Step9.PNG (51.9 kB)
    Step10.PNG (50.5 kB)
    Step11.PNG (32.1 kB)
    Step12.PNG (23.8 kB)
    Step13.PNG (38.0 kB)
    Step14.PNG (16.5 kB)
    Step15.PNG (37.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 20, 2013 at 06:00 AM

    Hi DSK,

    Use Webi Tich Client, abd choose other data sources while creation, then you can select the TXT file and create a report on that.

    The column header will appear as the dimension names, also the measures aggregation type you can set like SUM,COUNT on the query panel window, which will popup once you slect the TXT file.

    Thanks,

    Avinash

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 19, 2013 at 06:05 PM

    Hi,

    Yes, You can use (.txt) file as Source in Webi Rich Client tool.

    Kindly update, what are the fields/columns you have in the two text files?

    Thanks 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 19, 2013 at 08:57 PM

    Please check section Using a Plain Text File as an Alternative in the below blog. It will help you in creating this.

    http://www.gulland.com/wp/?p=482

    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.