If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Figures in cube is not same in FM query/Transformer query

Started by andysin, 31 May 2015 09:53:55 AM

Previous topic - Next topic

andysin

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.

bdbits

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.