<img src="https://trc.taboola.com/1278851/log/3/unip?en=page_view" width="0" height="0" style="display:none">
finding octane

Sandbox comparison on Planning Analytics Workspace

0
5 min

Sandbox, also known as Personal Workspace is your personal work area where you can edit the data values as many times as you want and keep the changed data separate from the base data. Sandboxes and Personal Workspaces are private to each user and cannot be seen by other users. Your data values are viewable to others only when you commit them back to the base data. A Personal Workspace is a ...

Sandbox, also known as Personal Workspace is your personal work area where you can edit the data values as many times as you want and keep the changed data separate from the base data.

Sandboxes and Personal Workspaces are private to each user and cannot be seen by other users. Your data values are viewable to others only when you commit them back to the base data. A Personal Workspace is a special, default sandbox that is unnamed and always where you work if that capability is turned on.

 

To find out more about Sandbox, go the following link:

https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ug.2.0.0.doc/c_usingsandboxes_gf2004.html

 sandbox.png

The first thing that must be done for using Sandbox comparison functionality is to enable the config parameter in tm1s.cfg file.

Set the config parameter, EnableSanboxDimension=T

This is a dynamic parameter so server restart is not required.

Once the parameter is set, expand the Dimensions within the cube and you will find a new virtual dimension called “Sandboxes”. This dimension stores all the sandboxes you’ve created in PAW.

 Sandbox1.jpg

  

Select Create Sandbox

 Sandbox2.jpg

 

Provide name for sandbox and Click at icon next to BASE to use the values from Base data as a starting point

 Sandbox3.jpg

Below figure shows worst case sandbox created

Sandbox4.jpg 

Below figure shows the Worst Case data being overwritten from 6,370,750 to 6,000,000

 Sandbox5.jpg

You may toggle between Base data and Sandbox data using the drop down menu. Select Base from the menu to see the base data

 Sandbox6.jpg

 

Below figure shows the amount 6,370,571 which hasn’t changed

 Sandbox7.jpg

Drag and drop Sandboxes Virtual dimension to Column definition to compare the Sandbox data with Base data

 Sandbox8.jpg

Click at Sandboxes dimension and select Edit this set from drop down

 Sandbox9.jpg

Bring the Worst Case Sandbox to right pane by clicking the Insert arrow

 Sandbox10.jpg

 

Click Apply and Close

 

The Sandbox and Base data can now be viewed side by side for comparison

 Sandbox11.jpg

You may additionally create multiple sandboxes for perform various what-if analysis on your data in real-time.  You can also create calculations on top of your base and sandbox data for variance analysis.

 

Control and click Base and Worst Case labels

Sandbox12.jpg 

Select Base – Worst Case within Arithmetic calculations section and give a name to the calculation

 Sandbox13.jpg

The resultant view shows the variance of Base and Worst Case Data.

 Sandbox14.jpg

 

 

Written by:

Amin Mohammed [Senior TM1 Consultant]

logo (1).jpg    IBM.png

 

Leave a comment

Got a question? Shoot!

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Get more articles like this delivered to your inbox