Distinct count issue

Hello,
I have made a cube the following calculated member (with as parent member Measures):
COUNT(NONEMPTY( {[Parsed Logs Visitors].[Parsed Logs Visitors Dimension Table].[Parsed Logs Visitors Dimension Table]} *
{[Measures].[Parsed Logs Count]}))

Here I try to make a unique visitor count using the primary key in a non empty crossjoin with the fact table. When I query it with other dimension attributes it works fine, but it gives the total amount of unique visitors when I use (other) attributes of the same dimension.
How can I avoid that?

Thanks in advance,

Eyso Zanstra

You could try applying "existing" to the primary key attribute set:

COUNT(NONEMPTY( {Existing [Parsed Logs Visitors].[Parsed Logs Visitors Dimension Table].[Parsed Logs Visitors Dimension Table]} *
{[Measures].[Parsed Logs Count]}))

|||Yes, that did the trick.
Thank you!

Displaying print statements of Stored Procedures in SSIS Logs

Hi

I have few print statements in a stored procedure that gets called from the SSIS package. How do I make sure that these are captured in the SSIS log meaning how do I get them to be displayed in the Package Explorer window when running from the Business Intelligence Studio IDE.

Not possible. Print statements are diagnostic in nature and are not part of the returned data set, which is what gets exposed to SSIS.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1229612&SiteID=1