limiting no of records in obiee 11g

3167974

hi,

i have a requirement to show only 200 records in table  and if there is more than 200 records then while exportng the data in different format we should be able to see all the records .please let me know .

FTisiot

You can create 1 analysis with the limit of 200 rows and then create a link to a second analysis without row limit to use to download

3167974

hi,

actually we are facing issue as "Exceeded configured maximum number of allowed output colunns,rows ,section" so to  remove these error we have set the limit as ony 200 records in table and while exporting we should be able to see whole data as you are saying if i try to export the whole data in second analysis then it will through error there too so  is it possible to show  limited data in view and export all

Joel

I think it has already been mentioned that you can't achieve both in a single analysis. You'll need to set your max number of rows to a reasonable number in your config. and then have 1 report which has a row count <= 200 filter on it and a 2nd report which shows all rows.

Sent from my iPhone

FTisiot

Ah I see now you have 2 posts around the same topic.Max number of section exceeded in obiee 11g.. as others said in previous post... you can't have the Presentation Server behaving in 2 different ways depending on your analysis... either you raise the limits on instanceconfig or work within the limits you set. There are no others workaround... so close the threads accordingly