nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Loading 25000 records in a table in obiee 12c

Chandranshu Bhardwaj

Hello Everyone,

I'm trying to Display maximum rows per page in OBIEE 12c. It has around 25k of records and its not able to display the records in a page, though I'm not getting any error but it keeps on processing for a very long time. So my doubt is - Is it possible to display arround 25k records in a table in a single page that too in lesser time...if yes, then how?

I've set the <MaxVisibleRows>1000000</MaxVisibleRows> as well in the instancecongig.xml file.

Appreciate your views...

Thanks,

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

3531239 wrote: but it keeps on processing for a very long time. So my doubt is - Is it possible to display arround 25k records in a table in a single page that too in lesser time...if yes, then how?

So you have two issues there.

a) wanting to display 35000 rows at a time and

b) performance

Let's do (b) first: ANALYZE what happens! https://speakerdeck.com/rmoff/still-no-silver-bullets-obiee-12c-performance-in-the-real-world

And to (a): Remember this is an analytical system and no data-vomitting engine to dump tons of useless data. What are you trying to achieve with that?

Chandranshu Bhardwaj

Hi @Christian Berg

Thanks for your reply.

My motive is not to display all the record but I just want to check whether it possible or not by doing some workaround.

Thanks

Joel Acha

OBIEE is the wrong tool for this requirement. You won't get good performance and the ability to visualize this volume of data. OBIEE is just not designed to do this.

Judith Ullman

I displayed 140,000 rows in our OBIA 11.1.1.8, OBIEE 11.1.1.7 with no problem - it took seconds on a test environment. We do this often when testing.

This test used the Scholar dimension and I only placed the Scholar Number on the report. Then I placed a couple of fact columns, in addition, and got back 79,477 records in seconds.

So it's certainly possible.

[Deleted User]

It all depends on the data that's behind. You can have bad models based on bad sources and have a 100 row retrieval take ages because it spits out spaghetti code through analysis.cals, BM calcs and opaque views on views on views.

Conversely a million row retrieval can be sub-second.

[Deleted User]

See my other answer just now. What's your point? It can be fast, it can be slow. If there is no investigation done he will never know.

I can pull several million rows into the front end and it will perform just like I can make 20 result set rows take ages.

Judith Ullman

The point is that the poster wanted to know if it was possible, and I answered the question.

Normally when someone asks a question like that, they want to know if there is enough possibility of making it work to pursue it. If we had all answered, for example, that you can only do this with a high-end system with very few users, that would give the poster a much different path to pursue than seeing if s/he can make it work. Or if we had all said that only in extremely unusual circumstances would this be a problem, that would have given him/her a different point of view.

Gianni Ceresa

Hi,

So I guess you figured out it is possible, meaning there isn't a hardcoded limit to 25K rows or so. If you still have issues and limits (not seeing all your rows) just search here in the forum as there is around a post per week on how to set weirdly crazily high limits in terms of rows and cells. It isn't a single field, there are few of them ...

3531239 wrote:in lesser time...if yes, then how?

For this one you will have to follow the 1st answer Christian posted. Nobody else can tell you how to make it faster as you are the one with the system in front and knowing what your model is like, what the query looks like, how the system is setup etc.

Do not expect a "please_run_fast=true" switch, even when you read that you can have 140K rows in seconds is kind of useless for you : I can easily make you an analysis taking 10 minutes to return 2 rows or one taking 1 second to return 140K rows. Everything depend on your solution and the only way to find out the reasons of the bad performance and so decide how to improve things is by doing an analysis of your situation (that's something Robin's presentation linked cover really well).

Globally you also got, from few answers, that it isn't the classical job you expect from an analytical platform.

[Deleted User]

Judith Ullman wrote:Normally when someone asks a question like that, they want to know if there is enough possibility of making it work to pursue it.

Unfortunately if you look at the usual posts on this subject you will see that this is precisely what they are not looking for. But rather an answer along the lines of "set X in the instanceconfig to Y and off you go" so that they do not have to think about what they're doing and can just dump stuff to Excel. That's the sad reality

Gianni Ceresa

For the records, Oracle also wrote on the topic of "the best tool for the job" when it was about rendering / exporting tons of data (because I will never believe someone analyse 25K rows in screen).

https://support.oracle.com/rs?type=doc&id=1558070.1

(for an older version but still valid for 12c)