using newbie.advance.apologies;

I have a measure using precalculated values from a fact table column. I
don't want these values to be aggregated, just returned by the query.

For the measure I tried selecting AggregateFunction=None but I want the
values returned when the query is not confined to leaf.

The next thing I attempted is FirstNonEmpty which should be ok since the
fact column has low cardinality. However the measure group gets a red
squiggle under it and when I hover, I see the message "semi-additive measure
requires a time dimension".

How do I associate the time dimension with this measure? The fact table
already has a time dim key, and the association is represented in both the
cube.dsv and the dimension usage tab.

What more do I have to do? None of the measure properties look relevant.
Ashamed to say it but I even tried dragging and dropping the dim on to the
measure!

Ta in advance,
David

Figured it out, forgot to set time dim type to regular instead of time.

However when I pulled up the measure by time in the browser, the values were
multiplied by exactly 214 which is the count of all rows having the same
value.

I gave up with this approach and created a calculated member instead.


"David Norman" wrote: