Product Version : OBIEE 126.96.36.199.2
We please to advice about the following issue:A prompt is defined against a dimension table.
When the sql run first time pointed to a fact table .After a new run is produced the SQL pick another fact table .
Any new runs continues to pick randomly - fact tables without any explicit action.
The LOV produced for selection is different at each iteration.In theory a list with maximum values available from
dimension table is requested.
Thanks in advance.