I am trying to create a simple cube with couple of dimensions.
I made the lower level of the dimension unique and created a counting measures, and associated the measure with dimension, yet when building a cube I am receiving error message saying all the dimensions have no measure associated with them. (error TR2763). all measures are associated with dimension. any idea how to fix? I am calculating measures based on the lowest level of the dimension.
thanks you.
If I follow you correctly, you have not included any measures from the source fact table. I think you may need at least one column from the fact table, rather than calculated in Transformer.