Working with Confirmed and Non Confirmed Dimensions
926043Mar 26 2012 — edited Mar 27 2012The actual need for my situation is I have two facts F1 and F2 and Four Dimensions D1, D2, D3, D4
D1 is a confirmed Dimension
D2, D3 are joined to F1 and D4 to F2 according to the star schema . I need a report which has D1, D2, D3, D4 , F1. Is this possible ?
Method applied : I added a new logical table source to F1 and pointed it to F2. I pulled in all the required dimensions and created a new logical folder with F1, D1,D2,D3,d4 . I created a logical join from D4 to F1 in BMM layer . The rest of dimensions are already connected to F1.
Now when i run the report the i get null values when i pull in D4 and F1 which is logically correct but when i try to run the report D1,D2,D3,D4,F1 it returns an error ? Should i need to include even F2 in my report ?