How good are you at editing xml directly?

I don't think it is necessary...

Who ya gonna call?

What did you do Ray?

Are you the key master?

The end of the world as we know it, real wrath of God...

I think this might give some odd results when browsing the cube. However, it should be do-able.

I would probably keep a natural calendar week as part of the dimension,...

Good question. More than anything, QoTD seems to reinforce.....be explicit.

Good one.

Location and job title can make a big difference in salary. Granted, different locations do carry different cost of living concerns, but they also carry a local supply &...

This is kind of a sideways solution to your problem.

I occasionally put a kind of error handling in the query so that if no records are returned, the query returns...

I would think that the Eclipsys ScriptRx software would have to render the report somehow (whether the user sees it or not) in order to create a print job from...

A common solution in data warehousing is to build a calendar table and a time table.

In your case if you built a table with all the time values you want,...

I think some basic SSRS grouping would solve your problem

Col1 & Col2 are your detail

They are grouped by Type

Type is grouped by Set.

They would look something like this

Set1

--Type

----Col1, col2

--Type

----Col1, col2

etc.

Set2

--Type

----Col1,...

Exausted. I wish I had a vacation coming up. I've been fighting an epic battle with a very unstable piece of software for almost a week.

Enjoy your vacation...

Good question.....I wish I was a little more awake when I read it. Maybe next time. Thanks.

I am not sure I can help with this issue.

But, I would still go back to basics. In order to print, you have to have something to...

Does SSIS have the proper authority to drop a user?

uphill