Database Design Problem

Tips and tricks
1

It might be too late in the day, but i can’t figure this out. I have a database for pricing. It is a pretty simple database at this moment and i can’t get the dimension to work correctly for me.
My prices are all totaling by customer 0
image

image
image.png734×203 15.2 KB

I have customer_id mapped to the dimension called customer
I have price mapped as the measure

image

On the customer dimension, i have the customer table mapped to get the name.

I can NOT figure out why all the prices are showing up under customer 0

Any advice?

2

Hi,
I would suggest that you clear the stream, save it in Designer and start again in case it might be something hanging.

Price might be best mapped to properties in transactons, rather than as a measure.