Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
There are several Several words and characters that should be avoided in Phocas , e.g., when naming measures etc. This is because because, in software development, these words or characters typically have a specific meaning that may might affect results.
Reserved words in measures
Word
Reason
Count
Count is a reserved word
asbecause when it’s used as a scalar, it depicts the count of rows in the transactions.
Trans
Transis reserved for internal usage.
Reserved words in properties
Date is a technical term used across databases, so you cannot precede a property title with the word Date, as it will cause issues. For example, do not use Date ordered, Date created and so on.
Unsupported characters
Character
Name
Reason
\
Backslash
Backslash is a common programming character.
;
Semicolon
\ (backslash mark) and / (forward slashmark) are reserved characters because they are common programming characters.
; (semi-colon) is a reserved character because it defines multiples when used in searches
it defines multiples. For example, in
aan equal to search, it splits codes.
*
Asterisk
(asterisk) is a reserved character for wildcard searches,
andso it shouldn't be used in raw data.
Reserved characters and words
and charactersin Designer
Unsupported characters
The following characters
(theseshould not be used in the names of measures, streams, properties, or dimensions:
\ (backslash mark)
Character
\
@
!
?
~
|
*
Reserved words
Word
Reason
/ (forward slashmark)
@ (at sign)
! (exclamation mark)
? (question mark)
~ (tilde mark)
| (vertical bar)
Reserved words
Code
Date
Trial Balance
For streams only(for streams only)
Cash Flow
For(for streams only)
Reserved characters in Sync
Character
Name
.
Period or full stop/full point'
Use of "." (period character) . (period, full stop, or full point) is a reserved character because when it’s used in a file name can cause , it can cause an application (i.e. like such as Sync) to unexpectedly to unexpectantly recognize a the file with an unsupported file-type suffix. For For example, a file named "example_filename.txt" might be correctly recognized as a text file. But But a file named "example.filename.txt" could result in an unsupported file-type error ( if the application does not doesn’t support a file type of ".filename" (such as Sync)). .
_ (underscore) is a reserved character for source names but not for data items.