I ran into a quirky issue with Briefing Books the other day that I hadn’t noticed before, and the behavior wasn’t readily obvious to me at first. Maybe it has always worked this way – I haven’t had to use Briefing Books much in the past. But I also didn’t find much online, in MOS or the user doc to indicate the behavior that I found.
I’m using OBIEE 220.127.116.11.5 in this case, and unfortunately haven’t tried it on a different version yet to see if its unique to this particular version or not. Please leave a comment below of your own findings if you try the same thing on a different version.
Here’s the simple scenario. I have a BI Analysis on a dashboard page, with that analysis using the default “show the first 25 rows” setting:
I added the dashboard page (that this analysis is on) to a Briefing Book. And at first, I selected “Snapshot” for Content Type:
I also verified that since I was printing the entire dashboard page to the Briefing Book, I updated the Print Rows to “All” in print properties inside: “Edit Dashboard” –> “PDF and Print Properties…” For safe measure, I also applied this same print setting to the table view in the BI Analysis itself that is placed on the dashboard page (so I had Print Rows “All” in two places):
And, as I had expected, when I generated the PDF for the Briefing Book, I saw all rows (more than 25) in my output all the way down to the Grand Total line:
I then realized that I had my Content Type value set wrong in my Briefing Book… I actually wanted the data updatable instead of a one-time static snapshot. So I updated the value accordingly:
SIDE NOTE: In my case, I actually ended up in my tests creating a brand new briefing book from scratch. I think I kept running into another separate issue or bug. It seemed to be related to updating the Content Type setting for an existing briefing book object when I was also updating the Print Rows value. So I couldn’t consistently seem to get an existing book to update to the new viewing definition, and I just started with a fresh briefing book definition each time.
When I started testing my new “Updatable” briefing book, however, the output only showed the first 25 rows, even though my Print Rows were still defined to “All” for both the dashboard page and BI Analysis view definitions. Hmm… I didn’t expect that:
So is that the designed and expected behavior? If so, I couldn’t find it anywhere in the user doc, MOS or a forum/blog online indicating it was supposed to work this way. So this is what I found:
- “Dashboard page Print Rows: All” for Snapshot briefing book does print all rows
- “Dashboard page Print Rows: All” for Updatable briefing book does not print all rows
I personally expected it would work the same way as Snapshot worked, but maybe since it’s an updatable view of data, the design thought is to keep the overhead lower by only showing what you’d show to a user in the online viewing of the dashboard page? Not sure. Oh well.
So here was my solution; er, workaround rather…
I bypassed the issue by explicitly indicating the number of rows for the table (or pivot table) view to show. So in the properties for the view, I updated “Rows per Page” to a value greater than 25 and to a value I don’t expect the analysis to exceed:
And now my updatable briefing book renders all the rows (up to 100) and doesn’t show the “Rows 1 – 25” at the bottom:
To me, it’s not a really great work around as I might have wanted to keep the lower number of records for when viewing the dashboard online, and only deliver a PDF book of all rows. But for this particular instance, it’s fine for what I needed.