• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

New to SSAS

i am very new to SSAS
i have a table structure as shown in the attachment.
How to figure it out which is fact table and dimension table in the structure
what is the criteria to find it out?
Please help
Doc1.docx
0
sqlcurious
Asked:
sqlcurious
1 Solution
 
nigelrivettCommented:
What are you trying to do? It doesn't look like ssas would be very useful for that data. Is there anything you want to aggregate or slice?

 fact table is usually measures (mostly additive) and links to dimensions - think of them as attributes of a fact. I can't see that this data would fit very well into that.

What sort of questions would the users want to ask?

Status looks like it could indicate an event (factless fact). There is an itemqty. Maybe a fact is a prouct or part of it being made?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now