Excel services requires you to specify the trusted locations in the SharePoint Central Admin settings.

Also we had similar issues in our environment due to using Kerberos for authentication. Our SharePoint...

From a cube level you can use perspectives to present different subsets of cubes to different audiences.

I haven't tried to lock down excel, but I have published pivot tables to...

I'm not sure about giving the business options. What's with all these UAT man hours? Couldn't we save money by assuming development will just work?

It's definitely a good thing though...

You could probably easily achieve this using calculated members

A common theme I've noticed in many of the replies is that a lot of us struggle to be able to find the time to get certified, and the question...

Our large kitchen area includes a ping pong table that gets a lot of use. Once a year a tournament is held, with the kitchen being rearranged to be more...

I'm a big advocate of data warehousing for reporting.

Structuring data to support reporting for faster querying

OLTP and OLAP not competing for resources

OLTP schema changes generally only affects your ETL...

Sounds like there is a calculated member that is trying to perform a subtraction using a string

the basic rule is that if bad data is possible to exist by database constraints (even if it shouldn't by business rules) somehow it will get into your database

if you...

UTC Time is generally the way to go if you have multiple timezones. If your application evolved from a certain timezone and everything is stored as that timezone, its not...

We here have a team mascot of Fozzie Bear from the Muppets. He sits on the desk of whoever messed up last. We've even attached a bicycle horn that is...

The reality is there is never enough time, however the bigger reality is there will never be a time where you get to come back and fix it later and...

When I studied at University (albeit 9 years ago) I think there was around 400 people studying my course and it would have been about 5% female.

I cannot say I've...

Last year we had a full test of our disaster recovery plan (always comforting to be part of a company that has one). Mostly went well except that the disk...

I think company events are important to strengthen employee relationships. However they do need done well. I know our non-drinkers aren't particularly fond of our Christmas Party that can feel...