Abstract: Systems and methods include receipt of a request for stored values associated with a plurality of tuples including a plurality of dimension members; transmission of a first query including all dimension members of each of the plurality of tuples, reception from the system of a first result set including a value associated with each of a plurality of first result tuples, determination of a remaining set of tuples based on the plurality of tuples and the plurality of first result tuples, transmission of a second query including dimension members of the remaining set of tuples, reception of a second result set including a value associated with each of a plurality of second result tuples, determination, based on the second result set, that the values associated with the plurality of tuples have been received, and presentation of the values associated with the plurality of tuples.

Abstract: The present disclosure involves systems, software, and computer implemented methods for enabling custom formulas in a cloud platform office add-in. An example method includes automatically loading a public landing page of a cloud platform add-in of a spreadsheet application. The public landing page includes a declaration and a first implementation of at least one custom function. Login credentials for a customer tenant of the cloud platform are obtained. A redirect is performed to a private web application for the customer tenant. The private web application includes, for each custom function, a second implementation that is configured to retrieve customer-specific cloud platform data of the customer tenant. Each first implementation of a custom function is replaced with the second implementation of the custom function. In response to a user request in the spreadsheet application to use a first custom function, the second implementation of the custom function is invoked.

Abstract: Systems and methods include receipt of a request for stored values associated with a plurality of tuples including a plurality of dimension members; transmission of a first query including all dimension members of each of the plurality of tuples, reception from the system of a first result set including a value associated with each of a plurality of first result tuples, determination of a remaining set of tuples based on the plurality of tuples and the plurality of first result tuples, transmission of a second query including dimension members of the remaining set of tuples, reception of a second result set including a value associated with each of a plurality of second result tuples, determination, based on the second result set, that the values associated with the plurality of tuples have been received, and presentation of the values associated with the plurality of tuples.

Abstract: The present disclosure involves systems, software, and computer implemented methods for enabling custom formulas in a cloud platform office add-in. An example method includes automatically loading a public landing page of a cloud platform add-in of a spreadsheet application. The public landing page includes a declaration and a first implementation of at least one custom function. Login credentials for a customer tenant of the cloud platform are obtained. A redirect is performed to a private web application for the customer tenant. The private web application includes, for each custom function, a second implementation that is configured to retrieve customer-specific cloud platform data of the customer tenant. Each first implementation of a custom function is replaced with the second implementation of the custom function. In response to a user request in the spreadsheet application to use a first custom function, the second implementation of the custom function is invoked.

Abstract: Interactive dialog communication via callbacks is provided by a dialog execution environment executed in response to a selection of a first user interface element in a panel execution environment. The dialog execution environment receives a first set of information including a callback method. A dialog includes a second user interface element selectable to show a second set of information. To obtain this information, the dialog execution environment sends a request for the second set of information to the panel execution environment via the callback method. The panel execution environment sends a request for the second set of information to a server and receives a response including the second set of information. The dialog execution environment receives a response including the second set of information from the panel execution environment and provides the second set of information in a user interface of the dialog.