IBM Support

How to add Essbase variables through Studio

Technote (troubleshooting)


Unable to add essbase variable source through Studio with Clarity Server 7.2.0 and Clarity Studio The option is not available


The Essbase option is not available in the dropdown when adding a variable.


There is no Essbase support variables in this version or earlier. The Essbase variable source has been added to Clarity Studio only after version 7.2.0.

Resolving the problem

As a workaround, the user can manually add the variable in the template XML editor.

Also, please note to create a named range in the Excel file as illustrated below.

<Template Name="Document1">
<Variable Name="Variable1" />
<Source Name="EssbaseCube" Provider="Essbase" />
<VariableQuery Name="VariableQuery1">
<Source Name="EssbaseCube" />
<Script Type="SubstitutionVariable">
<Variable Name="Variable1" />

Document information

More support for: Clarity 7
Clarity Server

Software version: 7.0, 7.2

Operating system(s): Windows

Software edition: All Editions

Reference #: 1639491

Modified date: 24 September 2013