Data grouping in Excel output format exports from OBIEE / Publisher 11.1.1.9
Hi Guys,
I have a customer requirement where I need to produce Excel reports from OBIEE / BI Publisher where the Excel format includes grouping of several rows that users can expand (clicking on the plus sign) if they need to get further detail on a specific record.
I know that we can export OBIEE / Publisher reports into different Excel tabs by using templates in Publisher but have not found a way of getting this specific data grouping.
Any suggestions on how I can achieve this ?
Thanks in advance.
Regards,
Mario