Hello

I have te following problem:
I have made a cube with quotations. But a quotation consist of one or
more lines. On each line a product is selected (with price, amount,
etc.).

The records in my fact table are quotationlines (not quotation-headers),
because the producthierarchy is linked to the articles (in
quotationlines).

I would like to count the quotations (not the lines).
The lines linked to a certain quotation have the same document number.

How can I count the number of quotations, e.g. by using the function
calculated member or...? I have tried something but without a good
result.

Can you help me?

Thanks in advance

Hans

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

How about a distinct count measure on Document Number?

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agmeasures_0m0j.asp
If a measure's Aggregate Function property value is Distinct Count, the
measure value for a cube cell is calculated by adding the number of
unique values in the measure's source column from only the rows for the
combination of members that defines the cell and the descendants of
those members.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!