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 .
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
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
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
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
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
Hi, While using OAS or OAC latest version can we generate a report to view complete defition of semantic model/subject area. It helps to document and troubleshoot. thanks
I want to export all OAC RPD joins and conditions, is there a way to export or extract joins information. please suggest. Repository documentation doesn't gives joins, if any other way pls suggest.
