Executing XML API Requests without 3rd party components

BFinucane

Hi,

There are a few functions not available in the 12 UI that can be executed using the XML API. One is updating an attribute driven hierarchy.

I have written a Python script to do this, and it works fine. But I don't want to install Python at the customer site and I would like to be able to do it without any third party tools. 

I tried using the AppEngine  OLAPXMLRequest function, but it returns an empty reply and throws an error:

Got an unexpected exception while executing xml.
Error during EndExecute
Error:MDX can only be executed on the OLAP server.

The function seems to be expecting XMLA requests, not XML API requests, in which case it might make sense to rename it. 

I have two questions:

Is there any way to send XML API requests without using 3rd party tools?

Is there any way to update an attribute driven hierarchy without invoking the relational model or using 3rd party tools?

David Swinburne

Hi Barney,

You need to use XMLAExecuteXml from App.Engine to execute XML API calls.

Here is an XML API example to clear the calculated values cache of all cubes of a database.

#define EngineVersion 5.0
#define RuntimeVersion 5.0

bool DestroyCache()
@Description: "DestroyCache";
@Category: "Example";
@Returns: "void";
{

    string errorMessage = "";
    int errorCode = 0;
    bool RetVal = true;

    try {

        string olapConnectionString = GetCustomSetting("OLAPDB","");

        string XMLADestroyCache= ""+

            "<Alea:Document xmlns:Alea=""">http://www.misag.com">"+
            "  <Alea:Request RequestID="001" Class="Database" Method="DestroyCache">"+
            "  </Alea:Request>"+
            "</Alea:Document>"
            ;

        XMLAConnection xmlaOLAPConnection =XMLACreateNamedConnection(olapConnectionString);

        XMLAExecuteXml(xmlaOLAPConnection , XMLADestroyCache);

        XMLADisconnect(xmlaOLAPConnection);

    } catch  ( errorMessage, errorCode) {
        NotifyInformation(errorMessage+" "+errorCode);


        RetVal = false;
    }

    return RetVal;
}

Attribute Hierarchies can be updated using the UpdateHierarchies method.

Regards

</code><code>Dave