Data Catalog in Analytical Designer
Data Catalog in Analytical Designer contains attributes, facts, and metrics that are available for your insights.
Data Catalog has three tabs that display one of each type - facts, metrics, or attributes.
To add items from the Data Catalog to your insight, drag and drop them into the appropriate section in the insight. For details about creating insights, see Create Insights.
Data Catalog displays only items that are relevant to your insight. Items that cannot be added are hidden. Analytical Designer then displays a message in Data Catalog to inform you. For details, see the FAQ section below.
Search for items
You can use the search bar in the Data Catalog to search for facts, metrics, and attributes you need.
Analytical Designer scans all item names and displays any item that contains your search string.
If you organize your catalog, Analytical Designer scans also the group names. For details, see Organize Data Catalog.
When you switch to another tab, the search results adjust to correspond with the items to be displayed in that tab.
Refresh Data Catalog
To refresh the data in your Data Catalog, hover your mouse over the catalog to display the refresh button and click the button.
Analytical Designer retrieves all changes, displays the number of items changed and also refreshes the insight to reflect the changes.
Organize Data Catalog
All facts, metrics, and attributes in Data Catalog are sorted alphabetically in a single list.
To help users find related items and group these visually, administrators can use the
ADCatalogGrouping platform setting. For details, see Configure Various Features via Platform Settings.
By default, the
ADCatalogGrouping is set to
To group facts, metrics, and attributes, you have the following two options:
- Group using folders The platform setting value is
- Group using tags The platform setting value is
Both options are visually the same. For differences, see the sections below.
Groups and items within the groups are sorted alphabetically.
Items that do not belong to any group are displayed in Ungrouped. Ungrouped is always the last group in the list.
For details about editing platform settings, see Configure Various Features via Platform Settings.
Group by folders
Use folders if you want to localize their names in Analytical Designer. Folder names can contain special characters and capital letters, however, one item can belong only to a single folder/group.
To group by folders, set the
ADCatalogGrouping platform setting to
ByFolders. For details, see Configure Various Features via Platform Settings.
For details about localization, see Metadata Localization.
Group by tags
Use tags if you want to add an item to multiple groups and do not need localization.
You can add tags in the Manage section in GoodData Portal. For details, see Add a Tag to a Fact, Add a Tag to a Metric, and Add a Tag to an Attribute.
Tags can contain only lowercase letters and no white spaces. To display user-friendly group names, GoodData offers a parsing mechanism as follows:
- The tags must start with
_(underscore) character is replaced by a white space
- Each letter after
_(underscore) is capitalized
adgroup_web_analytics= Web Analytics
- To capitalize a letter inside a word, use
adgroup_campaign^a_donations= CampaignA Donations
- To start a word with a lowercase letter, add
__(two underscores) before the word
adgroup_spend__analysis= Spend analysis
To group by tags, set the
ADCatalogGrouping platform setting to
ByTagNamingConvention. For details, see Configure Various Features via Platform Settings.
Default folder state
By default, all folders in your Data Catalog are collapsed. If you want to have all items within the groups visible whenever you access Analytical Designer, set the
ADCatalogGroupsExpanded platform setting to
For details, see Configure Various Features via Platform Settings.
Add items to Data Catalog
You can add new items by:
- Uploading a CSV file with your data to add new items to your Data Catalog. For details, see Load CSV Files to Your Workspace.
- Clicking Create metric at the bottom of the catalog to use an editor. For details, see Create and Save a Metric.
For other details, see the Analytical Designer - Frequently Asked Questions.