Scrolling Pivot table issue

Question

Hi All,

Currently building a Dashboard for an OBIEE 12.2.1.2.0 (Build BIPS-20160923092103 64-bit) install.

The browser I'm using (Predominantly) is IE 11.0.9600.18920 although I have also tested using Chrome 66.0.3359.139

I have an issue with a Pivot table with scrolling content. When you scroll down the pivot will load, then snap back to the start.

I can see this has been raised in Oracle Support but I don't have a support account, does know the root cause/solution to this please?

Cheers,

Lee

Robert Angel · Answer

On service account you should really use the client's, get them to set you up, they are the customer!

Lee Gledhill · Answer

Couldn't agree more. I know users who reconcile GL at item level just incase an item has been booked against the wrong code, and they do this EVERY MONTH.

Trying to explain exception reporting is doing the proverbial into the wind. I'll get there with them in the end, fingers crossed.

It could be the browser though I had a sneaky suspicion it was caching issues as it's the same on both browsers. I'm limited to what I can do with browsers with the size of the company. I've found a service link on Oracle but I don't have a service account to check:

https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2230603_1.htm…

Thanks again!

Robert Angel · Answer

Thanks - I always wonder why people want to consume vast swathes of rows, usually it comes down to 'because we can in excel', but there you still have to scroll / page down - even if you could the brain to process 1000s of rows by 1000s of rows (1000,000 combinations) end users still cling to the comfort blanket of the familiar. I am a big believer in exception reporting, only look at the relevant...

All I have to offer is a semi-educated guess, it sounds like the browser is refreshing, so you might want to consider looking into using jscript on a text area on the same page to lengthen the interval, or on a less hacky basis, log your own SR and see if there is anything not available to the customer that Oracle know of.