cancel
Showing results for 
Search instead for 
Did you mean: 

Optional Filter Variable appears as Mandatory in OData Service of an Analytical Model

maffio
Explorer
0 Kudos
120

Hello expert.

I have an Analytical Model in Datasphere, which has, among other things, two standard filter variables: one is set as Mandatory, the other one is not set as mandatory, so that it is optional. Nevertheless, when I try to extract Odata from the Analytical Model, the optional filter variable appears as mandatory, so that I must provide a value, otherwise the Odata Service fails.

Is there a way to treat the variable as non mandatory, even in OData Service?

Accepted Solutions (0)

Answers (2)

Answers (2)

Martin_Kuma
Active Participant
0 Kudos

Seems that for OData all variables are mandatory. Even if not marked as mandatory by the model. 

Try to bypass with changing the variable to dynamic default (using view/dimension). This way the not-mandatory variable will not be needed to be populated with the OData request. 

 

Simon_Ye
Product and Topic Expert
Product and Topic Expert
0 Kudos
It seems only about if you provide a default value for the paramter; if yes, you don't need to explicitly assign a value in your request.