<< Click to Display Table of Contents >>
Usage |
EPM OLE DB Provider allows executing queries to an EPM Server in applications with the functionality of OLE DB data sources, such as Excel and Power BI, or even on a Python environment. OLE DB's language is similar to SQL, but in this case only the SELECT instruction is used together with one of the query functions described later. There are several query functions that can be used to retrieve tables with relevant data. These functions aim to provide easy access to data from an EPM Server. The next topics describe each one of these functions, organized in SQL Instructions, Utility Functions e Data Query Functions.