Forum Discussion
Multiple Fact Tables Issue when you are attempting to use more than 1 non-conformed dimension
Good Morning Greg_Deckler ,
Your solution got me almost there!! I'm no longer getting the error when I use my real data, but now its doing a cartisian on all the values in the Non conformed dimension. Basically repeating the value over ALL the records in the Dim table versus just the Dim values in use. I was expecting it to put the results back together by joining on the common columns like our other tool does.
I recreated NonConformedDim2 and put in values that are not being used in the Fact2 table to show the problem.
The only dim value being referenced is Medium, but for the report you can see that its creating a line for all the records in the Non Conformed Dim 2. The desired results would be to only have the lines where Property5=Medium and not do that cartisian. I can do some tricks where I filter out where Value2 is blank, but that can get very complicated with our real data set.
Please look at my reply from 12 Oct and the screen shots. You need to use USERELATIONSHIP and spell out the joins so the model knows which patht to take.
Hey Data-estDog ,
First, it was very rude of me not to thank you for your suggestion. Thanks for taking the time to help me! I tried the Use Relationship on the new metric, but it did not seem to make a difference. I still got the cartisian between the metric on the Fact Table and the non conformed dim that had a relationship with another Fact Table. I tried every relationship in the model and it did not make a difference. Maybe I'm using it wrong? Let me take another stab at it.