Overview of XMLA Provider
OLAP is compliant to the
XMLA (XML for Analysis) standard and adds some proprietary functions.
These are all the types of requests that OLAP provides:
- XML requests for a variety of functions such as:
- Modeling
- Writing attributes, cell values, and cell notes
- Administrative tasks
- SQL queries
- WriteCells command
This table describes the relationships between XMLA objects and their OLAP counterparts:
| XMLA | OLAP | Comment |
|---|---|---|
| Server | Machine | |
| Database | Database | |
| Datasource | Database (same as previous one) | |
| Session | One certain connection to the database | |
| Cube | Cube | |
| Dimension | Dimension | In Infor EPM, the term dimension is used for a group of elements. For example, the time dimension groups elements as calendar years. |
| Hierarchy | Hierarchy | A dimension can consist of multiple hierarchies. |
| Level | Level | |
| Member | Element | |
| Member Properties | Attributes | |
| Cell Properties | (3 default properties +) cell notes | Use Cell Property Note to retrieve cell
notes. The equivalent cell property, ALEA_COMMENT, is deprecated. Use Cell Property Writable to query if a cell is writable by the current user or not. The equivalent cell property, ALEA_IS_WRITABLE, is deprecated in favor of Writable. Use Cell-Info to obtain information on the cell. |
| Measure | This order:
|