I am trying to create a dimension that shows company ownership of an asset. (the asset is a manufacturing plant)
Current Analysis Project Issue
I am trying to show financial data by company. I have been able to use the assets, years (not discussed here), Region->Country, etc to generate other dimensions. but now that i have a many-to-many relationship in the data base and in the data view,
I am getting "Errors in the high-level relational engine. The table_name
table that is required for a join cannot be reached based on the relationships in the data source view." The tables are properly joined in SQL and I can query them and return the expected results.
Assets change ownership.
Assets can be hierarchical. (not for this dimension)
Companies can be hierarchical. (required for this dimension)
Need to show chain of ownership.
Here is my current structure:
Assets.AssetID (PK) to AssetsCompanies.AsssetID
Companies.CompanyID (PK) to Asset
View Complete Post