The Expose button is disabled for the joined data sources in the system.
Reproducing the Issue
1. Goto Business Analytics Work Center
2. Design Datasources
3. Select any Joined data source (Eg: Campaign and Campaign Responses)
The Expose button on the top is disabled or greyed out.
This is sysem designed behavior.
Join data sources can no longer be exposed for the ODP scenario of integration with BW systems. It was already not allowed to expose Cloud data source.
This has been done as fetching data from a Join data sources into a BW system has a big performance impact on the Cloud for Customer system. In many cases, the extraction fails as there is not enough memory to extract the entire dataset.
The underlying data sources which are used as Join Members can be used in such cases and you can extract data from them.
Please note that, for now, we will continue to support data extraction for those Join data sources which had already been exposed before 1608. Only new ones cannot be exposed anymore.
However, this will be supported till you don’t change the expose button settings. Once you try to change the expose button setting, the check will take place even for the old data sources which are already exposed.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement