If you are adding more than 5 data sources as Join members while creating a Join Data source using key user tool it gives a warning message You can only add up to 5 involved data sources to a joined data source.
Reproducing the Issue
- Goto Business Analytics Work Center
- Design Data Sources
- Click on 'New' > Join Data source
- Click on 'Add Data source' and select data source from Value Help
- Click on 'OK'
- Repeat step 4 and 5
After adding five data sources while trying to add sixth data source it gives a warning message You can only add up to 5 involved data sources to a joined data source.
You can use only 5 data sources as join members while creating a join data source.
Currently this is system designed behavior.
If you still have data source to add you may try creating a new join data source, use this data source created as a join member and add upto 4 other different data source whichever required.
KBA , LOD-CRM , Cloud for Customer , How To