A dashboard prompt can affect an embedded analysis only when the analysis is configured to accept the prompt's value. A protected filter deliberately prevents a dashboard prompt from overriding that filter. Oracle describes protected versus unprotected filters specifically as a mechanism controlling whether dashboard prompt values can determine an analysis's results. Therefore, a protected filter is a direct explanation for one of the non-responsive reports.

The second issue is a mismatch between the prompt column formula and the analysis filter formula . Prompt wiring depends on the relevant column identity and formula being compatible. If the analysis uses a modified formula while the prompt targets another formula, Oracle cannot automatically apply the prompt as intended.

By contrast, an Is Prompted filter is specifically intended to receive a prompt value and is therefore normally part of a working configuration. Cache expiration does not explain selective prompt incompatibility, and simply containing measure columns is not itself the documented cause.

The two failed analyses should therefore be inspected for protected filters and formula mismatches between their filtering expressions and the dashboard prompt.

Reference Topic: Formatting Data and Managing Filters, Selection Steps, and Variables — Dashboard Prompt Interaction

===============