Post reply

MDX query returns double values

  • July 14, 2005 at 4:42 am

    #363119

    I have a Sales Margin cube having Revenue,Cost,Margin as measures and customer,sales invoice,product group,time,area as dimensions.When i run the following MDX query, i get a value for revenue which is double the value i should get.I checked the fact table, value in the fact table for this measure is correct.Any ideas ??

    select {[Measures].[Revenue]} on columns,

    non empty [Sales Invoice].[Sales Invoice].members   on rows

    from [Sales Margin]

    Regards

  • July 14, 2005 at 5:36 pm

    #574622

    I've done something similar when using a flawed join strategy for building the cube.  Have you got processing logging turned on?  If not, turn it on and capture the SQL statement/s that are being used to load data into the cube, then execute these statements in query analyser to review the results.

    It's hard to see what else would cause this other than the fact table having double the figures (which you've already eliminated) or the method in which you're extracting and then loading the data for the cube doubling it up. 

    HTH,

    Steve.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply