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>