First of all, you have a good grasp on written English so no need to apologise.

Michael is completely right with the cache comment. Are the queries running longer the first...

Ricky,

Its refreshing to see someone post a solution with the problem they were facing, now thats good knowledge sharing.

That seems the best way to me. Did you intentionally miss out the "Dimension Product" and measures/ Values.

There are wizards that help you build cubes and dimensions but in my...

You have probably seen this already "download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc" (SSAS performance Guide)

But the section “How to impact aggregation design” could remind you of something’s you may have forgotten about eg. Maybe its...

Natalie,

Are you an interviewer or interviewee?

If the interview; I would ask the current DBA’s and if possible BI developers to get a feel of what is needed, also Google, it...

Brian did show us how to just user the date part for the file name and in most cases that would probably surfice, however, some packages may run into the...

Brian,

I'm enjoying these videos, and learning some great stuff, keep them up.

Howard

I would also suggest that if you are adding a date to a table you use YYYYMMDD if for no other reason than being able to view them in order.

Another...

Another way you could try this is (in the control flow) to set up a expression. To do this you would drag a constraint from task to another and double...

Thanks for the info. 🙂

Thanks for that.

I don’t understand why it would use the “name” attribute [Fri 02/01/2004] as part of the query rather than the actual key [20040102]. I know why it does...

Jay_Noob,

SSAS shouldn’t be doing any implicit conversion if both the data types on your fact table and dimension table are the same, however, saying that I don’t have that much...

Have you tried enabling the UnknownMember option in the dimension?

Enabling this property can be a great little life saver. When your fact table contains information that is not present...

If your want to remove the time portion of the result you could use this - select dateadd(month,datediff(month,-1,getdate()),0)

Just over 2 1/2 years! I hope it wasn't a sleepless night every night :).

You must have a good memory to remember this post.

Glad to hear it's fixed.