Expose Custom Lookup and Value Sets in Subject Area

Amitabha

Description

Often there are needs to enrich reports and analytics utilizing custom lookups and value sets. As custom lookups and value sets are not available in any subject area for use standalone (with exception of value sets used for DFF definition), developers are forced to create data model based reports to meet business requirements, thus loosing lot of features offered through Analysis and Dashboard. If all Lookup and Value Set values are exposed through a simple subject area, then we can utilize a cross-subject area analysis to enrich user experience.

Use Case and Business Need

Use cases for custom lookups and value sets are unlimited, a simple scenario is to contain reference data against master setup or transactional data where no seeded configuration can store the reference data. For reporting purpose a simple join is required with the lookup or value set tables, however that is no longer possible in BI Analysis.

More details

Product does not meet the requirement as SQL based Analysis are no longer supported. Physical query can be utilized to query the view objects in limited scenarios where lookup/value set data can be pushed to WHERE condition, but the values can never be rendered in Analysis.

Original Idea Number: 6379957283