Skip to Content
0
Former Member
Apr 26, 2010 at 09:50 AM

How to use Topcount in an OLAP universe

12 Views

Hi,

I want to create an object who gives me the best 10 Values back.

I try to use topcount with the following code:

<EXPRESSION>
TOPCOUNT([Measures].[OINV INVOICE NET VALUE], 10,)
</EXPRESSION>

But i get no data back.

The help in the universe designer says the following:

TOPCOUNT("Set", "Count"[, "Numeric Expression"] ) 
returns a specified number of items from the topmost members of a set

Which function has the "Numeric Expression", and what are possible expressions?

Thanks for helping.

Kind Regards

Jens