I have an issue where a measure keeps doubling up in OLAP.

The view/table used shows 2 items for one particular invoice. One has a
weight of 1.04 tonnes, the other 0.

However, when this invoice is selected in the cube it shows a tonnage of
2.08 instead of what it is set to show (sum of tonnage).

Any ideas to why it is doing this is appreciated.

Regards
Dazza

If this is a result of incorrect join conditions in the cube schema,
drill-through may help you identify it:

http://groups.google.com/group/micro...olap/msg/2d6ae
220b5576feb
Newsgroups: microsoft.public.sqlserver.olap

Subject: Re: Cube showing slightly different data than in data
source...?

I think the best way to troubleshoot it is to do DrillThorugh on the
cell
which shows wrong numbers - and track down the records in the fact table
that contributed to it.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***