I have an analysis which returns 549214 rows when run but when I export the results to a xlsx or a csv, I am only seeing 4002 rows. Please refer to the attached screenshots if they are of any help. What is snipping off the results?
Are you sure the result is really 550'000 rows? Because the result of COUNT doesn't really mean that's the number of rows you get (there are aggregations happening).
Do you really have 550'000 on screen when you expand your table to show all the rows?
Also keep in mind OBIEE isn't a datapump tool, so default settings limit the size of exports as that's not what the tool is built for ...
Since you said xxx number of rows returned in analysis and during download you are getting less, then you might be hitting a limit set in your instanceconfig.xml. Also what version of MS Office are you using?
In your instanceconfig.xml
Search for the Tag
<DefaultRowsDisplayedInDownload>1000000</DefaultRowsDisplayedInDownload> to increase the value to your needs
under the <Views> Section. Be aware that there are 2 different Sections unbeneath <Views>.
One for the <Table>-View and one for the <Pivot>-View.
Helped me out ;-)
P.S.
If you get stuck in a little less than 65.000 rows in Excel-Export, you should use a newer Excel version that is capable of up to 1 million rows.
Guess at least Excel 2003, 2007 should work anyway.
search <PATH>/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml
and do this
<Views>
<Pivot>
<MaxCells>1920000</MaxCells>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDelivery>1000</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>1000000</DefaultRowsDisplayedInDownload> *************what u need**********************
<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>50000</MaxVisibleColumns>
<!--MaxVisiblepages>2500</MaxVisiblepages-->
<MaxVisibleRows>999999</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>
<DefaultRowsDisplayed>1000000</DefaultRowsDisplayed>
</Pivot>
<Table>
<MaxVisibleRows>9999999</MaxVisibleRows>
</Table>
<Cube>
<CubeMaxRecords>999999</CubeMaxRecords>
<CubeMaxPopulatedCells>999999</CubeMaxPopulatedCells>
</Cube>
<Charts>
<JavaHostReadLimitInKB>8192</JavaHostReadLimitInKB>
</Charts>
</Views>
@3371002 : keep in mind to check what settings do you really need and want and not copy/paste a bunch of things in your config file, mainly when there are pieces managed by Enterprise Manager (as comments in the file tell you).
1.) "and do this" ... nice generalization without explanation.
2.) Funny how you think that will work intelligently with <Cube> sections being lower than even the row count.
May not be explicit enough but a comment indicates exactly which line to edit, no need to be gifted to understand.
The expert!
Well it would be nice to have provide some context rather than just randomly stating "do X"
Configuring for Displaying and Processing Data in Views
Because - for example - the DefaultRowsDisplayedInDownload is being modified but the DefaultRowsDisplayedInDownloadCSV is not.
Also posting instanceconfig,xml excerpts but pointing out tags which are NOT being changed in the file itself but through Enterprise Manager...
Are there any other files besides instanceconfig.xml that I should look at/edit?
I am looking at the various parameters Sherry (by looking I meant bumping them up) I am using Microsoft Office Professional Plus 2016
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…
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.
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
