MS SQL Server OLAP - Problem with calc Member with Inflexion point in Formula

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Problem with calc Member with Inflexion point in Formula

Karthik Rao

2005-12-29, 1:23 pm

Hi:
I have dimensions (Owner, Product, Time) and facts (Transaction,
PriceHistory).

The transaction has a BuyQty and a SellQty, only one of which is
non-Zero in a Transaction (i.e. either a buy or a sell).

Calc Member (AquisitionCost)=
iif
(SellQty=0,
AquisitionCost.PrevMember + TranValue.CurrentMember,
UnitPrice.PrevMember * Balance.CurrentMember
)

This works fine when I have AquisitionCost in Columns, ProductCode and
Date in Rows, for all but the last row, which is the aggregate for
ProductSubCategory
where the value is zero. I would instead like it to be the last
AquisitionCost value for that Product.

How do I set this right?
Thanks a lot

Karthik Rao

2005-12-31, 7:23 am

Gurus, please help!

Sponsored Links