CanRestoreOlapState: Operation

The CanRestoreOlapState operation checks if the user can restore express report table to original state after drilldown/drillup was applied.

Comments

To execute the operation, in the mon field specify express report instance moniker with the !Sheets!sheet_key!Pivot postfix. The moniker can be obtained using the OpenEax operation.

The operation results in the logical true if original state can be restored, and false if drilldown/drillup was not executed.

Example

Below is the example of check if the user can restore express report table to original state after data drilldown/drillup. The request contains moniker for working with table base. The response contains whether original state can be restored.

SOAP JSON C#

SOAP request:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<mon xmlns="">AOJCKFNGPEEEGOAEIKMCGPAHDIBGIBFEPKIHPJOIEJAKPMLE!M!S!EIHNGHJNGPEEEGOAELIEODEFLIHBECCBEOLAOPCEKLDFOIECA!Sheets!18158!Pivot</mon>

</CanRestoreOlapState>

</s:Body>

</s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

{
 "CanRestoreOlapState" : 
  {
   "mon" : "AOJCKFNGPEEEGOAEIKMCGPAHDIBGIBFEPKIHPJOIEJAKPMLE!M!S!EIHNGHJNGPEEEGOAELIEODEFLIHBECCBEOLAOPCEKLDFOIECA!Sheets!18158!Pivot"
  }
}

JSON response:

{
 "CanRestoreOlapStateResult" : "1"
}

public static bool CanRestoreOlapState(string moniker, string sheetKey)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tGet = new CanRestoreOlapState()
    {
        mon = moniker + "!Sheets!" + sheetKey + "!Pivot"
    };
    // Check if table can be restored to original state
    var result = somClient.CanRestoreOlapState(tGet);
    return result;
}

CanRestoreOlapState

Syntax