| I have 2 fact tables :- Searches and Bookings, now I want to build a cube where I can see Searches Vs. Booking date wise (and by some other dimensions also like country etc.) for such cases how should I proceed :-
1. Create a cube with both Fact tables. Actually I did that but then I am getting this warning "the fact Searches and fact Bookings measure groups have the same dimensionality and granularity. Consider unifying then to improve performance", is this fine?
2. Is there any other better way to do this?
|
|