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.
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.