RestoreOlapState

Syntax

bool RestoreOlapState(string mon, RestoreOlapStateArg tArg)

Parameters

mon. String view of moniker for working with table base.

tArg. Operation execution parameters.

Description

The RestoreOlapState operation restores 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, and in the tArg.mode field specify state restore mode. The moniker can be obtained using the OpenEax operation.

The operation results in the logical true if the express report table was restored to original state successfully.

Example

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

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">
<RestoreOlapState xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">NOICJALBNCPGGOAEFPANAHHMPHHENPCEJLBAOJKCLMGPKANI!M!S!ECKPKHELBNCPGGOAELOJFAHMBFBOONNAEBIGLKADEFJPGCLGO!Sheets!18158!Pivot</mon>
<tArg xmlns="">
  <mode>All</mode>
  </tArg>
  </RestoreOlapState>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
  <RestoreOlapStateResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">1</RestoreOlapStateResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
 "RestoreOlapState" : 
  {
   "mon" : "NOICJALBNCPGGOAEFPANAHHMPHHENPCEJLBAOJKCLMGPKANI!M!S!ECKPKHELBNCPGGOAELOJFAHMBFBOONNAEBIGLKADEFJPGCLGO!Sheets!18158!Pivot",
   "tArg" : 
    {
     "mode" : "All"
    }
  }
}

JSON response:

{
 "RestoreOlapStateResult" : "1"
}
public static bool RestoreOlapState(string moniker, string sheetKey)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tSet = new RestoreOlapState()
    {
        tArg = new RestoreOlapStateArg()
        {
            mode = RestoreOlapStateMode.All
        },
        mon = moniker + "!Sheets!" + sheetKey + "!Pivot"
    };
    // Restore table to original state
    var result = somClient.RestoreOlapState(tSet);
    return result;
}

See also:

Working with Express Reports