try this

= Format(DateAdd("s", -1, Parameters!rsThruDate.Value), "dd-MMM-yyyy")

Apologies for my ignorance, however despite your additional & edited posts, I am struggling to understand the definition of what "Business Day" is.

A day?

A period of time?

Is it related to...

Before in this sort of scenario i have created separate Date and Time dimensions - I have also created sometimes a dimension showing offset from GMT/UTC (in hours) - other...

Absolutely...That's exactly...

Jeff,

Fair point... I have had mixed results with report models, depending on all sorts of factors, but yes, performance can sometimes be an issue.

RedEye,

You missed my point. UDMs are used...

Depends on the date granularity you require, but assuming daily,

FKClientKey

FKDateKey

Stock

Value

And your ETL package would load a Stock & Value record per day, based on the daily balance using your...

Why bother with views?

Why not construct a UDM (Unified dimensional model) layer over the reporting database instead and create report models for your report builders to hit. That's one of...

Derek,

I'd advise you to take a look at this book

http://www.msftdwtoolkit.com/

You're right that an ODS is a pretty good place to start, and yes, you would normally use an ETL tool...

Try looking at the following

The AdventureWorks samples that ship with SQL Server 2005+ - these are now on Codeplex

Project REAL (a proof of concept developed jointly by Microsoft/Barnes & Noble)...

Using BASC and BDESC will effectively ignore parent hierarchy groupings, so to retain them you should just use ASC/DESC

Not a bad site for BI tool comparison.

If you are serious about evaluation, the money spent here is well spent.

http://www.biscorecard.com/

That's a pretty broad question you have there.

Here is the reference site for Project Real - if you read through the documentation and work through the examples, it gives you...

It's not too clear what you are tryin to achieve, however SUM is only one of many aggregation behaviours...

Perhaps you might want to look at creating a measure based...

No, IIS is only needed on the report server, not where the reportserver catalog databases are placed and yes, it is a common configuation, especially when you want to have...

Does this help?

WITH SET [OrderedSet] AS

'ORDER ( [Retailer].[Retailer Name].[Retailer Name].MEMBERS,

[Measures].[Sales Value Gross RRP Excluding Taxin Local Currency]...