SMML Naming Conventions
SMML schema files and attributes follow specific naming conventions to enable effective mapping of objects in a semantic model and the SMML files that reference them.
SMML Schema Files
When you create a semantic model and add an object, Oracle Analytics generates the SMML schema file a JSON file. The file name matches the name of the object it represents. For example, if a database object is named Sample Data, then the SMML schema file is also named Sample Data. The object name and SMML schema file names match except in the case when the object name contains unsupported characters. See Object Naming Criteria for SMML Schema Files and Folders.
Attribute Names
Attributes names referenced in SMML files follow lower camel case format. For example, sourceType
.
Fully Qualified Names
Fully qualified names (FQNs) in a SMML schema file refer to objects from other SMML schema files. The format for a fully qualified name is the object’s type, followed by a colon (:
), followed by the fully qualified path of the object, and the name, separated by the period (.
) character. In the SMML editor, the FQN displays as objecttype:fullyqualifiedpath.name
. For example, physicalcolumn:Sample App Data.SAMPLE. D02 Time Month Grain.Per_Name_Qtr
.
Note:
As the period (.
) character is used as a separator, if an object's name contains a period (.
) character then it is escaped by a backslash (\
) character.
Object Naming Criteria for SMML Schema Files and Folders
You can name SMML schema files and folders by following the object-specific naming criteria for maximum length, spaces, unsupported characters, and unique naming rules.
Object Type | Unique Naming Rules | Maximum Length (characters) | Leading / Trailing Blank Spaces Allowed | Unsupported Characters |
---|---|---|---|---|
Business Model |
None |
128 |
No |
Asterisk ( Question mark ( Single quote ( |
Catalog Schema |
None |
128 |
Yes |
Asterisk ( Question mark ( |
Connection Pool |
None |
128 |
Yes |
Asterisk ( Question mark ( |
Database |
None |
128 |
Yes |
Asterisk ( Question mark ( |
Initialization Blocks |
None |
128 |
Yes |
Asterisk ( Question mark ( |
Logical Table |
None |
128 |
No |
Asterisk ( Question mark ( Single quote ( |
Logical Column Logical Level Logical Table Source |
None |
128 |
No |
Asterisk ( Question mark ( Single quote ( |
Physical Table Physical Table Alias |
Use unique physical table and unique physical table alias names. You can't use the same names when the object shares a parent. |
128 |
Yes |
Asterisk ( Question mark ( |
Presentation Table |
Use unique presentation table names. You can't share the same name as the parent subject area. |
128 |
No |
Asterisk ( Question mark ( Single quote ( |
Presentation Column Presentation Hierarchy Presentation Level |
None |
128 |
No |
Asterisk ( Question mark ( Single quote ( |
Subject Area |
Use unique subject area names. You can't use the same name for any child tables. |
128 |
No |
Asterisk ( Question mark ( Single quote ( |
Variable |
Use unique variable names. You can't use the same name as any other variable associated with any initialization block in the semantic model. |
128 |
Yes |
Asterisk ( Question mark ( |
Replacing Unsupported Characters in File and Folder Names
Certain characters in the names of your SMML schema files and folders are replaced automatically if they are unsupported for the object type of your file. The characters replaced differ based on which operating system you use.
Characters Replaced on Windows Systems
Characters in SMML schema file and folder names replaced on Windows systems if they are unsupported for an object type are the following:
Character | Replaced By Character If Unsupported |
---|---|
Double quotation mark ( |
Underscore ( |
Asterisk ( |
Underscore ( |
Slash ( |
Underscore ( |
Colon ( |
Underscore ( |
Less-than symbol ( |
Underscore ( |
Greater-than symbol ( |
Underscore ( |
Question mark ( |
Underscore ( |
Backslash ( |
Underscore ( |
Vertical bar ( |
Underscore ( |
Characters Replaced on Unix Systems
Characters in SMML schema file and folder names replaced on Unix systems if they are unsupported for an object type are the following:
Character | Replaced By Character If Unsupported |
---|---|
Slash ( |
Underscore ( |