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

Reg. Max Rows in Pivot Table Export in

Prasanna M

I have designed a Pivot Table to display complete list of Customers and their balances against each Product Type(Loans and Deposits). While doing so, I couldn't export more than 2500 records.

I have tried to amend the below attribute in 'Capacity Management' in EM console and set it to say, 10,000, but while restarting the services, the application has thrown error and reverted the changes.

Maximum Number of Rows to Download

Can someone suggest on how to have this feature enabled?

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

@Prasanna M

a) This is a topic we have about once every two weeks so the forum is full of answers to your question already. 2 seconds google search would pull them up

b) the documentation is extremely clear on the subject: Configuring for Displaying and Processing Data in Views

Prasanna M

Dear Christian

You are right. I have gone through earlier posts on editing InstanceConfig.xml and changing the settings. My problem is, when I do edit InstanceConfig to change the Pivot View settings and the restart the Oracle BI Services, my application throws out an error. It is not accepting the change.

I have done the change in the xml file present in the below path.

/orahome/middleware/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1

Wanted to know is it possible to Edit the XML file manually and deploy especially in 11.1.1.1.9 version. Or only the EM I can do the changes. Even when I do so from EM Console, it is throwing me the error.

Thanks

[Deleted User]

Again the documentation is very clear: parts are managed in EM and parts can be done by file manipulation in 11g.

The comments inside the xml file itself should also be pretty clear with "Managed by Enterprise Manager". Not much ambiguity there.

Pedro F

Just to add something here. Saying "the application thrown an error" is as generic as it can be. You don't really give any details about what went wrong, what error are you getting? Have you checked the logs?

Since you aren't really giving much information, the most people will give you are generic answers as well, for example, links to the documentation.

[Deleted User]

Misspelled tag, wrong tag inside pivot or trellis which belongs into chart...endless options.

If one doesnt read the documentation and tries to comprehend what one's doing then obviously there will be errors

Prasanna M

Thanks Guys for your insights into the the issue..

I will go through the documentation thoroughly regarding administering these changes and update if I am able to do it or face any other issues.

I couldn't get the log for the exact error I got last time.

Also, need a suggestion regarding the documentation.

Does our documentation on OBIEE 11g covers every aspects with regards to administering the features and options. Henceforth, will review the documentation thoroughly and get back on this forum for additional support.

[Deleted User]

Prasanna M wrote: Does our documentation on OBIEE 11g covers every aspects with regards to administering the features and options.

Normally it does since this is what we're all using ourselves.

If there's any doubt left with regards to the instanceconfig and the row settings then it's an additional option to look into the config-base.xsd for the obips since it contains precisely which tags are allowed where in the XML.

Prasanna M

Ok thanks. Will look into that.