Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Scrolling Pivot table issue
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
Answers
-
Hi Lee,
I don't have a fix / cause, but I do have a useful workaround.
Create a substring based formula on one of the descriptor lead columns and then you can give the user a prompt selector for A,B,C slices of the total pivot.
Not perfect, but it does actually make massive pivots easier to navigate than the default functionality.
0 -
Thanks Robert, I have done that elsewhere actually and it would work quite well here - It's a trial balance Pivot so I can subtotal on the substring which would please the users enough to forget about the table resetting
If anyone has the Cause or fix though it would be appreciated.
Cheers,
0 -
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.
0 -
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:
Thanks again!
0 -
On service account you should really use the client's, get them to set you up, they are the customer!
0