xodej/php-olapi

Jedox OLAP HTTP API wrapper written in PHP

dev-master 2022-02-19 18:46 UTC

Requires

• php: >=7.4.0
• ext-curl: *
• ext-dom: *
• ext-openssl: *
• ext-shmop: *
• ext-simplexml: *
• guzzlehttp/guzzle: ^7.3

MIT

• Johannes Mueller

• php
• http
• api
• wrapper
• olap
• jedox

README

a pure PHP lib for communicating with a Jedox OLAP (using HTTP API)

This repository is unstable. Please be careful when updating your app. Some APIs/methods might break or change. If you use the library for professional work you should either fork the version you develop with or refer to a specific commit.

Installation

Requires PHP 7.3+

composer require xodej/php-olapi:dev-master

Example

<?php

require_once __DIR__ . '/vendor/autoload.php';

// import Connection class
use Xodej\Olapi\Connection;

// connection parameters
$host = 'http://127.0.0.1:7777';
$user = 'admin';
$pass = 'admin';

// initialize a connection to Jedox OLAP
$conn = new Connection($host, $user, $pass);

// fetch cube Balance from database Biker
$cube = $conn->getCube('Biker/Balance');

// read and print value to screen
echo $cube->getValue(['Actual', '2015', 'Apr', '10 Best Bike Seller AG', 'Goodwill']);

Documentation

For more examples please look here.

Token mechanism

The API token mechanism is currently not supported. All changes on the server during operations are ignored.

License

Licensed under the MIT License.