General Commands

Decode Encoded Contents

You may be working with the encoded contents of an artifact such as in the ENCODED_ARTIFACT column of the BINARY_ARTIFACTS table or inside of the exported artifact XML. The decode command takes a single parameter and will decode and print the conents for you.

For example, when the standard Income Statement view is exported to a zip file, the contents of the inner SAMPLE.VIEW.IncStmt.1.xml file as similar to the following:

<?xml version='1.0' encoding='UTF-8'?>
<BinaryArtifact exported="2019-03-22T18:27:32" info="NS8xMDAuMC8xMDAuMS8xLzIwMjA=">
  <Tenant>SAMPLE</Tenant>
  <Category>VIEW</Category>
  <ID>IncStmt</ID>
  <Version>1</Version>
  <UserID />
  <Type>ExcelEssbase</Type>
  <Name>Income Statement</Name>
  <Description />
  <Filename />
  <FileCreatedDateTime />
  <FileModifiedDateTime />
  <Checksum>00f41daf7c7a1e5bb632a5f66bfce0155188253c</Checksum>
  <CacheType>0</CacheType>
  <CacheTimeout>0</CacheTimeout>
  <EncodedArtifact>H4sIAAAAAAAEAO29B2AcSZYlJi9tynt/SvVK1+B0oQiAYBMk2JBAEOzBiM3mkuwdaUcjKasqgcplVmVdZhZAzO2dvPfee++999577733ujudTif33/8/XGZkAWz2zkrayZ4hgKrIHz9+fB8/Iv7Hv/cffPyTRX519Bsnacq/nS3Pq3qRtUW1TN8tymXz6F1TfPbRvG1Xj+7evbq6Gl/dG1f1xd29nZ3du7/3F89fT+f5Itsulk2bLaf5R/at2c1vfcT9Us9nT4/OltPX7aJ9fJd+109fZIscn1eLPH3dZm2+yJfUgD/WJkD5zfUqp5dO303z8rRpJlmTP77rfeFBm72sq1Vet9ev87ZJ78qw73bGLZ9qyyJvfoh0OC7L6up1dpkftfWaRuH+DhrMs7pYXgRt9CPTbN1WT9ZFOfty+eUqX5qWnU+18Um2wrCPz9u85q97NE+JNun33oy/yOq3efv9dBt/EIFm66n56/U0XxIK1fcf3+3D046+yOuLPJuU+ZuqKidZ3ZxUy/PiYl0z2WmmMBHpF1mxJJivP39898YXfC6o3uZLM6f2s/hryiUp90ejXM6yepY+LxZFm8+0703vaxffLZaz6qpBy6/Ovpz8dD5tleW+W9VvJ1X1Fl89vjvczp/VfPb81Zf4vDna01n1PtKWijkhtCQogs3rbLEq8/GTrCmmj+/GWoQvP68uiuXrvL4spnmAjf/90yIrqwsLbvAdB9oJjH5IH7/Ol7OfyuuqOW6+KJrGMW3kC/vSV01+XBbUaaONvQ9sI33rTf6ufd0y6+8Qv/Q+tO1fVMfTad40rnHnEx3I3dhIHn9eFzOiaEuAv8iXaxr3m5yITuLhffr4br+Zvv86L4lkVR0wkkNOiWxaQRfZL+nr51nTEg1mZySNCv7oaX6erUvShrEvN7/7PJvkpRWUAD/CeP/3FynHHNkPI02fF01L30jj3/9Nnee/P/QLFIt7VRtFXg9Zzr0RsJW8UdXtl/Usr492qZn9w2vRIZ8Q2QmAp8ndoC1nR4n+/6oZuff7q6q95ZRo6x/OnOz9/JyT+7+/MXi3nBTT/Pc/qRYT76Vvdjbu/ZBmw2ET02h2CE+r6ducNWJdlZ/X1Xr1ur0u8yMyufjCQRlqqPA6xvDL5dO6KMt2Tg0v5q/ned4e7e73bGasmQI8yZppNstfV+t66g368Qm5Ue2rnCxCfpm/ypYXOQbtfV8t4A/xN95rT7M2O8nL8mm1JmflpCymb19W9O/10fFsxh0/ozF6yDy+O/zKMMwv8sUkr58VJTlWsd69DqTpm4q9IqLrJb1BE/RqXXbx7tGI3Wv/05Q/FpTjrT1w5Fh3qRNY1A4hGIbXFD68Ma1PCpKY62N67TybOnGNBwv0+U/KGGEmzK+GW2+G2zfxMUwDumw2/dHXtS/iMHJyv1wqp2WlOjr9z90LzJLKIgGHNvye/7V5qbo6XhJS5Xqx/HZO7F6TC9oUxE1Hz7ISKmVDC4XxJpt0X/I/QqvHdwN/STzno/8Htu+7wloOAAA=</EncodedArtifact>
  <CreatedBy>Dodeca Sample 7.0.0</CreatedBy>
  <CreatedDate>2019-02-14T19:10:50</CreatedDate>
  <UpdatedBy />
  <UpdatedDate />
</BinaryArtifact>

The contents of the <EncodedArtifact> element can be used with the decode command as follows:

dshell/:>decode H4sIAAAAAAAEAO29B2AcSZYlJi9tynt/SvVK1+B0oQiAYBMk2JBAEOzBiM3mkuwdaUcjKasqgcplVmVdZhZAzO2dvPfee++999577733ujudTif33/8/XGZkAWz2zkrayZ4hgKrIHz9+fB8/Iv7Hv/cffPyTRX519Bsnacq/nS3Pq3qRtUW1TN8tymXz6F1TfPbRvG1Xj+7evbq6Gl/dG1f1xd29nZ3du7/3F89fT+f5Itsulk2bLaf5R/at2c1vfcT9Us9nT4/OltPX7aJ9fJd+109fZIscn1eLPH3dZm2+yJfUgD/WJkD5zfUqp5dO303z8rRpJlmTP77rfeFBm72sq1Vet9ev87ZJ78qw73bGLZ9qyyJvfoh0OC7L6up1dpkftfWaRuH+DhrMs7pYXgRt9CPTbN1WT9ZFOfty+eUqX5qWnU+18Um2wrCPz9u85q97NE+JNun33oy/yOq3efv9dBt/EIFm66n56/U0XxIK1fcf3+3D046+yOuLPJuU+ZuqKidZ3ZxUy/PiYl0z2WmmMBHpF1mxJJivP39898YXfC6o3uZLM6f2s/hryiUp90ejXM6yepY+LxZFm8+0703vaxffLZaz6qpBy6/Ovpz8dD5tleW+W9VvJ1X1Fl89vjvczp/VfPb81Zf4vDna01n1PtKWijkhtCQogs3rbLEq8/GTrCmmj+/GWoQvP68uiuXrvL4spnmAjf/90yIrqwsLbvAdB9oJjH5IH7/Ol7OfyuuqOW6+KJrGMW3kC/vSV01+XBbUaaONvQ9sI33rTf6ufd0y6+8Qv/Q+tO1fVMfTad40rnHnEx3I3dhIHn9eFzOiaEuAv8iXaxr3m5yITuLhffr4br+Zvv86L4lkVR0wkkNOiWxaQRfZL+nr51nTEg1mZySNCv7oaX6erUvShrEvN7/7PJvkpRWUAD/CeP/3FynHHNkPI02fF01L30jj3/9Nnee/P/QLFIt7VRtFXg9Zzr0RsJW8UdXtl/Usr492qZn9w2vRIZ8Q2QmAp8ndoC1nR4n+/6oZuff7q6q95ZRo6x/OnOz9/JyT+7+/MXi3nBTT/Pc/qRYT76Vvdjbu/ZBmw2ET02h2CE+r6ducNWJdlZ/X1Xr1ur0u8yMyufjCQRlqqPA6xvDL5dO6KMt2Tg0v5q/ned4e7e73bGasmQI8yZppNstfV+t66g368Qm5Ue2rnCxCfpm/ypYXOQbtfV8t4A/xN95rT7M2O8nL8mm1JmflpCymb19W9O/10fFsxh0/ozF6yDy+O/zKMMwv8sUkr58VJTlWsd69DqTpm4q9IqLrJb1BE/RqXXbx7tGI3Wv/05Q/FpTjrT1w5Fh3qRNY1A4hGIbXFD68Ma1PCpKY62N67TybOnGNBwv0+U/KGGEmzK+GW2+G2zfxMUwDumw2/dHXtS/iMHJyv1wqp2WlOjr9z90LzJLKIgGHNvye/7V5qbo6XhJS5Xqx/HZO7F6TC9oUxE1Hz7ISKmVDC4XxJpt0X/I/QqvHdwN/STzno/8Htu+7wloOAAA=

Generating the following output:

<View>
  <ViewInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <ID>IncStmt</ID>
    <Name>Income Statement</Name>
    <ViewTypeID>ExcelEssbase</ViewTypeID>
    <NamedPropertySets />
  </ViewInformation>
  <Properties xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <AllowSave>true</AllowSave>
    <AllowSharing>true</AllowSharing>
    <AutoBuildOnOpen>true</AutoBuildOnOpen>
    <CaptionAfterBuild>Income Statement for [T.Market] - [T.Product] - [T.Scenario]</CaptionAfterBuild>
    <MergeableToolbarsConfigurationID>View Main - SG</MergeableToolbarsConfigurationID>
    <ViewTokens />
    <ViewToolbarsConfigurationID>Essbase View Standard Limited - SG</ViewToolbarsConfigurationID>
    <WindowsViewUIObjectTypeID>WorkbookView</WindowsViewUIObjectTypeID>
    <AllowedLROTypes>2</AllowedLROTypes>
    <EssbaseConnectionID>Sample.Basic</EssbaseConnectionID>
    <EssbaseLoginServiceObjectTypeID>EssbaseLoginDialog</EssbaseLoginServiceObjectTypeID>
    <EssProperties>
      <SendZerosAsMissing>true</SendZerosAsMissing>
      <UseAliases>true</UseAliases>
      <MissingTextString>0</MissingTextString>
      <NoAccessString>0</NoAccessString>
    </EssProperties>
    <GridContextMenuID>TemplateContextMenu</GridContextMenuID>
    <SelectorConfiguration>
      <EssbaseSelectorInfo>
        <LastUsedItemContext>Default</LastUsedItemContext>
        <LastUsedItemContextLabel />
        <SelectorID>4_Market</SelectorID>
        <SelectorListID>Market_Tree_AutoOpen</SelectorListID>
        <SelectorTypeID>Essbase</SelectorTypeID>
        <SortOrder>1</SortOrder>
        <EssbaseSelectorConfigConnectionProperties />
      </EssbaseSelectorInfo>
      <EssbaseSelectorInfo>
        <LastUsedItemContext>Default</LastUsedItemContext>
        <LastUsedItemContextLabel />
        <SelectorID>3_Product</SelectorID>
        <SelectorListID>Product_Tree_AutoOpen</SelectorListID>
        <SelectorTypeID>Essbase</SelectorTypeID>
        <SortOrder>2</SortOrder>
        <EssbaseSelectorConfigConnectionProperties />
      </EssbaseSelectorInfo>
      <EssbaseSelectorInfo>
        <LastUsedItemContext>Default</LastUsedItemContext>
        <LastUsedItemContextLabel />
        <SelectorID>5_Scenario</SelectorID>
        <SelectorListID>Scenario_Combo</SelectorListID>
        <SelectorTypeID>Essbase</SelectorTypeID>
        <SortOrder>3</SortOrder>
        <EssbaseSelectorConfigConnectionProperties />
      </EssbaseSelectorInfo>
    </SelectorConfiguration>
    <SelectorDockedControlGroupStyle>Stacked</SelectorDockedControlGroupStyle>
    <AllowedLROTypesOnDrillthroughSheet>14</AllowedLROTypesOnDrillthroughSheet>
    <CascadeSources />
    <ChartRetrieveRangeInfo />
    <CommentRanges />
    <DataCellDoubleClickPolicy>AddSheetForDrillthrough</DataCellDoubleClickPolicy>
    <DataCellDoubleClickMemberFilters />
    <DataCellDrillthroughMemberToTokenConversionRules />
    <DataDrillthroughSheetName>Drillthrough Sheet</DataDrillthroughSheetName>
    <DataSetRanges />
    <EssPropertiesForDrillthroughSheet />
    <ExcelTemplateBinaryArtifact>
      <ID>IncStmt</ID>
      <Version>1</Version>
    </ExcelTemplateBinaryArtifact>
    <GridContextMenuIDForDrillthroughSheet>DrillthroughContextMenu</GridContextMenuIDForDrillthroughSheet>
    <RetainOnRetrieval>true</RetainOnRetrieval>
    <RetrievePolicy>RetrieveRanges</RetrievePolicy>
    <RowAndColumnHeadersVisible>False</RowAndColumnHeadersVisible>
    <TabsVisible>False</TabsVisible>
  </Properties>
</View>