jiggles

QoTD keeping us on our toes. Nice question, thanks.

The first thing I would try is to deploy your report to your production environment. Then go into the Report manager and change the data source there. This...

So if the end date is the parameter you are trying to keep within 18 weeks, then go to the Available Values of the end date parameter and build a...

mmmmmm......bagels

I was up late last night working. I am looking at the question and thinking, "Gee, I didn't think you could group that way" and in my fatigue I...

In SSRS I usually use something like

=FormatDateTime(Today(),DateFormat.LongDate)

or

=FormatDateTime(Today(),DateFormat.ShortDate)

Aside from the copy & paste, the article is excellent. Although I think I wouldn't call it a best practices article as much as calling it something Optimizing your...

Generally I would create all common calculations & measures in the cube using MDX Expressions. Leave the ad-hoc and infrequently used calculations to the report unless the calculation is a...

sing4you (9/10/2010)

Save...

Personally I think MDX excels at time based calculations. I think it is one of the main reasons to use MDX.

Nice question. Took a minute to work out the logic in my head.

I walk every day, but usually in circles.

Unless you are looking for live data consider making a report database that you load at regular intervals (daily is common, some people do less often, some more often) from...

Can you add views with keys and indexes to your production db? If you can they use the views as your source instead of the tables.