Versions Compared

Old Version 13

changes.mady.by.user Denise McGettigan

Saved on

compared with

New Version Current

changes.mady.by.user Denise McGettigan

Saved on

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

as

because when it’s used as a scalar, it depicts the count of rows in the transactions.

Trans

Trans is 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

The semi-colon is reserved as

\ (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

a

an equal to search, it splits codes.

*

Asterisk

The

(asterisk) is a reserved character for wildcard searches,

and

so it shouldn't be used in raw data.

Reserved characters and words in Designer

Unsupported characters

These The following characters should not be used in the names of measures, streams, properties, or dimensions:

\ (backslash mark)

/ (forward slashmark)

@ (at sign)

! (exclamation mark)

? (question mark)

~ (tilde mark)

|* (vertical bar)

Reserved words

Code

Date

Trial Balance (for streams only)

Cash Flow (for streams only)

Reserved characters in Sync

Character

Name

Reason

.

Period or

 (period, full stop

/

, or full point

Use of "." (period character)

) 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 example, a file named

"

example_filename.txt

"

might be correctly recognized as a text file. But a file named

"

example.filename.txt

"

could result in an unsupported file-type error

,

if the application

(such as Sync) does not

doesn’t support a file type of

"

.filename

"

.

_

Underscore

Reserved

 (underscore) is a reserved character for source names but not for data items.