Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transformer 7.3 Measure value decreases when adding more dimensions

Status
Not open for further replies.

jim2195

MIS
Jan 9, 2012
2
US
Hi,

I am havnig a really weird issue. I have stripped a cube down to it's bare minimum, a single iqd. If I build the cube with a date dimension and a single measure, my measure reconciles perfectly against the database. If I add another column as a dimension from the same iqd, the measure value decreases!

Any ideas anyone?

Thanks in advance
jim
 
Does the added column (as dimension) store null values?

Ties Blom

 
Good point. I have now coded around that and it is still reducing the measure value. It can be various fields added as dimensions not just one particular field
 
Did you analyze where you are missing data? In other words, did you take the output of the 2 dimensions with the measure and rolled that up to the dates comparing it with the analysis of measure+date. Can you detect a pattern where data is missing/lower than expected?

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top