Dashboard in BI Publisher

Question

Summary

Content

Hi,

I am trying to create a Dashboard which includes total 46 Detailed reports and 1 Summary report (which gives summary of all 46 reports i.e. Record Count and total Amount). What would be the best way to achieve this? The Requirement is to have excel output with multiple sheets. so there would be total 47 sheets in 1 excel. Can anyone please share thoughts as to how the design should be achieve this requirement?

Thank you!

Pavan kumar. · Answer

Hi, What would be the best way to achieve this? The Requirement is to have excel output with multiple sheets. so there would be total 47 sheets in 1 excel. Can anyone please share thoughts as to how the design should be achieve this requirement? This requirement can achieve by using Template builder for Excel. 1.Create a Data Model as business requires (I would have assumed it's flat XML data) 2.Design the Layout in the excel for the first sheet (ensure that if any images are existed that would be visible only in the first sheet as oracle is not supported) 3.Set the parameters as required in the XDO_METADATA Sheet and hide it in the sheet to not to see by the report consumers NOTE: As the requirement having multiple sheets, Need to group the data by the parent-child relationship in the XML along with this reason to have multiple sheets enablement we should create pre-processed XSLT file.This file Create Intermediate data from XML flat data into hierarchy enabled data(Parent-child relation).so that it would be enabled in the excel for the multiple sheets to represent the data from the source XML file. 4. In order to get the sheet name as required and what would be the field name we are grouping.To do this need to pass the parameter values in Data Constraints section in the XDO_METADATA Sheet as below: XDO_SHEET_? XDO_SHEET_NAME_? 5.Next need to upload the XSLT file and .xls template files in the appropriate report definition. Regards Pavan kumar