Ilijana,

This is the Yukon adminstration forum. Yukon is the upcoming version of SQL Server (i.e. it hasn't been released yet) so this forum isn't very busy. Hence,...

Ah, think I might have got it...

The 2nd argument to the filter function has to be a statement that evaluates to TRUE or FALSE (usually with use of the CurrentMember...

Hi Kris,

I am assuming you are using a "Text File (Destination)" connection object right? If this is the case you need to dynamically change the name of the file to...

What was the resolution?

I'm interested to know.

Michael,

My first idea would be to surround

[Call Date].[20031102]:[Call Date]:[20031104]

with curly brackets {} (what's the proper name for these things? Curly parentheses ). In other words

{[Call Date].[20031102]:[Call Date]:[20031104]}

Give that a go...

What has this got to do with Yukon?

There are a few options:

You could disable step 2 using ActiveX code (probably would be my choice).

SET <Task2>.DisableStep=1

Or you could drop the precedence constraint from the PrecedenceConstraints collection.

See Disconnected Edit...

Spot on!.

Word of warning though - DTS sometimes gets its "knickers in a knot" when using "?" to indicate the presence of a parameter. A really annoying symptom is that...

Hans,

This may be useful to you as well.

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/olapasandrs.asp

Regards

Jamie Thomson

There's a useful discussion of it here:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx

You're right, you need to know MDX. The Report Designer in VS.Net doesn't provide an interface for building MDX.

Some of the cube browser vendors (e.g. proClarity, Panorama) offer plug-ins to...

It will be picked up. However, if in your AS dimension you have:

Member Key Column = Acct_id

Member Name Column = Acct_name

then you will get an error when you try the...

See the reply that I have sent to you via email. It contains a script that will create a cut-down version of what I think your star schema will look...

st,

MOLAP will use more disk space than ROLAP but the storage gain with ROLAP is negligible compared to the performance gain with MOLAP - hence MOLAP is the way to...

st,

Always use MOLAP. HOLAP and ROLAP are available for political reasons rather than technical - Microsoft just wanted to put a "tick in the box" for ROLAP and HOLAP to say...