Attribute ID consistency in datasets

In order to get around the limits in Explore we need to export data for analysis in other BI tools. This is hard to do when IDs are not present in all dataset types.

Example: In Knowledge Capture dataset Author ID is not present, only author name so we can't easily relate an "Employee dimension" to an author.