Currently, Oracle Fusion Data Intelligence (FDI) supports data security assignments primarily at the PKEY level. We would like to have the feature to allow FDI to apply filters on the non Key columns or attribute of the table
Ex: I have a fact table that joins with Customer dimension. The Customer Dimension has an attribute 'Class'. The 'Class' is a category which has 10 distinct value. There are 100+ Customer in each class. We have requirement to apply Data Security by the class column. The customers will be switched to other class based on business decision
The LA feature will require to model the security table by Customer Key. But we want to provision the security at Attribute level.