Link to home
Start Free TrialLog in
Avatar of PeterFrb
PeterFrbFlag for United States of America

asked on

Evaluating cube SQL that creates Measure

I am using Visual Studio 2008 Analysis Services and processing the AdventureWorks database to create and process a cube.  One of my measures is the Sales Amount field from the FactInternetSales table.  When I click and drag that field onto an otherwise blank crosstab, my value is less than 29358677.2206503, which I know it should be.  The study video I'm following shows that value, as do I when independently verifying the value by writing a view against the table.  

I suspect that when the measure is defined, something in the SQL statement puts a filter on the field, resulting in a value that is too small.  I do not know how to test this hypothesis.  Please help.

Thank you, ~Peter Ferber
Avatar of Rob Farley
Rob Farley
Flag of Australia image

Actually, you may find that one of your dimensions has a default value.

Use Profiler to see the query that's being, and then start pulling that apart.

Rob
ASKER CERTIFIED SOLUTION
Avatar of PeterFrb
PeterFrb
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial