Fix report headings and variable body
I just had a customer requirement who wants for reports with a lot of rows that the headings stay fix while the real report can be scrolled user-friendly as you like it. As far as I know (and I double checked with @lex and Christian) there is no out of the box solution for this so I did my Wicky kind of thinking and thought about trying to do it with iFrames and Go URL functionality.
So, here we go. The first thing you need is a simple table view report with a lot of rows - let's say more than 200, then it really makes sense. If you have done so get the URL of your report and add a narrative view to it, where you apply the iframe and paste the URL of your report to. For getting the URL you of course need to save the report first.
So your first narrative view could look like that:
<iFrame src=http://obiee_se:9704/analytics/saw.dll?Go&Path=/shared/Blogs/Fix%20Heading%20variable%20report%20body&Action=Navigate&ViewName=tableView!1 scrolling="no" width="800" height="35"> </iFrame>
If you take a look then you will recognize that I selected only the table view and adjusted the height to only 35 points - even just enough to show the column headings. If this value is not good for you play around with the height until you have your perfect value. And I also have hidden the scrollbar for the column headings by adding the option scrolling="no" to the iFrame.
WOW: only the "native" names of views like in the XML described can be accessed via Go URL, like tableView!1, pivotView!1, compoundView!1 and so on.
After you are done with the first report add another narrative view to your request, in which you show also the table view, but in this case completely. This in the end means that you have the column headings two times. Surely it is not perfect, but at least a good start.
Now you can place the report two times in a dashboard, as first view take the compound View, where you have title and narrative 1 view in and as second view the narrative 2 view. Or you can put everything in one compound View - it's like you like it.
Be aware, that the size of the windows will not correlate to your browser window, it will stay the size you defined in your iFrame. Also, be aware, that you have to pass all parameters in saved filters to this Go URL with the syntax described by my fellow blogger here.
Have fun and so long,
Andreas