MII OData services support all standard OData query operations

[former_member186078]

Hello Friends,

       I have a question regarding OData services in SAP MII. I see that OData services are enabled for query templates in the newer version of SAP MII i.e., from SAP MII 14.0 SP02. I started to explore a little on it, I was able to execute the services mentioned in the below help document, but unable to execute all the operations like top, select, filter or any other.

OData - SAP Manufacturing Integration and Intelligence - SAP Library

So, I would like to understand whether there is only a limited support for the OData in SAP MII or am I doing anything wrong. Here are some queries where I was able to execute them succesfully:

http://server:port/XMII/IlluminatorOData/Rowset(QueryTemplate='Queryfolder path',RowsetID=1)/Row

http://server:port/XMII/IlluminatorOData/Rowset(QueryTemplate='Queryfolder path',RowsetId=1)/Column

http://server:port/XMII/IlluminatorOData/Rowsets('Queryfolderpath')/Rowset

Can you please help me understand a little on why top, fetch, select are not working?

Thanks,

Adithya K

[former_member193328]

Hi Adithya

As far as I know these are not supported by MII ODATA Services as the data in MII queries are not always coming from a DB. To support top skip etc  would mean that performance of the ODATA service would be bad as the query would return all rows and the filtering on the data would happen in MII.

I would suggest to build this logic in the query itself for better performance.

Regards

Partha

[former_member186078]

Hi Partha Sarathi,

         I was thinking the same, but not confident about it, because if that is the case, I believe atleast one of SAP documentation they will have atleast a point listed. Did anyone come across it?

Thanks