Cannot create a record in Reporting Services entity cache (SRSModelEntityCache). Entity identifier: 7542, An AX view entity. The record already exists. |
Stepping through my various views associated to the perspectives, I realised that I had done a very silly thing(TM). I would effectively be adding the same entity to the various cubes twice. In this case to the shared dimensions perspective.
Perspectives under the microscope |
Remember that the wizard for generating cubes adds certain views for us. The following selection would add the offending BIExchangeRateView. As you can see from the above image, perhaps I should remove other BI* views as well, although BISampleOrgHierarchyView may be okay.