Hi Olap Gurus,

I am using VIEW as fact table because my sales data use some different
foreign currency while the analysis must be done in local currency. All data
is updated nightly. Below attached my simplified fact table and view.

The question is :
1) When I design automatic cube process, is it enough to use 'Refresh Data'
to make sure that the sales amount always use latest
rate ?
2) If I have 1,000,000 rows of fact table / View, and the currency rate of 1
row changes, does it mean that all data will be
crecalculated during Cube process ? If yes, is there anyway to avoid
this ?

Thanks for your help,
Krist

Create Table OrderDetail (
OrderId Int Identity(1,1) Not Null Primary key,
OrderDate DateTime Not Null,
Amount Decimal(15,2),
YYYYMM Int,
Currency Char(3)
)

Create Table Currency (
YYYYMM Int Not Null,
Currency Char(3) Not Null,
Rate Decimal(8,2),
CONSTRAINT "PK_Currrency" PRIMARY KEY ("Currency")
)

CREATE VIEW OrderFact AS
SELECT O.OrderID, O.OrderDate, O.Amount*C.Rate AS Amount
FROM OrderDetail O
INNER JOIN Currency C ON C.YYYYMM = O.YYYYMM AND C.Currency = O.Currency

Hi,
Thanks for your reply.
But I use Standard Edition while Partitioning and Linked cubed only
supported in Enterprise Edition.
Or am I missing something here ?

Thank you,
Krist

"Carlos Colombo" <anonymous (AT) discussions (DOT) microsoft.com> wrote

to partition your cube : one partition for data in the analysis currency and
another partition for the rest.