How to add Essbase variables through Studio

Technote (troubleshooting)


Problem(Abstract)

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

Symptom

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


Cause

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">
<Variables>
<Variable Name="Variable1" />
</Variables>
<Sources>
<Source Name="EssbaseCube" Provider="Essbase" />
</Sources>
<Queries>
<VariableQuery Name="VariableQuery1">
<Source Name="EssbaseCube" />
<Script Type="SubstitutionVariable">
<Text>Variable1</Text>
</Script>
<Variable Name="Variable1" />
</VariableQuery>
</Queries>
</Template>



Rate this page:

(0 users)Average rating

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:

2013-09-24

Translate my page

Machine Translation

Content navigation