How to create OTBI analysis that will display Assets with their source lines details?
Need to create an analysis that will display Asset info (number, description) with its source lines details (project, invoice info)
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?