PHP Classes

Simple PHP SSAS XMLA Request: Send SOAP request with XMLA for SSAS

Recommend this page to a friend!
  Info   View files Example   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 224 This week: 1All time: 8,220 This week: 560Up
Version License PHP version Categories
simple-ssas-request 1.0GNU General Publi...5.0PHP 5, Databases, Web services
Description 

Author

This class can send SOAP request with XMLA for SSAS.

It can send a HTTP POST SOAP request to Microsoft SQL Server Analysis Service server to execute several types of operations.

The class send requests to can process cubes, create and delete objects, among other operations by sending XMLA requests.

In Portuguese:

Esta classe irá enviar uma requisição com XMLA para o SSAS, podendo processar cubos, criar e deletar objetos entre outras coisas, não tem suporte a autenticação e não pode executar queries em MDX, apenas se comunicar com o HTTP para envio de XMLA.

Innovation Award
PHP Programming Innovation award nominee
August 2014
Number 12
SSAS - SQL Server Analytics Service is Microsoft tool for providing anaytical information about the usage of Microsoft SQL server.

This class provides a means to send requests to Microsoft SQL Server Analytics Service.

Manuel Lemos
Picture of Guthierry Marques Neto
  Performance   Level  
Name: Guthierry Marques Neto <contact>
Classes: 1 package by
Country: Brazil Brazil
Age: 30
All time rank: 4074329 in Brazil Brazil
Week rank: 416 Up36 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 1x

Example

-<?php
-
-
/*
- * file: example.php
- *
- * Author: Guthierry Marques Neto
- * "Simple is better"
- *
- */
-
-require(
'Simple_SSAS_request.php');
-
-
//Instance the object SSAS_request / Instancia o objeto SSAS_request
-$send_SSAS = new SSAS_request();
-
//Set URL of SSAS http inteface / Seta a URL da interface HTTP do SSAS
-$send_SSAS->setURL('http://localhost/olap/msmdpump.dll');
-
//Set XMLA for request / Envia o XMLA para processamento
-$send_SSAS->setXMLA(''
- . '<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
- <Parallel>
- <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
- <Object>
- <DatabaseID>Adventure Works DW</DatabaseID>
- <CubeID>Adventure Works DW</CubeID>
- </Object>
- <Type>ProcessFull</Type>
- <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
- </Process>
- </Parallel>
-</Batch>'
);
-
//Request / Envia
-$send_SSAS->request();


Details

SIMPLE_SSAS_HTTP_REQUEST

This class allows the processing of XMLA requests in a simple manner for easy implementation. The class is how to use simple as possible, SQL Server Analysis Services must be previously configured: HTTP ACCEPT REQUESTS WITHOUT AUTHENTICATION. Without which the class is inefficient, The class has no support for MDX queries, only serves to send xmla for processing cubes, object creation, etc. Will not return any responses. An example of use is in example.php file

Author: Guthierry Marques Neto

Esta classe permite o processamento de requisições XMLA de maneira simples para facil implementação.

A classe é a forma de uso mais simples possivel, o SQL Server Analysis Services deve estar PREVIAMENTE CONFIGURADO: ACEITAR REQUISIÇÕES HTTP SEM AUTENTICAÇÃO. Sem o qual a classe é ineficiente, caso implemente o uso com autenticação (simples, user athentication e etc) por favor contribua com a comunidade.

A classe não possui suporte a consultas mdx, serve somente para o envio de xmla para processamento de cubos, criação de objetos e etc. Não irá retornar dados.

Autor: Guthierry Marques Neto


  Files folder image Files  
File Role Description
Accessible without login Plain text file example.php Example Example to use SSAS_request Class
Accessible without login Plain text file LICENSE Lic. License
Accessible without login Plain text file README.md Data README FIRST
Plain text file Simple_SSAS_request.php Class CLass to send request for SQL Server Analysis Services HTTP interface

 Version Control Unique User Downloads Download Rankings  
 100%
Total:224
This week:1
All time:8,220
This week:560Up