Which Setting is Right for You?

Interested in adjusting your settings in the add-on? Cube gives users the ability to customize the behavior of the app by changing options or settings.

Settings List

• Retain font color on fetch
• Display zero as null on fetch
• Default currency for new range
• Publish permission for new range

You can update your settings by navigating to the hamburger icon and selecting Settings. 

Settings Options: Retain Font Color On Fetch

When writing fetched values, Cube’s current default is to display publishable dimension values in blue font and non-publishable dimension values in black font.

Toggle off: Use Cube font color preferences

• Publishable values will display as blue for new fetches within the range.

• Publishable values will overwrite any user modified font colors as blue within the range for subsequent fetches.

Toggle on: Retain user font color preferences

• Publishable values will display with user's chosen font color for new fetches within the range.

• Publishable values will not overwrite any user modified font colors within the range for subsequent fetches.

More about Non-Publishable Dimensions

Back to Settings List 

Settings Options:  Display Zero As Null On Fetch

When writing fetched values, Cube’s current default is to display zero values as zero and null values as empty cells. 

Toggle off: Display all existing values

• Zero values will display as zero for new fetches within the range.

• Null values will display as empty for new fetches within the range.

Toggle on: Display zero values as null

• Zero values will display as empty for new fetches within the range.

• Null values will display as empty for new fetches within the range.

 Back to Settings List 

Settings Options: Default Currency For New Range

How to set up Multi-currency

Before you can set up a default currency for a new range, you will need to have multi-currency set up for your company. 

You can use Cube’s dimensions to build your own range. Cube’s current default will use your company's default currency for every new range. 

Drop down currency default: Use company's default currency 

• Creating a new range will default to using your company's default currency.

Set default currency for new range: Select an available currency code from the drop down.

Note: This will change your default currency when creating a new range. This will not change your company's base currency.

Now when you create a new range, it will remain in your personalized default currency unless you change it in the header for that range. 

Reminder: Publishing to a range can only be done in the company's default currency

_________________________________________________________________________________________________________________________________

Settings Options: Publish Permission For New Range

The toggle in the figure above contains the 'default' state for your range permissions.  Which consist of allowing fetching and/or publishing to a specific range.

When "publish permission for new range" is toggled on (as it is in the earlier image), each new range the user creates will have "Allow Publishing Data" automatically enabled.  If the setting is toggled off (gray), each new range a user creates will have "Allow Publishing Data" automatically disabled.  

Back to Settings List