File and folder properties


1. Overview

Each item you create in Dundas BI is treated as a file, including data connectors, metric sets, and dashboards, and these are organized into folders and projects.

The Properties dialog lets you view and edit the properties associated with a selected file, folder, or project. You can view the references to and from a file, modify security settings, and roll back to a previous version in the revision history.

2. Launching the Properties dialog

To launch the Properties dialog, select a file, folder, or project when opening a file from the main menu, or from the Explore window. Right-click (or long-tap) and select Properties from the context menu that appears.

Launching the Properties dialog for a data cube
Launching the Properties dialog for a data cube

3. Properties you can view and edit

The Properties dialog lets you view and edit the following properties:

  • Name - Rename the item.
  • Description - Add your own descriptive text, displayed in the item's tooltip.
  • Tags - Add tag words to help categorize your files and find them when searching.

View and edit properties of a data cube
View and edit properties of a data cube

3.1. Using tags

To add a tag to the file or folder, just type a word in the Tags box and press the Enter or Space key. You can also use the auto-complete menu that appears as you type to select an existing tag in the system.

You can remove a tag by clicking the x button beside the tag (unless the tag is inherited for a file from one of its containing folders).

Add tags to a dashboard
Add tags to a dashboard

Once you've added tags, you can search by them in the Explore window on many screens or in other file explorers such as in Open dialogs.

Files can be found by the tags set either on the file, or (in version 8.0.2 or later) one of its containing folders.

4. Read-only properties

Further down are various read-only properties:

  • ID
  • Location
  • Type
  • Subtype
  • Created By
  • Created Time
  • Last Modified Time
  • Checked Out To - (if applicable)

The ID property is needed when writing scripts that reference items such as a metric set or dashboard.

Read-only properties of a data cube
Read-only properties of a data cube

5. Revision history

Revision history is the version control mechanism built-in to Dundas BI. Scroll all the way down in the Properties dialog, and then click Revision history.

The Revision History dialog lists all of the revisions or changes that happened to this item. Each revision corresponds to a check in by a specific account, or an event such as the initial file creation. For more information about checking in items, see the Check in, check out and auto saving article.

Revision history
Revision history

5.1. Roll back to a previous revision

From the Revision History dialog, you can roll back the file to a previous revision by clicking the corresponding button in the Roll Back column. This is useful if, for example, you are not happy with recent changes made to a dashboard and you want to revert it to an earlier state.

In the revision history, click the Roll Back button corresponding to the revision you want to go back to.

New revision added corresponding to roll back
New revision added corresponding to roll back

The current file will be checked out if necessary, updated with the contents of the chosen revision, and then checked in automatically. This will create a new revision for the file.

6. References to and from the file

Scroll all the way down in the Properties dialog, and then click References to see a list of other items that reference (i.e., have a dependency on) the current file, and items that the current file itself references (i.e., references by this file).

References dialog for a data cube
References dialog for a data cube

This can show the 'data lineage', tracing the data displayed in a dashboard back through each item to its source, or vice versa.

6.1. Show recursive references

By default, only direct references to and from the current file (e.g., data cube) are shown. If you want to see all references (including references to references), select the Show Recursive References option. For example, use this option to find out what data connectors are ultimately being used by a dashboard where a data cube and metric set are also used.

7. Security privileges

To set security privileges on the file, folder, or project, scroll all the way down in the Properties dialog, and then click Security.

The Security dialog presents a list of accounts and groups. For each account or group, you can allow or deny various privileges (e.g., Read, Write, Delete).

The Full Control privilege is required on an item to change its security privileges unless you are an administrator. Full Control is automatically granted to the account that created it but can be removed afterward if required.

A deny assignment set for an account or one of its groups always takes precedence and cannot be overridden by assigning allow without removing the deny assignment. The account or one of its groups must also have allow assigned for a privilege for it to be granted. Note that administrators have all privileges and are not effectively denied any privilege.

By setting privileges in the properties for a folder or the project, you can configure all the contained files at once. To create new subfolders, right-click a folder and choose New Folder, then right-click files to Cut and Paste (or drag files while holding Shift).

7.1. List of security privileges

Delete The privilege to delete a file.  
Execute The privilege to execute a file.

This privilege has to be granted on anything that acts as a data source:

  • The data cube used in a metric set or dashboard/view.
  • The data connector used in a data cube, metric set, or dashboard/view.
  • The database table, view, etc. composing the data connector.

For example: to use a metric set, the underlying data cube, data connector, and tables must have at least an Execute privilege.

A manual select ignores the privileges on the native structure of a data connector (tables, views, etc.).

Full Control The privilege to fully control a file.

Full Control implies everything.

If this privilege is granted on a project, it automatically implies that the assignee of the privilege is a "project administrator" for that project. Project administrators implicitly have the Full Control privilege granted on anything contained in that project.

List Folder Contents The privilege to list all items in a folder. Read is implied by List Folder Contents.
Modify Folder The privilege to modify a folder's properties and create child items. Read is implied by Modify Folder.
Read The privilege to see a file and its contents. Execute is implied by Read.
Write The privilege to update the contents of a file. Read is implied by Write.

7.2. Add an account or group to the list

In order to give privileges to an account or group, you must add them to the security list. If you don't see the account or group in the list, click Add.

Add an account or group to the security list
Add an account or group to the security list

7.3. Give file privileges to an account or group

Select an account or group in the security list, and then set Allow or Deny for each privilege to the right.

Set file privileges for selected account
Set file privileges for selected account

The Inherit Privileges checkbox determines whether to inherit privileges from a parent file or folder. When a privilege is inherited, a blue information icon appears that you can click to find out where it was set.

Deleting an account or group does not automatically remove privileges that were assigned on files or folders.

8. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri