We have our DatabaseLayer with all our fact tables as well as our dimensions linked.
We then have our Business Layer with new query subjects and some filters here in there.
We also have our PresentationLayer wich is only sortcuts to the query subjects in the BusinessLayer.
Inside the Presentation Layer we have many name spaces each with shortcuts to query subjects like fact tables and dimensions that are in the BusinessLayer.
Ex:
PresentationLayerNameSpace#1
Fact#1 (Shortcut)
Dim#1 (Shortcut)
Dim#2 (Shortcut)
PresentationLayerNameSpace#2
Fact#2 (Shortcut)
Dim#1 (Shortcut)
Dim#2 (Shortcut)
Dim#3 (Shortcut)
PresentationLayer-NameSpace#3
Fact#3 (Shortcut)
Dim#1 (Shortcut)
Dim#4 (Shortcut)
Dim#5 (Shortcut)
Etc...
Questions:
- We want to include the shortcut to Fact#1 under the NameSpace#3 as well
- Will I still need to make joins in our BusinessLayer and or DatabaseLayer ?
- Is this a good practice ?
Quote from: matrixfree on 06 May 2016 08:57:21 AM
We have our DatabaseLayer with all our fact tables as well as our dimensions linked.
We then have our Business Layer with new query subjects and some filters here in there.
We also have our PresentationLayer wich is only sortcuts to the query subjects in the BusinessLayer.
Inside the Presentation Layer we have many name spaces each with shortcuts to query subjects like fact tables and dimensions that are in the BusinessLayer.
Ex:
PresentationLayerNameSpace#1
Fact#1 (Shortcut)
Dim#1 (Shortcut)
Dim#2 (Shortcut)
PresentationLayerNameSpace#2
Fact#2 (Shortcut)
Dim#1 (Shortcut)
Dim#2 (Shortcut)
Dim#3 (Shortcut)
PresentationLayer-NameSpace#3
Fact#3 (Shortcut)
Dim#1 (Shortcut)
Dim#4 (Shortcut)
Dim#5 (Shortcut)
Etc...
Questions:
- We want to include the shortcut to Fact#1 under the NameSpace#3 as well
- Will I still need to make joins in our BusinessLayer and or DatabaseLayer ?
- Is this a good practice ?
Assuming Fact 1 already has relationships to the appropriate dimensions in the Database Layer, you shouldn't need any more relationships anywhere. You should just be able to add a shortcut for Fact1 (pointing to Fact1 in the Business Layer) into Namespace3
Or am I missing something?
MF.
MF.
MF,
Yes if the fact table is already joined in our DatabaseLayer, therefore in our BusinessLayer it has inherited its joins.
I presume that:
Dim1, Dim4 and Dim5 should all be already linked to Fact#1 BEFORE trying to add a shortcut to it in our Presentation Layer under NameSpace3 ?
I just thought that it was bad practice to repeat a shortcut to a QuerySubject (Fact table in my case) that is already present in another NameSpace.
So I conclude that I can include any amount of shortcuts to a Fact Table in different NameSpaces ?
Thanks!
Quote from: matrixfree on 06 May 2016 10:14:03 AM
MF,
Yes if the fact table is already joined in our DatabaseLayer, therefore in our BusinessLayer it has inherited its joins.
I presume that:
Dim1, Dim4 and Dim5 should all be already linked to Fact#1 BEFORE trying to add a shortcut to it in our Presentation Layer under NameSpace3 ?
I just thought that it was bad practice to repeat a shortcut to a QuerySubject (Fact table in my case) that is already present in another NameSpace.
So I conclude that I can include any amount of shortcuts to a Fact Table in different NameSpaces ?
Thanks!
Yep - use them as needed :)
MF.
Good,
Then this is what I will have:
PresentationLayerNameSpace#1
Fact#1 (Shortcut)
Dim#1 (Shortcut)
Dim#2 (Shortcut)
PresentationLayerNameSpace#2
Fact#2 (Shortcut)
Dim#1 (Shortcut)
Dim#2 (Shortcut)
Dim#3 (Shortcut)
PresentationLayer-NameSpace#3
Fact#1 (Shortcut)
Fact#3 (Shortcut)
Dim#1 (Shortcut)
Dim#4 (Shortcut)
Dim#5 (Shortcut)
QUESTION:
WHAT IF THE JOINS BETWEEN FACT#1 AND DIM#4 AND DIM#5 AREN'T ALREADY DONE ?...
DO I NEED TO DO THEM IN OUR DATABASE LAYER OR IN OUR BUSINESS LAYER DIRECTLY ?
WILL THAT CAUSE ALREADY EXISTING JOINS TO BEHAVE DIFFERENTLY ?
Thanks !