BIP (OBIEE 11.1.1.7.0): Group Left Report in Excel Template
When the data model has say a parent group and child group, it's straight forward to create a "Group Above" type report using Template Builder in Excel Template. This is explained well in the Report Designers guide.
What the user wants is a Group Left report so that the data is structured as a flat table.
Dept Emp Id Emp Name Salary
Administration 200 Jennifer Whalen 4400
Marketing 201 Michael Hartstein 13000
Purchasing 202 Pat Fay 6000
Purchasing 116 Shelli Baida 2900
Purchasing 117 Sigal Tobias 2800
In above example, the outer group is Dept and all employees in that group are repeating. But, when there's more than one employee, I want the Dept to repeat also. In above example, "Purchaing" is repeating for each employee belonging to purchasing.