You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 7
Next »
There are several words and characters that should be avoided in Phocas, e.g., when naming measures etc. This is because in software development, these words or characters typically have a specific meaning that may affect results.
Reserved words in measures
| Word | Reason |
|---|
| Count | Count is a reserved word as when used as a scalar it depicts the count of rows in the transactions. |
| Trans | Trans is reserved for internal usage. |
Unsupported characters
| Character | Name | Reason |
|---|
| \ | Backslash | Backslash is a common programming character. |
| ; | Semicolon | The semi-colon is reserved as when used in searches it defines multiples. For example, in a equal to search, it splits codes. |
| * | Asterisk | The asterisk is reserved for wildcard searches, and shouldn't be used in raw data. |
Reserved words and characters in Designer
Unsupported characters (these should not be used in names of measures, streams, properties or dimensions)
Reserved words