ssas - how to be able to relate 2 dim tables in cube -


i think have designs issue (dimensional modelling). have:

dimensions: person, brand, market, order date time base (role playing), persondecile (outrigger)

facts: sales

all dims relate fact table. have calculation on persondecile distinct count of customers.

what need know\want:

i want able count of person persondecile , able split using brand , market desc. isnt doing when bring brand desc in browser, instead replicates count both brands.


Comments