I have created a framework manger model that works, and can be used with query studio successfully, so I tried to create a transformer version on top of it to try and learn how to do such things.
However it doesn't seem to work.
Briefly I have store region, store name, then I have dates, and times, and finally, sales value, number of transactions and number entering store.
In query studio I can see all the stores, all the regions, etc.
In the created cube I have only one region? and one store???
I am guessing I have made a small? mistake, could anyone offer guidance on where to start looking for a solution.
well I have done something, not sure what though! and it seems to work!!
If there are no facts corresponding to a member from a dimension, Transformer will (by default) drop that member. Perhaps you only had facts from one store/region? Hard to say from here.