24.3.5. OLAP server connection string

<< Prev   Next >>

The OLAP server connection string looks as follows:

http://<OLAP host address>:<port>/<source>?<parameters>

Where:

  • OLAP host address, port, source. Address of access to the OLAP system generated according to the rules described in the documents for a certain OLAP system.
  • parameters. Parameters used by 1C:Enterprise to access OLAP system data . Parameters are set in the Parameters=Value form. Parameters are separated by &. The following parameters are used:
    • ProviderName. Name of the XMLA service in the OLAP source.
    • DataSourceName. Name of the OLAP source.
    • Catalog. Name of the directory or the database in the OLAP source.

Examples of connection strings are given below:

For Microsoft SQL Server Analysis Services:

http://localhost:80/msolap/msmdpump.dll?ProviderName=Microsoft Analysis Services& DataSourceName=host&Catalog=Adventure Works DW

For Oracle Essbase:

http://localhost:13080/aps/XMLA?ProviderName=Essbase XML for Analysis&DataSourceName=host&Catalog=Sample

<< Prev   Next >>

Icon/Social/001 Icon/Social/006 Icon/Social/005 Icon/Social/004 Icon/Social/002