How to create OTBI analysis that will display Assets with their source lines details?

Summary:

Need to create an analysis that will display Asset info (number, description) with its source lines details (project, invoice info)

Content (required):

When creating an OTBI analysis using Fixed Assets - Asset Transaction Real Time subject area, I am only able to display either data for column Asset number/description or Asset source lines (Project Name/number columns) data separately from asset number. As soon as I add all those columns in the same analysis, I get "No Results" message in the Results tab.

Are there any additional steps required to link the two parts together within the same subject area?