For Derived table, i am having one scenario.
My Database table is having following Column
-Empno
-Empname
-Managerno
my Report Requirement is like:
report should display Emp name and its corressponding manager name.
Based on this reqquirement, i need to design Universe.
My steps would be like this:
1.Looking at the requiement, i would go for Derived table, having name Manger.
Derived Table(Manager) would be having following syntax.
select distinct a.EmpNo,b.EmpName from Emp a,Emp b
where a.ManagerNo=b.EmpNo
2. Joining
2. Create class Manager and Object Manager Name, Source for this object would be
Derived_table.EmpName that is manager. EmpNo. Here EmpNo is coming from Derived table syntax.
Now my universe is ready.
As per the repoer requirement i can create report.
So Bottom line is Derived table plays a major role in this scenario.
|
