Hello !

I have a calculated measure "Ordercount":

count(
filter(
descendants([PCenter].currentmember,[Aufnr]),Measures.[Stueck] <> 0)
)

My probem is, that the measure is displayed for each level.

This was my result before:
Profitcenter - Pieces
AT - 200.000
DO - 300.000

This is my result now:
Profitcenter - Pieces - Ordercount
AT - 200.000 - 25
KT - emtpy - 0
DO - 300.000 - 12

Can I change the calculated measure so, that it is only displayed when
its <> 0 ?

Thanks
aaapaul

Moin,

Ja, klar, kannst du

1. Variante. Setze nonempty_behaviour für dein CM (ist die schnellste)

2. Variante. Shreibe dein CM so um.

iif(IsEmpty(Measures.[Stueck]), null,
count(filter(descendants([PCenter].currentmember,[Aufnr]),Measures.[Stueck]
<> 0)))


Vladimir


"aaapaul" <lvpaul (AT) gmx (DOT) net> schrieb im Newsbeitrag
news:1142330682.870532.160830 (AT) e56g2000cwe (DOT) googlegroups.com...

If you are trying to process multiple partitions or dimensions in parallel
using .net code which calls AS2K DSO, forget it. DSO is COM, and the code
will serialize in the COM calls even if you create multiple threads from your
own .net code. To do it, you need to create a seperate program (or use the
processpartition.exe utility to do the processing) and then create/launch
multiple processes from your .net code in the background. The .net code can
poll those processes and check when they have completed.

Steve Green




"Vladimir Chtepa" wrote:

Sry, replied to wrong thread.

"Steve G" wrote:

"1. Variante. Setze nonempty_behaviour für dein CM (ist die schnellste)"

Just one caution, for AS 2000, is that "Non Empty Behavior" works like a
performance hint - it doesn't guarantee that the CM will be empty, eg:

'Count(Filter(Descendants([Customers].CurrentMember,
[Customers].[Name]), [Measures].[Unit Sales] <> 0))',
NON_EMPTY_BEHAVIOR = '[Measures].[Unit Sales]'
select {[Measures].[Unit Sales], [Measures].[CustCount]} on 0,
Non Empty [Customers].[State Province].Members on 1
from Sales
But this type of query seems to work in AS 2005 - don't know if the CM
is guaranteed to be empty, though.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***