Hey everyone,
I'm working with a view table and was wondering if there is a way to hide the name of the table from which a column is taken.
All help would be appreciated.
Hi Maxim,
Often the column description is suffixed with the table name, to make them unique. These table names are automatically hidden when displaying the table in Cube, if they meet these conditions:
- Parameter is a table column
- The suffix matches the regex \s*\(\s*[^\(\)]*?\s*\)\s*$
- All columns of the table that have a description, must have the same suffix.
If these conditions are not met, the suffix will still be trimmed if it exactly matches the table description.
In practice, this means you can accomplish what you want by making sure all columns have the same table name suffix between parentheses. This can be the exact table name, or an abbreviation.
You can find more detailed info in release note 18928.