I think I would add Row_Number() to your dataset partitioned by machine, then use the row number of 1 to do your formatting.

- One of the things I'm doing is I have an Excel spreadsheet and I don't know if I can create a report in Visual Studio 2010 that imports this...

I have seen this too, usually as a warning triangle in the lower left...

Volunteer

To answer the initial question. I am not sure there is a Kimball name for this type of design. However, I am going to jump in and coin...

Is your value Fields!WedVar.Value just formatted as a Pct, or is it stored as a pct. You may have to use -.15

burn notice

When setting up your subscription just choose an output format of MHTML

Roll

I think the only way to do this is with the MHTML output option. I think the other formats come as attachments.

The only thing I would say is to move your queries to stored procedures.

If your business logic changes, you change your ETL and your fact table can still contain 1 correct value rather than 3 that have to be deciphered in the end...

Please list both the Total and the Male & Female expressions. It doesn't look like you have any grouping here (hard to tell) but if you don't then scope...

Angle

Pollen