Hi Xavier,

First take a look at this http://msdn.microsoft.com/en-us/library/aa902652(SQL.80).aspx

This article contains an expression to calculate the max values over time

Measures.[Maximum Inventory Value]:

Max(Descendants(Time.CurrentMember, Time.Month), Measures.[Value])

The behavior...

No,

Connection managers are added in the connection managers pane.

When invoking a component or task that needs a connection, you can create a new connection or resuse a existing one.

You my...

Hi

I guess you need a fasttrack course MDX. Copy pasting does not do job. I used a 'standarized' way to express myself to make things clear to you.

I...

Just to point you into the right direction,

WITH

Member [Measures].[oneweek ago StockOnHand] AS

( ParallelPeriod ([Date].[Calendar].[DATE], 7, [Date].[Calendar].Currentmember)

, [Measures].[FactStockOnHand] )

Select

{[Measures].[FactStockOnHand] , [Measures].[oneweek ago...

Hi

Here it comes, a quick intro into the MDX language

/*

LETS DEFINE THE MEMBER simple count so default INCLUDEEMTPY. I do presume you need the count for every row.....

Hi Joost,

The way SSIS handles look ups, is basically store all in memory and try to equi-join on values stored in mem. This never enables you to create in between...

Hi

Simple answer: Set the InteractiveHeight = 0 (SSRS 2008: expand Interactive size, set Height = 0)

Accessible only through the properties pane. In BIDS use view properties window. To pop up...

Hi Mike

The merge component is not that good in handling rows with same key values, [highlight=#ffff11]so having NON UNIQUE KEYS[/highlight]. Your data contains NON UNIQUE KEY values, in the sorted...