Symptom
The consumption model of Business Builder in Datasphere shows the following error on a dimension source:
The linked association from ''***" isn’t supported.
After consuming this model in another application, for example Analysis for Microsoft Office (AO), the following error occurs:
Caught exception : exception 75000006: Source format error; \$[1]\$=invalidated database object:; \$[2]\$=view "***"."***" CS (42014)
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
- SAP Datasphere
- SAP Analysis for Microsoft Office
Reproducing the Issue
- In Datasphere Business Builder, open the affected consumption model.
- Check the dimension sources and observe the error: The linked association from ''***" isn’t supported.
- Navigate to the dimension sources and there are no errors.
- In Analysis for Office, add the Datasphere connection and insert the same consumption model as a data source.
- Observe the error: Caught exception: exception 75000006: Source format error; invalidated database object; \$[2]\$=view "***"."***" CS (42014).
Cause
Status inconsistency.
Resolution
- In Business Builder, locate to the dimension source that shows: "The linked association … isn’t supported."
- Click on the dimension source, then automatically navigate to the following canvas:
- Unlink the affected dimension source:
- Link again:
- Save the consumption model.
- Deploy the corresponding perspective:
See Also
Keywords
analysis for Excel, bw bridge, remote bw bridge, analysis office error, view invalidated, business builder, entity , KBA , DS-BB , Business Builder , BI-RA-AO-XLA , Excel Addin , Problem
Product
Attachments
| Unlink.png |
| Canvas.png |
SAP Knowledge Base Article - Public