Infosets (NW04s)

[Former Member]

Can an infocube be the right table in a left outer join?

I have a query with 0GLACCOUNT displayes as a hierarchy in rows and I want the query to display the hierarchy node even if no data.

So I created an Infoset with 0GLACCOUNT as left table and the infocube as right table 0FIGL_C10. But I don't get gl accounts with no data.

[Former Member · Accepted solution]

Raynald,

Did you try using the Query properties? In the query , go to advanced tab for the characteristic property. You have options to show the master data, even if the values are not posted.

-Saket