Forum Discussion
Connectivity to SSAS
When I connect to SSAS, I am able to import Dimensions and Measure Groups, but not the relationships. How does that work? My reports are not showing data because of the missing relationship.
8 Replies
When I connect to SSAS, I am able to import the Dimensions and the Measure Groups, but not the relationships between them.
How does it work? I am not able to see any data in my report because of the missing relationships.
Can you go to the relationships tab in the Desktop and drag and drop to create the relationships? It is the third icon on the left (bottom icon)
You can Select the automatic detection of the relationship option.
Go to Manage Relationships and select Autodetect option.
Hope this would help to generate your report.
BhaveshPatel Hi Bhavesh,
For auto detection of relationships, i need to have the fact tables imported too. The relationship between dimensions and measure groups is always through fact tables (fact tables have the keys, measure groups dont). But in this case i am not able to import any data from the fact tables. When i try to import data from a cube, it gives me an option to omly import dimensions and/or measures.
Greg_DecklerHi Smoupre,
I can very well create the relationships in the relationships window, but i need the fact tables to be imported for the same. In this case i am not able to import any data from the fact tables. When i try to import data from a cube, it gives me an option to omly import dimensions and/or measures.
Hi dishathakuria,
If we connect to SSAS in import mode, imported datasets are based on the checked measures and dimensions. Those measures and dimensions will be treated as "field" in a dataset. Relationships built on SSAS side will not be imported. In your scenario, I would suggest you connect to SSAS in a live mode.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
