Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vanessa
Starting Member
4 Posts |
 Posted - 2002-05-13 : 11:48:06
|
| Hello. I have only just started playing with Analysis Services and I have a View in my database that I would like to use as a dimmension (or perhaps a fact table later) but when I view the list of tables to select from for the dimmension, no Views are showing up - only tables. Is there anyway I can get my View to show up and be selectable?The reason I am using a view is because I have a set of mutually exclusive relationships. I have an object which can have several types of owners - where each type is its own table. So if I want to model this owner hierarchy I have to say OwnerType = X and OwnerID = Y but I can't seem to make any such joins in the editor so I have a view that merges all of the type tables into one view.If you could help me from either angle - using views or using mutually exclusive relationships, I would appreciate it. Thanx-Vanessa |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-05-13 : 13:46:26
|
| We use views as our fact tables and for some dimensions with no problems. As long as they all exist in the same database I see no reason why this is not working. One thing I have noticed is that AS manager tends to cache a lot of information and sometimes closing it completely and reopening it will cause it to refresh properly.I will have a look at work tomorrow to see if there's anything fancy involved but from what I recall the views show up with the tablesAre all the objects in your datbase owned by dbo ?HTHJasper Smith |
 |
|
|
Vanessa
Starting Member
4 Posts |
Posted - 2002-05-13 : 14:19:00
|
| Hi Jasper. Thanx. I had tried right-clicking on the database and selecting "Refresh" and there was no change but I had not actually closed AS and then restarted it. Now that I have the view shows up fine. I am glad it was a simple solution! And I'll keep in mind that AS doesn't refresh properly.Thank you very much! |
|
|
|
SMerrill
Posting Yak Master
206 Posts |
Posted - 2002-05-21 : 17:15:03
|
My database had to summarize a log file containing thousands of commands. But there were only 9 different kinds of commands, and each command deserved it's own table because the parameters of each command were different.So, I made a star schema with the hub being the AllCommands table (CommandID, CommandType) with CommandID as an Identity field. Each of my 9 ancillary tables begin with CommandID and contain the unique parameters for the command they represent. Naturally, there is a one-to-one relationship between these 9 ancillary tables and the AllCommands table. This means that they take their foreign key from the AllCommands table.This makes them all mutually exclusive, if you see my point.And yes, I have a view which unions all nine tables together into one view. but I don't use it as a dimension. Instead, table AllCommands has one more denormalized string called CommandString that describes each command and the parameters for that command. This way, I can use AllCommands as the dimension.  --SMerrillSeattle, WA |
|
|
|
|
|
|
|
|
Selecting a View as a Dimmension?