Need help with a joined data source

[Former Member]

Hi All,

I am trying to create a data source, and eventually a report, which shows all the buying center relationships for a Parent Account and all it's Child accounts.

I think i'm supposed to create a joined data source using buying center and account master data, and join it on Name (= Account Name).

Then I would present a selection to the user to enter the Account Master Data Parent Name and then it would join to buying center and show all relationships where the Account = (selection), and the relationships where the Account is a child account of that Parent.

I tried to do this (below) but when I create the data source all I get is the Name key figure, nothing else

Data source

any advice is appreciated, thanks in advance

[surjeetbhati · Accepted solution]

Dear Sandico,

Instead of Inner Join make it Left outer join and change the access context to account master data, you will be able to view report as desired

Refer below screenshot for reference

Regards,

Surjeet Bhati

[Former Member]

Hello Sandico,

Irrespective of which kind of join you take, inner or Left Outer. You need to select all the characteristics (apart from caractéristics you want to join) when adding the data source in this table.

Regards,

Saurabh

[Former Member]

Thank you both, it is working better now. Now I just need to validate the output.