Solved

Evaluating cube SQL that creates Measure

Posted on 2009-07-13
2
362 Views
Last Modified: 2013-11-26
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
0
Comment
Question by:PeterFrb
2 Comments
 
LVL 14

Expert Comment

by:rob_farley
ID: 24867341
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
0
 

Accepted Solution

by:
PeterFrb earned 0 total points
ID: 24882221
I did not succeed in using Profiler to unravel this, but I did finally get this piece to work.  The problem, it turns out, was in the Attribute Relationships.  I've been viewing the most excellent video series on Analysis Services (http://www.learnmicrosoftbi.com/Videos/tabid/75/Default.aspx), for which one must register to see all the material, but it's free to join, and I skipped ahead to section 109, which demonstrates Attribute Relationships.  Once I had this correctly, the numbers were suddenly correct!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now