The fact table has many columns, including currency_code as well as, for example gross_profit. One row may have a NULL value for currency_code, but there will be a value for...

Thanks for all the help. I originally suggested replacing the null with a key, but management said that it was not the ideal situation as they wanted those specific fields...

Thanks for your time and help, Michael, but, excuse me if i sound a bit dumb here, how do you add a catch-all level? Never heard of or about it...

Thanks again, Darren.

Thanks for your reply, Darren.

Before you replied, i opted for decimal.

Is there much (if at all any) difference between numeric and decimal that you know of? I have tried to...

Have you installed service pack 3?

Thanks Michael,

I appreciate your help.

Hi Scot,

The column in question is a memo data type, which contains over 300 characters.

I don't think it is too much of a serious problem (yet) if this column is...

Thanks for your help, but please excuse me if this sounds stupid,

What is MS KB?

Thanks,

Ryan

Does anyone know of any true platform independant (ie, not Microsoft dependant) client applications (such as the Resource Kit or thinslicer) for AS?

Thanks,

Ryan

So, basically what everyone is saying, is that there no possible way to view the cube over the web exactly the same as it can be viewed in the Analysis...

Thank You, Steve.

I installed the SP3 and everything works perfect.

I really appreciate your help.

Ryan.

Thanks Steve.

I managed to figure it out the other day.

The problem was with the data type of two specific columns. When I was trying to import the spreadsheet, those two...