How-to bypass the 50 rows limitation in OData analytical services?

[Jacques-Antoine]

Hello dear ByDesign experts,

I am using OData analytical services to expose reports from ByDesign in SAP Lumira but I am not able to retrieve more than the first 50 rows (default page size) in my dataset.

I can see that the OData query does retrieve all the records, but when I create the Dataset, only 50 rows are displayed.

Finally, I am not able to change the Array fetch size of the OData service as the option is disabled.

Does anybody knows how-to expose all the records in my dataset ?

Thank you very much for your attention.

Best regards.

Jacques-Antoine Ollier

[Former Member]

Jacques-Antoine,

One of the URL parameters you can use in the Odata query is $top= . This controls the returned record count.

Place $top=99999 or another large number into the parameter.

-Dan

[Jacques-Antoine]

Hello Dan,

As usual, thank you very much for your quick reply.

Actually, I already did quite a few test with the OData services and yes the $top is working well. But only from my web browser.

However, when you are in Lumira and the OData service is called, the query is SQL.

So I query as " select * " or even " select top 99999 * ".

And these queries are working as they return all the records. But when I do push "Create" dataset in Lumira, only 50 rows are shown.

I think there is a problem with the Array, but I cannot find how to bypass it.

So I did quite a tricky workaround using the OData query in the web browser, then I convert the results in a flat file. And I use this flat file as my source for SAP Lumira, but I cannot use the refresh function as no OData connection is made in Lumira.

Thanks for your help Dan.

Best regards.

Jacques-Antoine