Create Rule
Use this command to specify server rules. The following table lists the available server rule types:
| Rule Type | Description |
|---|---|
model |
Expression specifying a mathematical formula involving Longview symbols. When data is processed on the server, the system detects dependencies on these model rules, performs the required mathematical calculations, and creates output data. |
rollup |
Defines which areas of the database should be included or excluded from rollup logic. |
query |
Expression equating two Longview DataAreas. Query rules specify the placement of data virtually in a data intersection and are used to avoid storing redundant data in a system. When data is processed on the server, your application detects any query rules, retrieves data from the source intersection, and places it virtually into the target intersection as if it actually exists in the target intersection. |
event |
An event rule can be configured to run a process or email when data changes in the rule-specified section of the database. Note: If you make any changes to the list of persistent event rules in the rulepersists.txt file or the name of the procedure launched by the persistent event rules, you must restart the servers for your changes to take effect. For more information on persistent event rules, see the Longview Application Administrator Guide. |
validation |
A validation rule compares two cubes of data in the Longview database to make sure that certain cells within those cubes equal each other. For example, Total Accounts must equal Total Liabilities and Owner’s Equity, for all symbols in the ENTITIES, CURRENCY, and TIMEPER dimensions. |
You can work with server rules only if you are a user with administrator privileges.
Syntax (regular)
CREATE RULE [OVERWRITE] @FileName
where:
- OVERWRITE is an optional parameter enabling the system to overwrite an existing file specified by FileName.
-
FileName is an ASCII file containing the data. It can include a complete or partial folder path in the format C:\...\FileName. If FileName includes spaces, enclose it in double quotation marks; for example:
@"C:\My Documents\My Data.txt"
Note: If the document is in the same location as lv_af.exe, you do not need to specify the drive or path.
The ASCII file should be formatted as follows:
| ASCII content | Description |
|---|---|
3500 |
Rule ID |
MODEL |
Server rule type |
{ |
Delimiter |
KLX(REVCON###,YTDROOT###, |
Server rule |
{ |
Delimiter |
N/A |
Email message for an Event rule type. |
{ |
Delimiter |
APCO PROPORTIONING - REV & CONT |
Rule description |
{ |
|
Syntax example:
CREATE RULE @C:\Temp\Rule.asc
Note: Descriptions for new rules are automatically saved as English. If you want the rule to have an alternate language description, you must use the Set Rule command. For more information, see Set Rule.