Nevyn (6/17/2014)
I have no idea why you would want to set up your views that way. With no measures in the first view, there is really nothing you gain from having 2 views as opposed to having just one. When you link it to the view with the measures you will hit that granularity level anyway.So easy answer: make it one view.
Harder answer if you must have 2 views: Make the first view a dimension and make other dimensions referenced dimensions through that first view.
I didn't make this database and I don't necessarily want to be building a cube from this either. Please bare with me.
Also, Sorry but I am not sure what you mean by the harder answer if I cannot edit the database. Any chance you could offer assistance with those conditions in mind?
I really do appreciate all of the help, thanks.