3769268 - Member ID does not exist in (range) variable dialog in analytic model

Member ID does not exist in the (range) variable dialog

SAP Datasphere

1. Open an Analytic Model that uses a range variable for filtering.
2. At the variable prompt, enter a range that includes values not present in the underlying data source.
3. The prompt shows the error: "Member ID does not exist."

Whenever a value is entered in the variable dialog, a request is sent to the server that validates the value. It’s sent with readmode: master. So if a time dimension is attached, the values are taken from there. If no dimension is attached, then the posted/booked values count. So if the date exist in the booked values, an error occurs.

1. Create a restriction variable or a filter variable based on a dimension that is associated to the fact view rather than directly on the fact values.
2. Define the variable on this dimension so all required members (for example, all calendar dates) are selectable
3. Apply the variable in the Analytic Model and test by selecting a range that includes values without postings; the query should proceed and return no data for those periods instead of blocking with an error.
4. In addition to above global filter might be the root cause of the issue as well. Remove the global filter an try the variable entry again.

member id does not exist, range variable, analytic model, variable prompt, date filter, missing members, no data, calendar dimension, reference date variable, restriction variable, datasphere, variable input error, fact view, dimension variable, date range , KBA , DS-MD-AM , Analytic Model , Problem