Retrieval performance, the FCCS causes
When an FCCS grid crawls, it is almost always asking the cube to compute instead of read. Four causes account for most tickets, and each has a fix that works the same day.
The general diagnosis method, the Activity Report and the worst-query list, lives on Smart View performance. This page carries only what is FCCS's own, and the whole reference is mapped on the FCCS index.
◆ The four causes, and the same-day fixes— what is computing when you thought you were reading.
| Cause | The fix |
|---|---|
| Dynamic seeded parents on the grid | The Data Source parents, total input and adjusted, total eliminations, total data source, are dynamic calculations per Oracle's dimension reference, computed fresh at every retrieve, and the aggregating members above the belt behave the same way. Rebuild the grid on stored level-zero members and sum in the sheet; the retrieve drops from computation to read. |
| To-date views computed at retrieve | Quick on periodic, crawling on year to date is the view storage decision showing its bill at the desk of whoever opened the grid. The fix is a design setting, not a grid change, and it has its own page. |
| Dimension roots as placeholders | A root member left on a grid asks for the whole dimension's aggregation. Saved grids with real members end both the wait and the silent impact-status failure the root Period member is documented to cause. |
| The everything grid | Whole entity tree down the rows, every account across the columns, refreshed hourly during close. Scope grids like queries, entities and accounts the reader will look at, missing rows suppressed, and split the monster into the three grids people were extracting from it anyway. |
The recurring heavy retrieve, the one refreshed hourly by five people, is not a grid problem, it is a report living in the wrong system. In the owned warehouse, the star schema we recommend building beside FCCS on your own cloud, mapped here, that retrieve is a query that costs the cube nothing. Member storage behavior verified against Oracle's dimension reference, July 2026.
- dynamic calculation
- Stored nowhere, computed at retrieve. The wait, most of the time.
- stored member
- Written at consolidation, read at retrieve. The fast path.
- the everything grid
- The whole cube in one sheet. Split it into what people read.