Navigation

HIPAA

toggle

transition

The Switchable Dimensions add-on allows you to provide several views of your data.
With the Switchable Dimensions add-on, you can easily toggle between dimensions displayed in a widget.
The Switchable Dimension add-on can be set for categories, values, rows, columns or any other dimension that exists in a widget.
&nbsp;

__share-2-image-unique-image-unique

__share

switch_dimensions_example-image-unique

switch_dimensions_example

switch_dimensions_example_result-image-unique

switch_dimensions_example_result

<h4>To install the Switchable Dimensions add-on:</h4>
<ol>
<li>Download the attachment.</li>
<li>Extract the .zip folder into the plugins folder. If the folder does not exist, create it prior to extracting the .zip file. 
For V7.1 and earlier: C:\Program Files\Sisense\PrismWeb\plugins 
For V7.2 and later: C:\Program Files\Sisense\app\plugins</li>
<li>After those files have been unzipped there, you may also have to restart the web server.</li>
<li>Create the widgets that will have switchable dimensions.</li>
<li>Open the widgets script editor and paste the following code: 
<img decoding="async" loading="lazy" class="alignnone" src="https://cdn.sisense.com/wp-content/uploads/editscript1-_thumb_0_300.png" alt="" width="300" height="159" />
<pre>prism.registerSwitchDimension({
			widget: widget,
			maxItemsBeforeSubMenuIsCreated: 5, //optional 
			dimensions: [
			{
			panel: '&lt;PANEL_NAME&gt;', 
			affectAllWidgets: true, //optional (true|false)
			dims: [
			{
			"index": 0, 
			"dim": "[&lt;TABLE_NAME&gt;.&lt;FIELD_NAME&gt;]", 
			"datatype": "&lt;DATATYPE&gt;", 
			"title": "", //optional 
			"widgetTitleTemplate": "" //optional 
			},
			{
			"index": 0, 
			"dim": "[&lt;TABLE_NAME&gt;.&lt;FIELD_NAME&gt;]", 
			"datatype": "&lt;DATATYPE&gt;", 
			"title": "", //optional 
			"widgetTitleTemplate": "" //optional 
			}
			]
			}
			]
		});</pre>
</li>
<li>In the script pasted in the previous step, replace the following placeholders with the relevant values: “maxItemsBeforeSubMenuIsCreated”: When total count of dimensions exceeds this value, the list of dimensions in the context menu will be placed under submenu. The default value is 5. 
“panel”: “&lt;PANEL&gt;” Define the panel name according to the switchable field’s location in the widget (the panels are located on the right side when editing a widget). 
&#8220;index&#8221;:  The field to change in the panel. &#8220;0&#8221; represents the first field, &#8220;1&#8221; represents the second field, &#8220;2&#8221; represents the third field, and so on. 
“affectAllWidgets”: Boolean value. If this value is true, switching dimension will be applied for every widget from a dashboard which has the same panel as the one from the configuration. The default value is false. 
“dim”: The dimension to be switched to. This property is case sensitive. 
“datatype”: Dimension data type. It’s important to set correct the datatype. Allowed datatypes include “datetime”, “text”, “numeric”. 
“title”:”&lt;TITLE&gt;” Edit the title of the field. This is displayed when right-clicking to switch dimensions. 
“widgetTitleTemplate”: A string template that enables dynamic widget titles to be displayed. When defined, a widget title will be dynamically changed according to the given template. The template must contain a {{dim}} variable that will be automatically replaced with the dimension title. The default value is the dimension title.</li>
<li>Click Apply to save your changes and refresh the dashboard to display your switchable options.</li>
</ol>
Example 1 
The widget script below allows you to switch between Country, Brand &amp; Category, and by week for the Categories panel and Age Range, Gender for the Break-by panel. Switching between dimensions in the Break-by panel will affect all widgets from a dashboard that has the Break-by panel.
<pre>prism.registerSwitchDimension(
 { 
 widget: widget, 
 dimensions: [ 
 { 
 panel: ‘categories’,
 dims: [ 
 { 
 “index”:0,
 “dim”:” [country.Country]”,
 “datatype”: “text”,
 “title”:”Country”
 }, 
 { 
 “index”:0,
 “dim”:”[brand.Brand]”,
 “datatype”: “text”,
 “title”:”Brand” 
 }, 
 { 
 “index”:0,
 “dim”:”[category.Category]”,
 “datatype”: “text”,
 “title”:”Category”
 }, 
 {
 “index”:0,
 “dim”:”[dimDate.Date]”,
 “level”: “weeks”,
 “datatype”: “datetime”,
 “title”:”Weeks” }]},
 { 
 panel: ‘break by’,
 affectAllWidgets: true,
 dims: [ 
 { 
 “index”:0,
 “dim”:”[Commerce.Age Range]”,
 “datatype”: “text”,
 “title”:”Age range” },
 { 
 “index”: 0,
 “dim”: “[Commerce.Gender]”,
 “datatype”: “text”,
 “title”: “Gender” 
 } 
 ] 
 } 
 ] 
 });</pre>
Example 2 
The widget script below allows you to switch between two dimensions: Date (in weeks) &lt;-&gt; Strategy
Where:
<ul>
<li>&#8220;Date&#8221; is a date column</li>
<li>&#8220;Strategy&#8221; is a text column</li>
</ul>
There are two things you need to adjust in your Switchable Dimension code: 
1. Add (Calendar) to the &#8220;dim&#8221; parameter for any date. For example:
<pre>    {
        "index":0,
        "dim":"[Commerce.Date (Calendar)]",
        "datatype": "datetime",
        "title": "Weeks"
    }</pre>
2. Add level parameter to the Date dim, which correspond to the required time granularity:
<pre>{
        "index":0,
        "dim":"[Commerce.Date (Calendar)]",
        "level": "weeks",
        "datatype": "datetime",
        "title": "Weeks"
}</pre>
As a result, your script will look like this:
<pre>prism.registerSwitchDimension({
   widget: widget,
   dimensions: [
      {
           panel: 'categories',                                    
           dims: [

              {
                 "index":0,
                 "dim":"[dimDate.Date (Calendar)]",
                 "datatype": "datetime",
                 "title":"Weeks",
                 "level": "weeks" 
              },
              {
                 "index":0,
                 "dim":"[dimStrategy.strategy]",
                 "datatype": "text",
                 "title":"strategy"
              }
            ]
        }
   ]
});</pre>

Leave Feedback