Oracle fusion subject areas
Hi Friends , In this post , We will discuss about Oracle fusion subject areas. Oracle Fusion has given the Subject Areas for each module and Under These subject areas we have different business objects . These Business Objects having all the Information's about that Oracle Fusion Modules and by which we can just drag and drop the columns from these business objects and design the OTBI reports without writing any SQL query. This is the good part of the Oracle fusion subject areas. OTBI reports automatically creates all the sql query to design the OTBI reports.
For Example : Oracle Fusion has given many subject areas for Financials , but we need to identify the exact Subject area as per our Requirment and under this Subject area we need to identify the right Business Object which have all the required columns on which we want to design the OTBI reports.
In this example I am going to Create Analysis on Payables AP invoice data for that I will select Payables Invoices Subject Area.
Step9:- If you want to change the name of columns you can do by that way. click on the column Circle.
Now we will create Filters in the OTBI reports.
Step7:-
This is the Development window of OTBI reports.
Selected columns:
'Selected columns' represents Columns which you want to include in your Report output.
Filters:
Filters represents where conditions in this OTBI report.
You will drop the Columns from the subject areas in the left side.
You can see in the left side subject area and the sub folders. Each subfolders has information related to AP invoices. Like Accounting folder have accounting information. Invoice Details folder has Invoice number , invoice description kind of information.
Step8:- I have Drag Invoice Number and Invoice Amount from Subject area to the Selected Columns as below.
Then these are two columns will come in this report output.
Now we will create Filters in the OTBI reports.
Rest of the steps is in Second Post as below
0 comments:
Post a Comment