Thanks Michael. I've decided to track the item costs in the fact table, and use the ETL scripts to split costs into material/labour/overhead costs.

There is an item cost on...

Sorry, that's the point I'm trying to make (but clearly missed). I need to track the item costs historically, and I'm trying to work out the best way to...

I was able to extract the CHM file using Microsoft's HTML Help Workshop. I can see the help files and worked out number (2). Thanks Steve.

Thanks Steve, that's really useful.

That Excel sheet is really clever.

Is the BI Studio installed on VS 2003?

sqlindia,

There are two authors considered to be the pioneers of data warehousing - Kimball and Inmon. They have some great introductory books and websites:

http://www.kimballgroup.com/

http://www.inmoncif.com/

You might...

You've probably already tried this, but I find a full reprocess (all shared dimensions, then the cube you need) can help with this kind of thing.

Try this (I'm no expert on MDX, but hopefully this will get you started).

Firstly, you'll need to have a measure for WeeklyBalIntran. You then need to compare this measure...

Answered my own question again - DatePart("ww", Now)

Woohoo!

I've taken the "Fields!" prefix out of the returned value in the formula above. Then using =Fields(Code.MonthField(24)).Value, in a table, against the customer, I get the value I'm after.

OK, I've been able to "stringify" the field name using the following formula in the Report Properties Code section:

--------

Public Shared Function MonthField(ByVal MonthsAgo As Integer) As String

Dim EvalDate As Date

EvalDate...

When connecting to Query Analyser are you authenticating using Windows-integrated authentication? When you say Reporting Services doesn't see the data, is it that the report doesn't generate any data...

Sorry to harp on about Excel again, but would it help to use an empty string ("") instead of space (" ") in your IIF function?

I don't know much about...

Hi Steve,

For some reason I had issues getting the IF statement to work inside the GENERATE statement. However, I found a workaround using the following:

'GENERATE({[TimeNJ].[Fiscal].[Month].MEMBERS}, {[TimeNJ].[Fiscal].CURRENTMEMBER.LAG(1)}, ALL) - GENERATE({[TimeNJ].[Fiscal].[Month].MEMBERS},...

Assuming you're using a Pivot Table, there's a few options in Excel for handling empty cells. Try getting Field Settings and uncheck the "show items with no data" field....