How to use Topcount in an OLAP universe

[Former Member]

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

[former_member186586]

i really wondering about that too...

[IngoH]

Hi Jens,

take a look at this document, which has several examples:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c82062...

Ingo

[Former Member]

Hi Ingo,

i already use this document, but there is no example with topcount, and the examples with ranks does not work. I did not get any data back.

It is correct, if I Use topcount ins the select part? Or mus i use it in the where part and must also write an espression in the select part of the universe object?

Kind Regards

Jens

[Former Member]

HI Jens,

Are you figure out it? I want to create a object for sum qty too.

Thank you.

Regards,

Howard.

[Former Member]

Hi Howard,

not with topcount, but have look at my thread "Top N data in MDX uniserse?"

Kind Regards

Jens