If you use Brio to develop reports and save the file multiple time's you may have noticed that the file have grown huge over a period of time, and hence takes a long time to save. To reduce the file size, follow the below steps:
Warning: You will temporarily lose all data saved in the report (ie; generated report). Please don't try if you cannot generate it back and this data is important
Warning: You will temporarily lose all data saved in the report (ie; generated report). Please don't try if you cannot generate it back and this data is important
- Open the bqy file in hyperion interactive reporting studio (I have tied this on 11.1.2)
- File --> Save Options --> Save Query Results with Document
- A small popup will open. In the left box that say query results, uncheck all boxes and hit OK
- Save the document. Now if you see the file size, it will be much smaller
- Close the report (or if you want, you can close the hyperion interactive reporting studio itself)
- Follow the below steps if you need to save the data as well
- Re-open the bqy report
- Process your report again so it will generate results
- File --> Save Options --> Save Query Results with Document
- A small popup will open. In the left box that say query results, check all boxes and hit OK
- Save the file
- You should have the data back, and the file size will be still much lower
No comments:
Post a Comment