Solved

Evaluating cube SQL that creates Measure

Posted on 2009-07-13
2
364 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 15

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# Offline Apllication 5 56
How to add <appSettings> to the webconfig file 2 22
.NET tools for adding thread safety to a web app? 3 19
SQL Server Question 5 29
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 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

19 Experts available now in Live!

Get 1:1 Help Now