Manually via the cache manager
-
Open the Administration Tool
-
In the Menu : Manage / Cache
Source:
http://gerardnico.com/wiki/dat/obiee/query_cache_purging
Source:
http://gerardnico.com/wiki/dat/obiee/query_cache_purging
CASE “PR_PROJEKT_HIST”.”RODZAJ” WHEN 2 THEN ‘Grant’ WHEN 3 THEN ‘Przetarg/Zlecenie’ WHEN 4 THEN ‘MIR – własne’ WHEN 5 THEN ‘Zakład – własne’ WHEN 1 THEN ‘Statutowy/Konkurs’ ELSE CAST(“PR_PROJEKT_HIST”.”RODZAJ” AS CHAR(5)) END
REPLACE(CAST(“MULTISPORT_DATA”.”RODZAJ_KARTY” AS char(3)), ’3′, ‘MultiActive5′)
dd.MM.yyyy
View Display Error Maximum total number of cells exceeded (Configured Limit: 400000). Error Codes: EY692ZW9
Change MaxCells Value in instanceconfig.xml file located in <biee11g_install>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
For Example:
example:
<Pivot>
<MaxCells>1920000</MaxCells>
<MaxVisibleColumns>30</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload>
<DisableAutoPreview>false</DisableAutoPreview>
</Pivot>
<Table>
<MaxCells>1920000</MaxCells>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload>
</Table>
Strona startowa: www.jaceksen.pl