Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Voya Financial
Description (Required): When creating an analysis using UNION operator, the option to check "Include Null Values" under: Criteria Analysis properties > Data tab, is disabled. Oracle has an internal enhancement request created for this -
ER: 19938145 - NEED OPTION TO ENABLE "INCLUDE NULL VALUES" IN ANALYSIS USING UNION OPERATOR
This ER should be expedited so we're able to build analysis that would allow all rows in a UNION query, irrespective of data availability for those rows.
Use Case and Business Need (Required): The requirement is to create an analysis with a bunch of reporting lines and each reporting line should be displayed whether there is a corresponding amount for that line in the fact or not. Each line has a different logic to calculate the amount and hence a UNION operator is used to combine all the lines. Currently, OAC displays only those lines which have data in the fact and the option to display NULL rows is disabled.
Enhancement Request / Service Request: SR 3-29612762671, ER: 19938145
