3 Replies Latest reply: Feb 13, 2013 4:54 PM by Sasi Nagireddy RSS

    OBIEE 11.1.1.6.1 BP1 How to import rows more than 2500 ?

    866317
      Hi,
      I am using OBIEE 11.1.1.6.2 BP1. I want to increase the number of rows exporting in an Excel sheet which is 2500 (by default) at the moment. Following is th configuration of my instance config file:
      but I am still downloading not more than 2500.
      Any help would be appreciated !

      <?xml version="1.0" encoding="UTF-8" standalone="no"?>
      <!-- Oracle Business Intelligence Presentation Services Configuration File -->
      <WebConfig xmlns="oracle.bi.presentation.services/config/v1.1">
      <ServerInstance>

      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><CatalogPath>D:\OBIEE_Home\instances\instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite</CatalogPath>

      <DSN>coreapplication_OH1115437442</DSN>

      <Logging>

      <Writers>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><Writer implementation="FileLogWriter" name="Global File Logger" writerClassId="1" dir="{%ORACLE_BIPS_INSTANCE_LOGDIR%}" filePrefix="sawlog" maxFileSizeKb="10240" filesN="10" fmtName="ODL-Text"/>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><Writer implementation="CoutWriter" name="Console Logger" writerClassId="2" maxFileSizeKb="10240"/>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><Writer implementation="EventLogWriter" name="System Event Logger" writerClassId="3" maxFileSizeKb="10240"/>
      <!-- The following writer is not centrally controlled -->
           <Writer implementation="FileLogWriter" name="Webcat Upgrade Logger" disableCentralControl="true" writerClassId="5" dir="{%ORACLE_BIPS_INSTANCE_LOGDIR%}" filePrefix="webcatupgrade" maxFileSizeKb="2147483647" filesN="1" fmtName="ODL-Text"/>
      </Writers>

      <WriterClassGroups>
      <WriterClassGroup name="All">1,2,3,5</WriterClassGroup>
      <WriterClassGroup name="File">1</WriterClassGroup>
      <WriterClassGroup name="Console">2</WriterClassGroup>
      <WriterClassGroup name="EventLog">3</WriterClassGroup>
      <WriterClassGroup name="UpgradeLogFile">5</WriterClassGroup>
      </WriterClassGroups>

      <Filters>
      <!-- These FilterRecords are updated by centrally controlled configuration -->
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><FilterRecord writerClassGroup="File" path="saw" information="1" warning="31" error="31" trace="0" incident_error="1"/>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><FilterRecord writerClassGroup="File" path="saw.mktgsqlsubsystem.joblog" information="1" warning="31" error="31" trace="0" incident_error="1"/>

      <!-- The following FilterRecords are not centrally controlled -->
      <FilterRecord writerClassGroup="UpgradeLogFile" disableCentralControl="true" path="saw.subsystem.catalog.initialize.upgrade" information="1" warning="32" error="32" trace="1" incident_error="32"/>
      <FilterRecord writerClassGroup="UpgradeLogFile" disableCentralControl="true" path="saw.subsystem.catalog.upgrade" information="1" warning="32" error="32" trace="1" incident_error="32"/>
      </Filters>

      </Logging>

      <Catalog>
      <UpgradeAndExit>false</UpgradeAndExit>
      </Catalog>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><Listener port="9710" ssl="false"/>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><JavaHostProxy ssl="false">
      <Hosts>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><Host name="coreapplication_obijh1" address="tdc03srv161.g-mwater.com.au" port="9810"/>
      </Hosts>
      </JavaHostProxy>
      <Alerts>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><ScheduleServer ssl="false" ccsPrimary="tdc03srv161.g-mwater.com.au" ccsPrimaryPort="9706"/>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><OfflinePresentationServicesURL>http://10.12.3.161:9704/analytics/saw.dll</OfflinePresentationServicesURL>
      </Alerts>
      <ActionFramework>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><ActionExecutionServiceEndPoint>http://10.12.3.161:9704/analytics/actions/ActionExecutionService</ActionExecutionServiceEndPoint>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><TargetBrowsingServiceEndPoint>http://10.12.3.161:9704/analytics/actions/ActionRegistryService</TargetBrowsingServiceEndPoint>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><LocationServiceEndPoint>http://10.12.3.161:9704/analytics/actions/LocationService</LocationServiceEndPoint>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><WorkflowServer>http://10.12.3.161:9704</WorkflowServer>
      <WorkflowService>ANALYTICS</WorkflowService>
      <WorkflowSystem>obiaftests</WorkflowSystem>
      </ActionFramework>
      <Security>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <ClientSessionExpireMinutes>210</ClientSessionExpireMinutes>
      </Security>
      <ODBC>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <ResultRowLimit>65000</ResultRowLimit>
      </ODBC>
      <Views>
      <Pivot>
      <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
      <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
      <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
      <DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
      <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
      <DisableAutoPreview>false</DisableAutoPreview>
      <MaxVisibleColumns>300</MaxVisibleColumns>
      <MaxVisiblePages>1000</MaxVisiblePages>
      <MaxVisibleRows>1000</MaxVisibleRows>
      <MaxVisibleSections>25</MaxVisibleSections>
      <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
      </Pivot>
      <Table>
      <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
      <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
      <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
      <DefaultRowsDisplayedInDownload>25000</DefaultRowsDisplayedInDownload>
      <MaxVisiblePages>1000</MaxVisiblePages>
      <MaxVisibleRows>1000</MaxVisibleRows>
      <MaxVisibleSections>25</MaxVisibleSections>
      <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
      </Table>
      <Charts>
      <MaxVisibleColumns>2000</MaxVisibleColumns>
      <MaxVisiblePages>1000</MaxVisiblePages>
      <MaxVisibleRows>2000</MaxVisibleRows>
      <MaxVisibleSections>25</MaxVisibleSections>
      <JavaHostReadLimitInKB>4096</JavaHostReadLimitInKB>
      </Charts>
      </Views>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <OracleHardwareAcceleration>false</OracleHardwareAcceleration>
      <Dashboard>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <ShowPageTabsAlways>false</ShowPageTabsAlways>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <ShowSectionHeadingsDefault>false</ShowSectionHeadingsDefault>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <CollapsibleSectionsDefault>true</CollapsibleSectionsDefault>
      </Dashboard>
      <DeploymentProfile>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <DeploymentMode>onsite</DeploymentMode>
      </DeploymentProfile>
      <AsyncLogon>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <NewLogonWaitSeconds>30</NewLogonWaitSeconds>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <NewSyncLogonWaitSeconds>900</NewSyncLogonWaitSeconds>
      </AsyncLogon>
      <Marketing>
      <ContentServer>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <URL>http://localhost:8765</URL>
      </ContentServer>
      </Marketing>
      <Authentication>
      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
      <EnabledSchemas>UidPwd,Impersonate,UidPwd-soap,Impersonate-soap</EnabledSchemas>
      </Authentication>
      </ServerInstance>
      </WebConfig>