Choosing which language to display

Starting with Arc v1.4.1, Arc supports now English, Spanish, German and French. Arc will display the language defined in your web browser settings.

If you are using Chrome, you can filter Chrome’s settings to show only settings related to “language”, the language used by Arc will the first one in the list. In the example below Arc will display English:

To use the French language instead, just move French to the top of the list:

You then just need to refresh Arc and it will now display the new language:

All other languages than German, Spanish and French will display in English.

Upgrading Arc for TM1

Upgrading Arc for TM1 is very simple as Arc does not require any installation, you will just need to replace your current Arc file with the new one.

To download the latest version, go to the Arc download page:

Unzip the folder and you will find the arc.exe file (if you downloaded the Windows version).

There are two ways of starting Arc, you can either start it as a local prompt by just double clicking on the arc.exe file:

If Arc is currently running as a Windows service, you will have to stop the service first, replace the arc.exe file and then start the service.

That’s it!

Just go to the Arc URL, by default it is servername:7070 and you will be able to use the new version of Arc.

If Arc is just open as a local prompt, just close it, replace the arc.exe file and double click into the new arc.exe file.

That’s it!

A new tab will open with the new version of Arc.

Tips: If you double click on the arc.exe file and nothing shows up, it is likely due to the fact that Arc might already by running as a service or someone else has already started it.

Arc System Requirements

Arc Prerequisites

Arc is multi-platforms, it supports Windows, Linux and Mac OS.

Arc is officially supported on TM1 11+ (Planning Analytics 2+). Most features will work with TM1 10.2.2 but a number of important APIs are only present in TM1 11+.

The TM1 REST API is required for Arc to work, it can be enabled by setting the HTTPPortNumber parameter in the tm1s.cfg file, i.e. HTTPPortNumber=8111. See: code.cubewise.com/blog/enabling-the-tm1-rest-api.

To enable Turbo Integrator debugging you must also add EnableTIDebugging to the tm1s.cfg file, i.e. EnableTIDebugging =true You need to restart the TM1 service for these settings to take effect.

Server Configuration

Arc supports all TM1 security modes that require a password, Windows Authentication and CAM Single Sign On is not supported at this stage.

Web Browser

  • Internet Explorer 10+

  • Any other modern browser: Firefox, Chrome, Safari, etc.

Getting Started

Prerequisites

TM1 version

Arc is officially supported on TM1 11+ (Planning Analytics 2+). Most features will work with TM1 10.2.2 but a number of important APIs are only present in TM1 11+.

TM1 Rest API Enabled

The TM1 REST API is required for Arc to work, it can be enabled by setting the HTTPPortNumber parameter in the tm1s.cfg file, i.e. HTTPPortNumber=8111. See: code.cubewise.com/blog/enabling-the-tm1-rest-api

Debugging

To enabled Turbo Integrator debugging you must also add EnableTIDebugging to the tm1s.cfg file, i.e. EnableTIDebugging =true

You need to restart the TM1 service for these settings to take effect.

Server configuration

Arc supports multiple platforms (Windows, Linux and Mac). It can be run as either a standalone application or a service. There are additional dependencies.

TM1 security

Arc supports all TM1 security modes that require a password, Windows Authentication and CAM Single Sign On is not supported at this stage.

Where to install Arc

Arc should be installed on the same server that TM1 is running, this allows Arc to access both the ODBC data sources and text files on the TM1 server. If you install Arc on a desktop or separate server Arc will function as normal with the exception of the ODBC and Text preview in Turbo Integrator processes for TM1 10.2 FP7 and earlier versions.

Getting started with Arc

Arc requires just a few minutes to setup, just pick the instructions below based on the platform where Arc will be installed:

Adding Arc path to the linux user's environment

To execute Arc, just by typing arc in the command line, you need to add Arc path to the user’s environment.

Arc is in a separate folder inside $HOME/utilities/arc

Open bash_profile file by typing vim ~/.bash_profile:

Once editing the .bash_profile file with the text file editor of your preference, ensure that path to the arc executable is set in the Path, in the following example we defined the variable ARCPATH  pointing to /home/ec2-user/arc and then adding ARCPATH to the PATH:

  • ARCPATH=$HOME/utilities/arc

  • PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ARCPATH

Then refresh the environment variables of the user by executing Executing:

source ~/.bash_profile

The user will now being able to execute arc using arc from any location, without specifying the PATH.

To execute arc in the background, use the command: arc&

Getting started with Arc on Windows

Since Arc v1.3.0, Arc is on available on multiple platforms (Windows, Linux and Mac). This article explains the steps to getting started with Arc on Mac.

Download Arc for Windows

  1. Go to code.cubewise.com/arc-download

  2. Download the correct Arc version, in this example we download Windows 64 bits:

Starting Arc

  1. Unzip the arc.x.x.x_win64.zip folder

  2. To execute Arc, just double click on the arc.exe file

If you see the message “Server running on port: 7070”, it means that Arc started successfully.

To access it, opens a web browser and go to the URL https://localhost:7070/. If this is the first time Arc is starting on your Mac you will see this:

Trialling or Buying Arc

If this is the first time, Arc starts on your laptop, you will then need to validate your license by either trialling or Buying Arc:

Connect to TM1 instances

Arc uses the TM1 REST API to connect to IBM TM1 and Planning Analytics instances, therefore it can connect to any instances assuming the TM1 REST API is enabled for this instance and the httpPortNumber is open on the server.

To access all TM1 instances on a specific server, you will need to update the adminhost parameter in the settings.yml file:

To connect to an instance on the IBM Could, follow the instructions in this article:

If Arc can’t connect to your TM1 instances:

  1. Check first that you can access the TM1 REST API using your browser.

  2. Double check your credentials (CAM Namespace is case sensitive).

Setting up Arc as a Windows service

Where to find support?

If you still can’t connect to your instances, create a new issue on GitHub:

Getting started with Arc on Linux

Since Arc v1.3.0, Arc is on available on multiple platforms (Windows, Linux and Mac). This article explains the steps to getting started with Arc on Mac.

Download Arc for Linux

  1. Go to code.cubewise.com/arc-download

  2. Download the correct Arc version, in this example we copy the download link for the Linux 64 bits:

linux1.png

Starting Arc

  1. You can use the the wget command to download.

  2. Unzip the arc_linux.zip folder

  3. AssigTn executable permissions  to arc using the command: chmod +x arc

  4. To execute Arc, use the command ./arc.

After this, arc should accessible through the port https://servername:7070

Trialling or Buying Arc

If this is the first time, Arc starts on your laptop, you will then need to validate your license by either trialling or Buying Arc:

Connect to TM1 instances

Arc uses the TM1 REST API to connect to IBM TM1 and Planning Analytics instances, therefore it can connect to any instances assuming the TM1 REST API is enabled for this instance and the httpPortNumber is open on the server.

To access all TM1 instances on a specific server, you will need to update the adminhost parameter in the settings.yml file:

To connect to an instance on the IBM Could, follow the instructions in this article:

If Arc can’t connect to your TM1 instances:

  1. Check first that you can access the TM1 REST API using your browser.

  2. Double check your credentials (CAM Namespace is case sensitive).

Getting started with Arc on Mac

Since Arc v1.3.0, Arc is on available on multiple platforms (Windows, Linux and Mac). This article explains the steps to getting started with Arc on Mac.

Download Arc for Mac

  1. Go to code.cubewise.com/arc-download

  2. Download the correct Arc version, in this example we download Mac 64 bits:

To find out if you need 32 or 64bit version, Go to the Apple Menu and select "About this Mac". If you have a Core Duo processor, you have a 32-bit CPU. Otherwise (Core 2 Duo, Xeon, i3, i5, i7, anything else), you have a 64-bit CPU.

Starting Arc

  1. Unzip the arc.x.x.x_mac64.zip folder

  2. In the example below we copied the arc.app file into a new Arc folder in Documents.

  3. Open Mac Terminal

  4. Navigate to the folder where arc.app is, using the command cd

  5. Once in the folder, to start Arc type ./arc.app &

If you see the message “Server running on port: 7070”, it means that Arc started successfully.

To access it, opens a web browser and go to the URL https://localhost:7070/. If this is the first time Arc is starting on your Mac you will see this:

Trialling or Buying Arc

If this is the first time, Arc starts on your laptop, you will then need to validate your license by either trialling or Buying Arc:

Connect to TM1 instances

Arc uses the TM1 REST API to connect to IBM TM1 and Planning Analytics instances, therefore it can connect to any instances assuming the TM1 REST API is enabled for this instance and the httpPortNumber is open on the server.

To access all TM1 instances on a specific server, you will need to update the adminhost parameter in the settings.yml file:

To connect to an instance on the IBM Could, follow the instructions in this article:

If Arc can’t connect to your TM1 instances:

  1. Check first that you can access the TM1 REST API using your browser.

  2. Double check your credentials (CAM Namespace is case sensitive).

Where to find support?

If you still can’t connect to your instances, create a new issue on GitHub:

Generating an Arc license

These instructions are for customers who have purchased Arc. If you are new to Arc and just want to try it out see this article on setting up a trial:

Click the Buy Now button

To generate the license you need first to click the Buy Now button:

If you get the message below, it means that the browser does not have an internet connection. If you are accessing Arc in a browser on a server using remote desktop try instead using a browser on your desktop or laptop. To do this use the server name and port like so: http://ServerName:7070 (Remember to change ServerName to your server). You may have to open a the 7070 port in the servers firewall.

The steps to generate an Arc license without internet connection are defined here:

Continue reading through this article if you are seeing this:

Request License from Existing Account

To request a license, you can use either the customer ID received by email or enter the email used to buy the subscription:

After clicking the request license button, an email (from software@cubewise.com) will be sent to the email used to purchase the subscription with the License ID:

To validate the license, copy the License ID from the email and paste it in the Validate License tab:

If the Buy Now button disappears, it means that your license is now active:


Generating an Arc license without internet connection

Arc cannot generate the license if the browser you are using does not have internet connection.

Generating a license from Arc

You will need to find a browser which has access to internet. Then access Arc replacing in the URL localhost with the server name where Arc is intalled (http://servername:7070).

If you can’t find a browser with internet connection and can access Arc, jump to the next section below Generating a license from the license server.

Click again the Buy Now button and you should now see this:

You can now go to the Request License tab, enter the customer ID received by email or enter the email used to buy the subscription:

After clicking the request license button, an email will be sent (from software@cubewise.com) to the email used to purchase the subscription with the License ID:

To validate the license, copy the License ID from the email and paste it in the Validate License tab:

If the Buy Now button disappears, it means that your license is now active.

Generating a license from the license server

If you try to request the license from Arc and you don’t have internet connection, you will get the message below:

As it is described in the message you can request a new license to the license server without using Arc.

To do that go to https://bo.cubewise.com/license-request, input your Customer ID or email and copy the MachineID and Signature from the Buy Now window (as above) and paste it into the Generate license page and finally click the Request License button:

An email will be sent to the email entered containing the License ID.

To validate the license, you can either do it from the Buy Now button in Arc, but if Arc does not have access to internet you will get the following message:

arc-offlline-3.png

To validate the license from our website just go to https://bo.cubewise.com/license-validate, paste your License ID and click the Validate button:

You will now being able to download the License.json and License.xml files by clicking on the Download buttons:

Then grab these two files and paste them into the Arc folder:

Now just refresh the browser and you should be able to use Arc now.

Parent article:

Arc shortcut keys

Arc is full of features to speed-up your developments, one of them is the use of shortcuts. This article contains the list of available shortcuts in Arc.

Menu

Windows/Linux Mac Description
Ctrl-M Command-M To hide/show the menu
Alt-M Option-M To go to the search

Rules and TI Editor

Debugging

Windows/Linux Mac Description
F5 F5 Continue
F10 F10 Step Over
F11 F11 Step in
Shift-F12 Option-F12 Step Out

Main Shortcut Keys

Windows/Linux Mac Description
Ctrl-X Command-X Cut
Ctrl-C Command-C Copy
Ctrl-P Command-P Paste
Ctrl-Space Command-Space Snippets
Ctrl-S Command-S Save
Ctrl-Shift-E Command-Option-E Execute

Line Operations

Windows/Linux Mac Description
Ctrl-D Command-D Remove line
Alt-Shift-Down Command-Option-Down Copy lines down
Alt-Shift-Up Command-Option-Up Copy lines up
Alt-Down Option-Down Move lines down
Alt-Up Option-Up Move lines up
Alt-Delete Option-Delete Remove to line end
Alt-Backspace Command-Backspace Remove to linestart
Ctrl-Backspace Option-Backspace, Ctrl-Option-Backspace Remove word left
Ctrl-Delete Command-Delete Remove word right
--- Ctrl-O Split line

Selections

Windows/Linux Mac Description
Ctrl-A Command-A Select all
Shift-Left Shift-Left Select left
Shift-Right Shift-Right Select right
Ctrl-Shift-Left Option-Shift-Left Select word left
Ctrl-Shift-Right Option-Shift-Right Select word right
Shift-Home Shift-Home Select line start
Shift-End Shift-End Select line end
Alt-Shift-Right Command-Shift-Right Select to line end
Alt-Shift-Left Command-Shift-Left Select to line start
Shift-Up Shift-Up Select up
Shift-Down Shift-Down Select down
Shift-PageUp Shift-PageUp Select page up
Shift-PageDown Shift-PageDown Select page down
Ctrl-Shift-Home Command-Shift-Up Select to start
Ctrl-Shift-End Command-Shift-Down Select to end
Ctrl-Shift-D Command-Shift-D Duplicate selection
Ctrl-Shift-P --- Select to matching bracket

Multicursor

Windows/Linux Mac Description
Ctrl-Alt-Up Command-Option-Up Add multi-cursor above
Ctrl-Alt-Down Command-Option-Down Add multi-cursor below
Ctrl-Alt-Right Command-Option-Right Add next occurrence to multi-selection
Ctrl-Alt-Left Command-Option-Left Add previous occurrence to multi-selection
Ctrl-Alt-Shift-Up Command-Option-Shift-Up Move multicursor from current line to the line above
Ctrl-Alt-Shift-Down Command-Option-Shift-Down Move multicursor from current line to the line below
Ctrl-Alt-Shift-Right Command-Option-Shift-Right Remove current occurrence from multi-selection and move to next
Ctrl-Alt-Shift-Left Command-Option-Shift-Left Remove current occurrence from multi-selection and move to previous
Ctrl-Shift-L Command-Shift-L Select all from multi-selection

Go To

Windows/Linux Mac Description
Left Left, Ctrl-B Go to left
Right Right, Ctrl-F Go to right
Ctrl-Left Option-Left Go to word left
Ctrl-Right Option-Right Go to word right
Up Up, Ctrl-P Go line up
Down Down, Ctrl-N Go line down
Alt-Left, Home Command-Left, Home, Ctrl-A Go to line start
Alt-Right, End Command-Right, End, Ctrl-E Go to line end
PageUp Option-PageUp Go to page up
PageDown Option-PageDown, Ctrl-V Go to page down
Ctrl-Home Command-Home, Command-Up Go to start
Ctrl-End Command-End, Command-Down Go to end
Ctrl-L Command-L Go to line
Ctrl-Down Command-Down Scroll line down
Ctrl-Up --- Scroll line up
Ctrl-P --- Go to matching bracket
--- Option-PageDown Scroll page down
--- Option-PageUp Scroll page up

Find/Replace

Windows/Linux Mac Description
Ctrl-F Command-F Find
Ctrl-H Command-Option-F Replace
Ctrl-K Command-G Find next
Ctrl-Shift-K Command-Shift-G Find previous

Other

Windows/Linux Mac Description
Tab Tab Indent
Shift-Tab Shift-Tab Outdent
Ctrl-Z Command-Z Undo
Ctrl-Shift-Z, Ctrl-Y Command-Shift-Z, Command-Y Redo
Ctrl-, Command-, Show the settings menu
Ctrl-/ Command-/ Toggle comment
Ctrl-T Ctrl-T Transpose letters
Ctrl-Enter Command-Enter Enter full screen
Ctrl-Shift-U Ctrl-Shift-U Change to lower case
Ctrl-U Ctrl-U Change to upper case
Insert Insert Overwrite
Ctrl-Shift-E Command-Shift-E Macros replay
Ctrl-Alt-E --- Macros recording
Delete --- Delete

Where to find support for Arc?

We would like to involve the TM1 community as much as possible into Arc developmets so we decided to put the Arc support public. The support for is public on our support platform https://support.cubewise.com/code/arc/issues.

From this repository, you can view all opened/closed tickets, submit new enhancements or report a bug:

All tickets are flagged with different labels which indicate the ticket status (planned, possible, closed...). To see all closed tickets, you just need to click on "Closed" just next to "Open".

How to create a ticket?

To submist an enhacement request, report a bug or just asking a question, you can open a new issue in cubewise-code/arc-issues.

1 - Create a new issue

To create a new issue, you will have to create a GitHub account (It is very quick and free). Once you are logged in to Github, you should be able to see the green New issue button on the top left

2 - Submit a new issue

You will then need to add the title and the content. To avoid back and force emails, you would need to add the following information:

  • Ticket title.

  • Arc and TM1/PA version number.

  • Desciption of the issue.

  • Steps to reproduce the issue.

Finally click on the Submit issue button, you will then receive an email once we replied to you.

Trialling and Buying Arc

IMPORTANT: To trial, buy or update licenses the browser hosting the Arc user interface needs to be able to access the internet. If you are accessing Arc on a server it is possible that you will not be able to connect to the internet, if you have issues connecting try using your desktop computer instead.

1. Download Arc

To purchase Arc, you will need first to download it. The latest version of Arc will always be available on the Arc download page:

2. Start Arc

Once downloaded, unzip the folder and copy arc.exe file into the folder where you want to install Arc. In this example we copy Arc to C:\Arc folder:

To start Arc, just double click on the arc.exe.

Arc can be installed as a Windows service by following the steps described in this article:

3. Start Trial

Once started you can access Arc using the URL http://localhost:7070 if you are on the server or http://ServerName:7070 to access it from your desktop (replace ServerName with the name of your server):

NOTE: Arc will show the available TM1 instances only after starting a trial or purchasing Arc.

You will need to choose if you are an organization or an individual and you will then have to agree to the terms and conditions by clicking Agree and Start Trial:

You should now be able to see your TM1 instance on the left hand side:

arc-license7.png

4. Buy Now button

Once the trial period has expired to continue using Arc you will have to purchase a subscription by clicking to the Buy Now button:

Step 1: Choose between Organization and Individual

The first step in the purchase process is to select if you are an organization or an individual/contractor/consultant:

Step 2: Choose the subscription type

If you selected an organization, you will be able to choose between a monthly or yearly fee. Only the Monthly option is available to an individual:

Step 3: Agree to the license agreement

The third step is to agree to the license terms by clicking Agree to Terms:

Step 4 of 5: Customer Details

The fourth step is to enter your email. This is the email which will receive al information about the subscription.

If you have selected an organization, you will be able to choose how many users you want to purchase. You need to buy a user for each TM1 developer/administrator that will be accessing Arc. You can change the number of users after you purchase Arc.

Step 5 of 5: Payment Method

In the last step, you can either enter the credit card detail to the card which will be charged every month or year depending on your subscription or choose the offline payment option. When using a credit card you will be sent a notification 3 days before the subscription is renew so you can cancel if required.

NOTE: Credit card is the preferred payment method, it will allow you to use Arc immediately.

If you choose the Offline Payment option, an invoice with payment details will be sent to the email entered in the contact details.

NOTE: Your subscription starts immediately, licenses will ONLY be able to be generated when we can verify payment has been made.

After clicking on the Start Yearly button, you will then receive an email with information about your Customer ID:

Request License from Existing Account

To generate an Arc license, go to the following article:

Managing sessions timeout

To manage sessions timeout, Arc uses the HTTPSessionTimeoutMinutes parameter of the tm1s.cfg. This parameter sets the timeout authentication of TM1 REST API queries.

This parameter is defined per TM1 servers, the default value is 20 min.

To increase the timeout to 40 min for a specific instance, open the tm1s.cfg and add the new parameter HTTPSessionTimeoutMinutes=40. A server restarts is not necessary as this parameter is dynamic.

Building a new Hierarchy with a new process

In this article you will learn how to build a new Hierarchy based on attribute values.

We will be using Cubewise’s “Arc” IDE (Integrated Development Environment), but the concepts can be applied with any Hierarchy-aware TM1 editor e.g. the TI editor in PAW.

In this article you will learn how to build a new Hierarchy based on attribute values by building a new process with Arc.

We will focus on the Employee dimension.

This dimension has currently only one Hierarchy, Employee. All employees have a Department Code attribute:

Our objective is to create a new Hierarchy in the Employee dimension called Actual 2018 Department, which contains all employees with their current department value.

We’ll start by creating a new TI process. To create new process in Arc, just click on the New Process button on the top right:

Then type the new process name,in this example we’ll name it Dim.Employee.BuildHierarchy.Department

Click Create, and Arc will present a new tab with the process name ready for editing. Arc follows the “traditional” TI editor conventions in Architect, so in the Data Source tab, select:

  • Type: TM1DimensionSubset

  • Dimension: Employee

  • Subset: Default

Click Preview and then the Create Variables buttons. You’ll notice that Arc already prefix the variable with a “v” (variable prefixes can be configured in Arc’s settings.yml):

Let’s continue editing the TI process by defining the constants in the Prolog tab, in order to build the Employee Hierarchy we want to create:

  • cDimSrc: our dimension source which is also our target dimension.

  • cSubsetSrc: The subset source that we are going to loop through.

  • cAttr: The attribute we need to build the consolidation.

  • cHierarchy: Hierarchy name.

  • cTotalHierarchy: The top consolidation of our new Hierarchy.

Working with TI’s new Hierarchy functions

To work with Hierarchies in Turbo Integrator processes (TIs), IBM Planning Analytics introduced a lot of new functions. Thankfully all new functions to work with Hierarchies are very similar as the ones to work with dimensions. For Hierarchies, you will almost find a one to one match to dimensions operations such as HierarchyExists instead of DimensionExists (to check if a Hierarchy exists).

Cubewise Arc facilitates your learning TI’s new Hierarchy functions with built-in code snippets. To see the available code snippets, hit CTRL + SPACE and type “exists”.

Arc will show you all snippets that contain the search string – we’ll use the “HierarchyExists” snippet.

Prolog tab

Before we create a new Hierarchy, we should first verify if it already exists. If it doesn’t we can simply go ahead and create it. If it does, we must delete all of its elements so we can recreate it.

Next, we insert the a new “C” element to represent the apex, or “total”, of the Hierarchy:

We want our TI to loop through all employees (all leaf elements in the Employee dimension). To do that we need first to create a subset that contains only the leaf elements of the dimension and then define this subset as data source of this TI.

We’ll use the open-source Bedrock library to do this, specifically the Bedrock.Dim.Sub.Create.Leaf process, as follow:

When using Arc, you will develop much faster if you are leveraging the snippets:

Metadata tab

Now let’s continue to the Metadata tab. In this tab, we are going to create all of the parent-child relationships for our new Hierarchy, as follows:

  • Total Department

    • Department

      • Employee

We do this by inserting each new element using HierarchyElementInsert, then making them components of the parent-child path using HierarchyElementComponentAdd. Again, note these new Hierarchy commands, and the method we are using to build a roll-up, are nearly identical to the legacy “dimension” counterparts:

Eplig tab

In the process Epilog, we just need to delete the temporary subset, cSubsetSrc we created during the Prolog:

Save the process and then execute it.

Open the Employee dimension, if it was already open, refresh your web browser to get the last changes.

In the Hierarchy dropdown, you should be able to see the new Hierarch we just created:

We used the Department Code to create the consolidation, which is not very meaningful, so let’s now create a descriptive alias on this Hierarchy.

Populating attribute values

We need first to insert an alias into the Hierarchy. We’ll do this in the Prolog tab with the following lines of code:

#Create Alias for Hierarchy
cAlias = 'Employee and Department Name';
AttrInsert(cDimSrc | ':' | cHierarchy, '', cAlias, 'A');

To avoid duplicate alias when creating a new attribute on a Hierarchy only, you could use the new function ElementAttrInsert instead of AttrInsert so the syntax will look like this:

  • ElementAttrInsert(cDimSrc, cHierarchy, '', cAlias, 'A');

The ElementAttrInsert function will avoid duplicate alias on one consolidation which appears in two Hierarchies of the same dimension.

IIn the Data tab, we will now grab the alias for department from the Product Category attribute of the Department dimension and for the employee we use the attribute Full Name.

To add an attribute value to a consolidation which exists only in a specific Hierarchy, you need to “qualify” that Hierarchy in the ATTRPUTS function as follows:

  • AttrPutS(vDepartmentAlias, cDimSrc | ‘:’ | cHierarchy, vDepartment, cAlias)

Instead of

  • AttrPutS(vDepartmentAlias, cDimSrc, vDepartment, cAlias)

If the Hierarchy name is not specified in the ATTRPUTS function, the target element vDepartment will be the one in the default Hierarchy (Department).

To send the value to the vDepartment in our new Hierarchy (cHierarchy), we use cDimSrc | ‘:’ | cHierarchy instead of just cDimSrc.

It can be noted that instead of using AttrPutS, we could have used the new TI function ElementAttrPutS:

  • ElementAttrPutS(vDepartmentAlias, cDimSrc, cHierarchy, vDepartment, cAlias)

Save and Execute the process.

Open the Employee dimension, if you don’t see the alias just refresh your browser:

Randomise your data in an instant

Why would you need to obfuscate/scramble your data?

The most common reason why you would need to obfuscate/scramble your data is if you need to send your data to third parties. One way to do it, is to randomize the values. The metadata (cubes, dimensions and elements names) will still be intact but the data will be randomised.
You could do it manually by doing a proportional spread but it could be time consuming if you are working on large cubes. A new way to randomise your data is now available with Arc and the randomisator plugin.

How does it work?

In just three quick steps, you will be able to randomise data for any cubes:

  1. Select the cubes you want to randomise.
  2. Select the target folder where the new .cub files will be created.
  3. Click Randomise button.

The plugin will create new .cub files in the target folder with random data. Therefore, there is no risk to mess-up your actual data as this plugin will create new .cub files.

See it in action!

Where to find it?

The randomisator plugin is not part of the default plugins when you install Arc. However it is part of the samples plugins which you can find on the cubewise-code/arc-plugins-samples github page.

How to set-it up?

To add one of these plugin to your Arc installation, you just need to download the folder from GitHub:

Paste it in your Arc/plugins installation folder:

Then refresh your browser and clear the cache. You should now be able to see it under Tools: