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

how to get data in a line in reporting from 2 data sources

Hi

my infocube gets data from 2 datasources and once the data is loaded into infocube , its show the data from 1st datasource in one line and shows data from 2nd datasource in second line

my requirement is to show the data in reporting in a single line

EX: my first datasource has----


personnel no,name,age,position count

my second datasource has----


personnel no and salary

now i want all these fields in a single line in my Report

Regards,

Swamy.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2009 at 11:12 AM

    Hi Narayana,

    U can't achive the output in a single line by directly loading two datasources into the infocube.

    If two datasources have same characteristics and if u show same key figure then they will come in single row ...when characteristics differ they will come in seperate lines

    u can load the sec datasource to another dso and make a look with personnel no in the first dso to cube transformation then u can achieve it ....

    Regards

    vamsi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      one infocube with personel no, age ...etc

      another dso with personel no and salary.

      Create an infoset between them using personnel no as the join condition..

      now you can report all in one line using the infoset

      Rgds

      amit

  • author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2009 at 11:03 AM

    Hi,

    There's a quick solution to fic this in the query. Add infoobject name and age to key figure salary and set them to 'constant selection'. That should do the trick.

    Kind regards,

    Alex

    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.