Open in ClaudeOpen in ChatGPT

Naming Guidelines

ObjectGuidelineNotesGood ExampleBad Example
Data SourcesA-Z a-z _, , NumbersMust be usable from DATA() functions. Avoid putting version information in the name and use the description instead.SALES_DATA_PRODUCTION, “GEM Data”
Dimension & LevelsA-Z a-z _Since level names are automatically matched, the levels should adhere to the same rules as Excel Column names.Location, Product_D, PRODUCT_D, PRODUCT, PRODUCT_CODEProduct-Code, 123Dim
Excel WorksheetsRecommended: A-Z, a-z, _ Append _DIM for Dimension SheetsNot enforced. Spaces, numbers and other characters are accepted, and a name with spaces works in DATA() as long as it is quoted exactly. Sticking to letters and underscores keeps formulas short and avoids surprises when a name is reused elsewhere.Sales, FTEs, Price and Volume2018-03
Excel Column NamesRecommended: A-Z, a-z, _Not enforced, the same as worksheet names. Column names are quoted in DATA() too.Volume, Number_of_Units_Sold
Excel FilenameThe filename has no implications for Valsight, as the Data Source name is used to access the file.
Was this page helpful?