Result Coming in Two different lines

[Former Member]

Hi all ,

I am building a Multiprovider on a ODS and an Info object , when I select the Attribute of the Inforobject which is characteristics I get two different lines , I want to see the result only in one single line.

is there anyway of doing it , I am aware that this is a Property of MP but is there any workaround.

Thanks in advance for the help.

Regards

Vishu

[Former Member]

Hi Raj ,

Thanks for the reply , It is not the text and the key ,

Its is becasue of the charcteristic which is missing in the ODS so it is creating another line .

Thanks

Rao

[Former Member]

infoset will solve ur problem

infoset is intersection and mp is union

so u will get 2 lines

if u create infoset u shuld get 1 line

[Former Member]

In addition to that you can also use a setting called constant selection in the Multiprovider. If you don't have a complicated query, this constant selection works great.

check this link.

thanks.

Wond

[rajkumar_kandula]

Hi Visweswara Rao,

I think that infoobject is master data infoobject. If it tis correct, then in query designer goto its properties and then select Only Text or Key, this will you the output in single line.

Revert me if you still have any doubts....