It would be nice to have only the report name without template name as file name which gives a meaning name to the output file name when downloaded.

Yes. That's good to hear. Regards. Chandra.

Hi Karen, You can still use the SQL Query capability in the data model and can create a BI Publisher report. Thanks, Chandra.

https://cloudcustomerconnect.oracle.com/posts/8b5135b142 Future Product Direction Direct database query is not a supported OTBI feature for building reports. Customers are encouraged to use BI Answers to create interactive analyses, use BI Publisher for fixed-format reports and use BI Cloud Connector (BICC) for data…

Yes. Good Idea.

Things to consider when the report is build with more then one subject areas: 1. You should have common dimension in all the subject areas 2. Add Measure/Fact from each subject area on the report 3. In case of unrelated dimensions, apply the "Dimensionality" hint on the OTBI analysis 4. You should consider the possible…

you cannot establish a data link to Oracle BI Analysis Data Sets with multiple data sets created in a data model.

Data links with Oracle BI Analysis Data Sets is not supported. Also, group breaks, group filters and group-level functions are even not supported. Only Global level functions and Setting the value for elements if null are only supported for Oracle BI Analysis Data Sets. Thanks, Chandra.

attachment is missing.

Hi Deepa, Could you provide an example with the difference in output for better clarity on the issue. Thanks, Chandra.

Please check the Doc ID 2230320.1