Customize the behavior of the Add-On by changing the following options or settings:
- 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.
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 your chosen font color for new fetches within the range.
-
Publishable values will not overwrite any of your modified font colors within the range for subsequent fetches.
Learn why certain dimensions are excluded from publishing.
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.
Default Currency For New Range
Before you can set up a default currency for a new range, you must have multi-currency set up for your company. Learn how to set up multi-currency.
You can use Cube’s dimensions to build your range. Cube’s current default will use your company's default currency for every new range.
Drop-down currency default: Use the company's default currency
Creating a new range will default to using your company's default currency.
To set a default currency for the 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.
When it comes to publishing, it can only be done in the company's default currency.
Publish Permission For New Range
When "publish permission for the new range" is toggled on, each new range created 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.