Represent a database view as an entity for reporting?

I have a stored view in my database (Oracle) that I want to use as the basis of a report. How do I create a Cuba Entity that:

  1. does not have an ID
  2. is read-only

Alternatively, how do I access my view to do reporting using the Reports interface in the platform?

Hi Eric,

You can create a report, that uses SQL dataset. SQL dataset directly accesses your view in DB. You can see an example of SQL dataset in Library Application for “Books by author” report.