I have a cube, in one of the combinations of dimensions, im getting value (no of transaction is 20) in cubeb. However, when running the query from transformer (query obtained from data source viewer) with same combination of dimension columns, I'm getting value (no of transaction is 10). Same goes to running the query from framework manager with the same combination of dimensions, I'm getting value 10 too.
What could possibly be the problem? Appreciate your advice.
The data source viewer only looks at one entire data source query at a time, so I am not following how you are combining dimensions within transformer.
The number of rows you get back from any combination of dimensions is going to depend on your data. One dimension level may be attached to many facts. Conversely, a combination may return fewer rows than the number of facts attached to each of the individual levels. Also note that if you have no facts related to a level within your dimension, that level may be omitted entirely.