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

Is the relatoinship between the document number and quotation is one to one?

If then, it's possible to aggregate the document number with aggregation
function of "distinct count". You can set the property of measure in Cube
Editor.

Ohjoo Kwon


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

Thank you,
But I still have a problem. At the Aggregate Function the option 'count
distinct only appears when the source field is an Numeric field type. The
documentnumber I would like to count (distinct count) is a Text-field (e.g.
VF05001234).
Do you have any ideas to solve this problem?
Or is the problem not the field type, but something else I don't know?

Hans

"Ohjoo Kwon" wrote:

Yes, you are right. It must be numeric.

I recommend you use surrogate key mapped to document number.

Ohjoo Kwon

"hans.de.korte (AT) verder (DOT) nl"
<hans.de.korte (AT) verder (DOT) nl (AT) discussions (DOT) microsoft.com> wrote

Thank you!!

"Ohjoo Kwon" wrote: