Member Avatar for toykwon5
toykwon5 0 Newbie Poster

Hello,

I am new to Microsoft SQL Analysis service and am trying to create cubes. But, I understand that I first need to create fact and dimension tables.

How do I create them? I kinda know the relationship between those two (Maybe not) but I just don’t know how to create them. I have a relational database that contains tables which I can use to build fact and dimension tables.

I have data warehouse server. I understand that dimension and fact tables should be created in the data warehouse server.

Any help would be grateful.

Thanks!

  • 1 Contributor
  • 0 Replies
  • 44 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.