March 1, 2010 at 9:08 pm
I have design with fact and dimension tables. Any one guide how to create schema like tables in 2008?
March 3, 2010 at 4:22 am
I'm not sure what you're asking.
If you mean how to create a schema (aka diagram) in the Data Source View, follow these steps:
1. Right-click on an item in the Diagram Organizer
2. Choose New Diagram
3. A new diagram will be created and you'll have to provide a name.
4. Finally drag the tables you need from the table Tables pane into the work area.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 3, 2010 at 9:22 pm
I'm looking creating database using analysis service not diagram
March 4, 2010 at 12:15 am
In my native language, schema and diagram are synonyms.
You should've asked your question more clearly.
But on to the question:
click on Database in the menu and then choose Generate Relation Schema.
A wizard launches and you can start...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply