Edit the enrichment suggestions file to identify which objects should not be proposed as measures or as time or geographic attributes on the Measures and Dimensions panel.
|
Required property |
Description |
|---|---|
| objectName |
Pattern matching on the object name (column header). Any character can be used. When .*DAY.* is used, any object containing the string DAY is included in the rule (MONDAY, TUESDAY, and so on). |
|
dataType |
List of data types. Recognized data types are:
|
|
enrichment |
Prevents objects from appearing. The values are MEASURE or TIME (time hierarchy objects) or GEO (geographic hierarchy objects). |
|
rule |
Defaults to hide. Do not change this value. |
{
"version":"1.0",
"policies":{
},
"suggestionRules":[
{
"objectName":"(?i).*year.*|.*month.*|.*quarter.*
|.*week|.*day|.*semester.*|.*hour|.*minute|.*second",
"dataTypes":["integer", "biginteger", "double"],
"enrichment":"MEASURE",
"rule":"hide"
},
{
"objectName":"(?i).*zip.*",
"dataTypes":["integer", "biginteger", "double"],
"enrichment":"MEASURE",
"rule":"hide"
},
{
"objectName":"(?i).*_id\\d*",
"dataTypes":["integer", "biginteger", "double"],
"enrichment":"MEASURE",
"rule":"hide"
},
{
"objectName":"(?i).*key.*",
"dataTypes":["integer", "biginteger", "double"],
"enrichment":"MEASURE",
"rule":"hide"
},
{
"objectName":"(?i).*zip.*",
"dataTypes":["integer", "biginteger", "double"],
"enrichment":"TIME",
"rule":"hide"
},
{
"objectName":"(?i).*_id\\d*",
"dataTypes":["integer", "biginteger", "double"],
"enrichment":"TIME",
"rule":"hide"
},
{
"objectName":"(?i).*key.*",
"dataTypes":["integer", "biginteger", "double"],
"enrichment":"TIME",
"rule":"hide"
}
]
}