Got a mind twister for you. I have this cube that has a pretty low level grain in it. But the Targets I want to set in the cube do not go down to that grain level. Basically, they are up high at a geography level. Does anyone out there have any suggestions or recommendations for building targets into the cube or joining them from another cube? I’m looking for some SSAS05 suggestions.
I’ll outline the responses and repost.