Hey Larry,

Some nice people have put together a sample set of Stored Procedures (these are contained in assembliy/ies that you add to your AS DB) and one of the functions...

Can we assume that you've got the users in Roles for the cube/database?  What set up do you have (IIS on same server as AS)?

Also make sure that the client has been updated to the same level of service pack that the server is currently on.  Note that the service packs of SQL and...

Yep, it's a good book.  There's a few grammatical errors in there but the gist is what counts.  If/when you need to look at many-to-many dimensons there's a good paper on...

You're definitely looking towards Dashboards (possibly scorecarding but that's another topic) for your senior management.  I would just add the following points to look for/be aware of:

• even thoug your current...

For front ends (ie client tools to view cubes in particular), a lot of people love Cognos and many Analysis Services shops use ProClarity.  Look for Proclarity inspired functionality to...

I would go a little further on Ricks comment about 'another way to organised(sic) your DB', usually a DW goes further than just denormalizing the normalized OLTP schema(s) [yes, in...

Check your Key and Name columns for the DOW attribute you've created to ensure that the key is set to the integer field and the name to the dayname.  If...

You can still use the same function (ie the tsql DATEPART function) but you create the fields in the table within the data source view rather than within the Attributes...

Looks like you can do it by manually adding calculated columns to the table within the DSV (e.g a field called 'Year' with a function of 'Year(Your_column)') but if you...

I agree that with more time and configuration testing more demos would go as planned but sometimes the problem's a carbon-based one, like when your presenter is a mouse-mover (moving...

Just out of interest, did you do a 'Process Update' on your dimension before doing the cube process?  If so, did you open/browse the dimension (not from within the cube...

I'm all for the pre-recording of the demo, especially if it meant we could be given a copy afterwards - there's nothing worse than getting the slide deck and there's...

Simon,

Is this something like NetProfit = Sales - Costs?  If so, can you use the style of expression like -> =Fields!Sales - Fields!Costs within the formula for the NetProfit cell?

In your original post you indicated that you had a pivottable based on MSAccess data.  As I alluded to in my earlier post, if you have a pivottable built on...