Categories
- All Categories
- Oracle Analytics Learning Hub
- 27 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 236 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to make Report With Column in Column (Dynamic Columns report) using OBIEE? sample data & report
Hi Guys,
I am really new to OBIEE, Need below report from current data based I have Attached Excel Based Data as well as report required from Same.
Current Data In Excel ...
| Sr. No | Employee Name | Dept Name | No. of Days | Working Days | Leave |
|---|---|---|---|---|---|
| 1 | Mahesh | Account Dept | 50 | 40 | 5 |
| 2 | rajesh | Account Dept | 665 | 400 | 200 |
| 4 | Sham | Account Dept | 30 | 22 | 0 |
| 5 | Mahesh | Finance Dept | 100 | 80 | 0 |
| 6 | Rajesh | Finance Dept | 800 | 650 | 20 |
| 7 | Ram | Finance Dept | 900 | 800 | 1 |
| 8 | Mahesh | Admin Dept | 1000 | 800 | 25 |
| Sr.no. |
OBIEE Report Required :
Is it possible make such report, Basically we have transpose the Dept Column from database, Please help me on this.
Currently RPD file is very simple with one table in all layers (Physical, Business, Presentation layer) ,
Do we need to do any changes in RPD for such report, Or do we have any options for same.like image of report.. Basically no. of columns in final report may increase dynamically if dept increases in base tables.
Please help..............
Answers
-
Employee and Department are dimensions (or dimensional attributes - it really depends on what your source data is) whereas "No of days", "Worked days" and "Leave" are measures.
With a model like that you can create your analysis. Note "analysis" since you asked about OBI here and not "report" since that would be BI Publisher.
You have to use a pivot table and drag the dimensional attribute "employees" into the "rows" and the dimensional attribute "department" WITH the measure label into the "columns" like this:
0 -
Hi,
That's just a pivot. In your analysis select your "employee name", "department", "no of days", "worked days" and "leave" columns and in the result tag use a pivot view and done.
ef767cc8-0e54-4c89-9a86-3428c27bbae8 wrote:Currently RPD file is very simple with one table in all layers (Physical, Business, Presentation layer) ,
That's an issue ...
OBIEE works on models, if you don't model things you can't expect OBIEE to do any magic.
You must have a star schema in the business model, with a logical fact table and a logical dimension table. In the fact you put all the columns which have an aggregate rule on them (your "no of days", "worked days" and "leave"), in the dimension you must have attributes describing measures (your "employee name" and "department").
0
