In that case, the best place to start may be your current employer. Every one can use BI whether they realize it or not.

That sounds like the path I regularly follow. Occupational hazard?

How do you spell relief?

Excedrin

Albany NY, by way of Chicago, Los Angeles, and Miami.

Any Albany area folks interested in starting a SS user group?

jcaldwell-752832 (4/26/2010)

---

So you can define one calculated measure which uses an average aggregate function for time dimension but a sum aggregate function for all other dimension types? My MDX...

My general opinion is that fact tables are best at the most granular level. This gives you the most flexibility with regard to your analysis and reporting.

The...

Define your measure with an MDX expression

Something like

Avg(Descendants(DimensionName.CurrentMember, ChildMember level you wish to use), Measures.Measure you would like to Avg)

Good luck.

I don't know if there is a best practice on this but there are two areas you could look into.

You could use a script task and strip out the column...

Check this out:

http://searchsqlserver.techtarget.com/tip/Five-steps-to-event-handlers-in-SQL-Server-Integration-Services-SSIS

Hopefully it will help.

Another approach you can use is just put the email task as the next step with a failure precedence constraint.

Excel 2007+ has the ability to link directly to cubes. You can do some very powerful things with it.

Meetings are all too frequently where minutes are kept and hours are lost. The best meetings are the ones with an agenda, and people that understand and follow the...

I agree this is an excellent book, but to me more of a practical solutions sort of...

Because of these, and other issues with Excel as the source I make it a practise to run all columns from Excel through a Data Conversion Transformation and manually configure...

It is possible but you are limited to the same unit of measure on the Y axis. For example it is possible to do something like monthly sales as...

lynx