Re: Info in MOLAP inconsistent with Relational table

#1

Since it is only 10 rows, can you give us some sample data?
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"salmeida" <salmeida (AT) refrige (DOT) pt> wrote

Quote:

Hello,

I'm working in a Windows 2003 Server, SQL Server 2000 and Analysis
Services 2000.

I have created two models in Analysis Services (MOLAP):
- MODEL 1 gets info directly from the relational FACT table: "FCT_SALES"
- MODEL 2 gets info from a view with: "SELECT * FROM FCT_SALES"

FCT_SALES has a measure (sum and double - the column in the relational
table is float).
This measure has 10 rows in the FCT_SALES.

Problem:
When we agregate the measure rows in Query Analyzer, MODEL 1 and MODEL 2
return 20. --> IT'S OK!
When I use Analysis Services (and ProClarity), MODEL 1 returns 20. --
IT'S OK!
When I use Analysis Services (and ProClarity), MODEL 2 returns
17. -->WRONG!!

WHY?

When I make Drill Through (Drill to Detail) in Analysis Services (or
ProClarity) to see the rows that compose the value, and export them to

Excel, I get the 20. --> IT'S OK!

Quote:

So, WHY does Analysis Services (and ProClarity) give me 17 ?!?

If the SUM(rows) give me 20, WHY does Analysis Services give me 17 ?!?

Thanks.

#2

Hi Dave

Yesterday nigth, I found the problem: something that shouldn't happen in the source info, happened! Murphy's Law

))

Analysis Services wasn't causing the info inconsistent

Thanks anyway.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Info in MOLAP inconsistent with Relational table

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Info in MOLAP inconsistent with Relational table - 05-19-2004 , 04:11 PM

Re: Info in MOLAP inconsistent with Relational table - 05-20-2004 , 03:06 AM