How to create basic relationship (tabular)

Question

Hello

I am new to ssas and I hope some of you could help me with the fundamentals.
I have imported 3 tables from my sql database and ssas have setup relationships based on the foreign keys. All employees are in at least one TRoleMember. When I use the analyze with excel, I imagine it would show which employees are under TRoleMember or am I misunderstanding how ssas works?

Answer 1

Hi,

From you description, you are trying to hierarchize the EmployeeID member in TRoleMember dimension.

You need to create hierarchy in the model, please follow steps as in :Create a hierarchy

In addition, SSAS is used for data analysis, normally there are dimensions and measures in the model. Seem in your design and tables, there is no measure data? IF this is your full data project, i.e. there is no need for data aggregation, slicing and dicing. You need to evaluate if SSAS is necessary for your project.

Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November