we don’t have any star schema like structures. All are views in our database and the views have both facts and dimensions.
There are multiple column joins among the views and most of them are 1:1.
Universe Desiner doesn’t detect any contexts or Loops. Do I have any traps?
1.doc (26.0 KB)
BOBJGuy 
(BOB member since 2010-02-25)
Not many people will read a Word document.
You’re better off with images.
I am not able to upload any images. That is why I copied the image into a word document. Are you not able to see the picture?
BOBJGuy 
(BOB member since 2010-02-25)
You don’t have loops, but you might have traps. It’s not possible to tell without knowing the data.
joepeters 
(BOB member since 2002-08-29)
All the views are connected 1:1. How can I get traps if there are no 1:Many or Many:Many Relationships?
BOBJGuy (BOB member since 2010-02-25)
I think you just answered your own question, no?
joepeters 
(BOB member since 2002-08-29)
You should be able to load images. Take a simple screen shot and save it in MS Paint, save it as a JPG, and upload.
Dave Rathbun (BOB member since 2002-06-06)
I don’t trust Word documents from the internet unless they are from Microsoft or one of my direct associates. It’s a policy that has worked well so far; similarly others, particularly in more secure environments, won’t be allowed to download it so won’t be able to see it either.