Blog

In this article, we will see an worked out example, to generate a password protected excel output using BI Publisher

1. create a data set to fetch data
2. define output & delivery options in a bursting query
3. save data model & reports
4. Set the report parameters – Excel 2007 output, as shown below