SetEaxUsedAttributesIdMap: Operation

The SetEaxUsedAttributesIdMap operation loads previously saved settings of displaying dimension elements in formula description.

Comments

The settings of displaying dimension elements are saved in a local browser storage on changing using the SetEaxFormulaDescriptionUsedAttrs operation. The settings will be stored in the element with the FORMULA_DESCRIPTION_DIALOG key. To use settings in other sessions, one should be first loaded using the SetEaxUsedAttributesIdMap operation.

To execute the operation, in the mon field specify moniker of opened regular report instance with the !DataArea postfix, and in the tArg field specify displaying settings obtained from a local browser storage.

The operation results in the logical True if the settings were loaded successfully.

Example

Below is the example of loading settings of displaying dimension elements within the current BI server session. It is assumed that the cell with formulas is already selected on a report sheet. The settings have been already obtained in the code from the local browser storage. The request contains moniker for working with an analytical data area and displaying settings. The response contains whether settings were loaded successfully.

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="">NBNHEPFAALBBGOAEABGIFGOOMGCKMALEJKHEEKKJBGLAMNPH!M!S!PEICKDAGAALBBGOAEIBOHAGDMIAKHEAJEPILBICMEKJJOEBAJ!DataArea</mon>

<it>

</it>

<it>

<usedAttributeId>START_DATE</usedAttributeId>

</it>

</dimensionKeyToAttributeIds>

</tArg>

</SetEaxUsedAttributesIdMap>

</s:Body>

</s:Envelope>

SOAP response:

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

<soapenv:Body>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

{
 "SetEaxUsedAttributesIdMap" : 
  {
   "mon" : "NBNHEPFAALBBGOAEABGIFGOOMGCKMALEJKHEEKKJBGLAMNPH!M!S!PEICKDAGAALBBGOAEIBOHAGDMIAKHEAJEPILBICMEKJJOEBAJ!DataArea",
   "tArg" : 
    {
     "dimensionKeyToAttributeIds" : 
      {
       "it" : 
        [
          {
           "k" : "339495",
           "usedAttributeId" : "KEY"
          },
          {
           "k" : "339497",
           "usedAttributeId" : "START_DATE"
          }
        ]
      }
    }
  }
}

JSON response:

{
 "SetEaxUsedAttributesIdMapResult" : "1"
}

public static bool SetEaxUsedAttributesIdMap(string moniker)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tSet = new SetEaxUsedAttributesIdMap()
    {
        tArg = new SetEaxUsedAttributesIdMapArg()
        {
            dimensionKeyToAttributeIds = new EaxDimensionKeyToUsedAttributeId[]
            {
                new EaxDimensionKeyToUsedAttributeId()
                {
                    k = 339495,
                    usedAttributeId = "KEY"
                },
                new EaxDimensionKeyToUsedAttributeId()
                {
                    k = 339497,
                    usedAttributeId = "START_DATE"
                }
            }
        },
        mon = moniker + "!DataArea"
    };
    // Restore settings of displaying detailed information about formula terms
    var result = somClient.SetEaxUsedAttributesIdMap(tSet);
    return result;
}

SetEaxUsedAttributesIdMap

Syntax