What Is a Data
Model?
A data model is an object that
contains a set of instructions for BI Publisher to retrieve and structure data
for a report. Data models reside as separate objects in the catalog.
At the very simplest, a data
model can be one data set retrieved from a single data
source (for example, the data
returned from the columns in the employees table)
The data model editor is the tool for building your data models.
In this blog you will come to know how to create data set using SQL
query in data model. To create report we must have data model that should
contains minimum one data set.
Open Oracle BI Publisher with your credentials
Click New -> Data Model
Click New Data Set -> SQL Query
Give name to the data set
Select data source from the drop down
Write the
query in the SQL Query window
Click ok
This three are mandatory one, after you clicked ok
data set will be created
Click Save
If you need you can add description its optional
one.
Finally data model is created. In my next blog I
will show how to create report by using this data model
No comments:
Post a Comment