Infosets and joins?

[Former Member]

Hi,

I have requirment where the data is coming from master data and that is Competatiors data it includes all business partners,competitors opporunity id etc and there is a key in info object called opporunity new which is acting as key for the infocube.our intention is to put the report with all the details like end customer,customer,short titile..(coming from cube) competitators, business partners (coming from IO) in the form of report where the for each opportunity ID the number of competators will be displayed.along with the all the other details mentioned.We worked with a multiprovider but we were not getting the data as per our requirment so planning to implement a INFOSET please help me how the joins can be seletected so that I get a data as explianed above.

<removed by moderator>

Thanks,

Ravi

Edited by: Siegfried Szameitat on Feb 24, 2009 12:27 PM

[Former Member · Accepted solution]

if infoobject mentioned over here is included in your cube then use the attributes of this infoobject (i.e.competitators, business partners) directly in the Report.... these attributes will be available with characteristic in the report

[Former Member · Accepted solution]

I want to if I use the IO (having Navigational Attributes) then I have to seperately add those master data (IO) into the Infosets definition right? and how the joins should work?

[shanthi_bhaskar · Accepted solution]

Hi Ravi,

Please go thr these below "How to Join".

http://www.techonthenet.com/sql/joins.php

http://www.w3schools.com/Sql/sql_join.asp

bhaskar

[Former Member · Accepted solution]

When I execute the query I am Error while reading data; navigation is possibleCan any body help me.