Hello I have a big dimension table which I merged into fact table. If it were not merged then I could create measures on the join key. Now since it is merged with fact table, how can I still create the measure within the same merged fact ?
e.g. if sales is fact table and there are 2 dimension tables customer and city. I merge customer to sales table as customer table has very large number of rows. After merging how can I execute query like 'city wise spending (sum) of the customer' . How will I define measures for this on merged fact?
