Getting Cell Values

OLE DB Programmer's Reference

The query for getting the cell values is as follows:

SELECT Value, NewRank AS Rank FROM    (SELECT Value    FROM       (Fact AS F JOIN Cprime AS C ON          (   C.[Product.[All]] = F.[Product.[All]]          AND C.ProdLine = F.ProdLine          AND C.Product = F.Product          AND C.[Geography.[All]] = F.[Geography.[All]]          AND C.Country = F.Country          AND C.State = F.State          AND C.City = F.City          AND F.Zipcode = ALL()          )       JOIN Rprime AS R ON          (   R.[Time.[All]] = F.[Time.[All]]          AND R.Year)  = F.Year          AND R.Quarter = F.Quarter          AND R.Month = F.Month          AND F.Day = ALL()          )       )    WHERE F.Measures = "Sales")    RANK ROWS AS newrank RANKORDER BY Rank1, Rank2 ORDER BY Rank

1998-2001 Microsoft Corporation. All rights reserved.