1. SMML Schema Reference for Oracle Analytics Cloud
  2. About the Semantic Modeler Markup Language and Schema Properties
  3. SMML Naming Conventions

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 (_)