Meaning of datacode in sysdtslog90?

The documentation says:

"An integer value that identifies the event associated with the log entry. The value 0 indicates the event provided no identifier."

When I look at the sysdtslog90 table and I filter for 'PackageEnd' events, I see a value of 0, 1 or 3 in the datacode column. Is there any information I can glean from these values, e.g. package success or failure?

Did you ever get an answer to this question? I'm interested.

Thanks!

Meaning of datacode in sysdtslog90?

The documentation says:

"An integer value that identifies the event associated with the log entry. The value 0 indicates the event provided no identifier."

When I look at the sysdtslog90 table and I filter for 'PackageEnd' events, I see a value of 0, 1 or 3 in the datacode column. Is there any information I can glean from these values, e.g. package success or failure?

Did you ever get an answer to this question? I'm interested.

Thanks!

MDX Problem

Hi,

I am a fresher for Analysis service.

can i include measures in selection creteria (Where condition).

i am going to show some set of rows. [event count] is comes under measures.

already i have taken [event count] is one column in my query. can i include [event count] in selection creteria.

email id name event count

--

xxx xxxx 12

yyy yyyy 45

zzz zzzz 20

this is resulted value. can i filter, event count is greater then 40

Thanks in advance.

Regards,

Nanda kumar R

You could use Filter() or the "having" clause, as in this Adventure Works query (customers with > 3 orders):

>>

select

{[Measures].[Internet Order Quantity],

[Measures].[Internet Sales Amount]} on 0,

Non Empty [Customer].[Customer].[Customer].Members

* [Customer].[Email Address].[Email Address].Members

having [Measures].[Internet Order Quantity] > 3 on 1

from

[Adventure Works]

where

[Customer].[Customer Geography].[City].&[Calgary]&[AB]

Internet Order Quantity Internet Sales Amount
Alisha G. She alisha24@.adventure-works.com 5 $4,343.59
Carly Yuan carly6@.adventure-works.com 5 $194.96
Damien A. Deng damien18@.adventure-works.com 4 $578.46
Kristi S. Malhotra kristi21@.adventure-works.com 7 $4,850.33

>>