FCCS: how to add The Non-Indexed Attribute to a dense dimension
Summary:
Content (required):
It is stated under the below documentation the following statement:
Specifying Indexed Attributes
When you create Custom Attributes for a dimension, you can specify that it is an Indexed attribute.
An indexed attribute dimension is the same as a traditional attribute dimension. It is sent to the database as an attribute dimension during cube refresh. It is not valid for dense dimensions, and requires all assignments for a given dimension to be at the same level.
A non-indexed attribute dimension is primarily a metadata construct used for filtering, although it can be materialized in the database during cube refresh in various ways, typically as a prefixed user-defined attribute. Since it does not materialize as an attribute dimension in the database, it can be assigned to multiple levels, and