Hi All

I am having a problem with the MDX Sample App and AS Data browser returning
different values for a specific set of leaf-level members.

I have 8 dimensions in my cube. I have selected leaf-level members for each
dimension.

In my MDX query through MDX sample app, I simply ask for a leaf level member
on on rows, a different leaf level member on columns, and then my other 6
dimensions as filters. E.g.:

SELECT
{[Period].&[1]} ON COLUMNS,
{[Schedule].&[1520] ON ROWS
FROM [Mercury_Fin_Plan]
WHERE ([Business Segment].&[1800], [Initiative].&[1001],
[Measures].[Amount], [Org Structure].&[5070], [Strategic Objective].&[180],
[Version].&[0])

This selection of members returns the value 79,044,481.

Now, when I look at the data browser for these members (obviously I have
checked that the unique names are correct, etc.) I get a slightly different
value - 79,981,964.

What I've narrowed it down to is that the schedule line (1520) - Interest
Expense - has a formula to generate it's value. If you look in the FACT
table, there is no value for this combination of members. Because it's a
formula it is obviously calculated on the fly?

So, my theory is that the Sample App is using a different connection library
than the AS Browser - and that one of these has a bug?

This is SQL Server 2000 sp3a AS. I have installed ADOMD.NET 9.0 (from SSAS
2005) for a different application. Could there be a problem with that?

Or is it some discrepancy in my query or something?

I have no idea! Any help would be appreciated.

Can you reproduce this using Foodmart 2000?

Ohjoo

"Brendan Hayes" <Brendan Hayes (AT) discussions (DOT) microsoft.com> wrote