Thanks, that worked. I found actual address from the group in Outlook properties.

I found out what the problem is I have SSMS 2005 connected to server 2008.

Thanks.

Yes, it will be joined often with dimention table. But I don't see why INT will use less resources than DATE ? As Michael noted above, INT will take 4...

Thanks, Michael, this is what I wanted to find out.

I wanted to emphasize in my initial post that I am talking abount DATE (not datetime or smalldatetime) data-type, but...

To deal with date, we have another table which is DimDate dimention table. For most of the queries we join fact to dim anyway. However, PK for dim table is...

Thanks. They both good.

I already found the problem. My DataSet1 did not show the + sign on its left side. I refreshed Report Datasets and it appeared there, showing all columns. Thanks.

By my opinion, there is no sharp line dividing DBA and DB developer work. I had some jobs which had title DBA, but I was writing stored procedures and designed...

No, we are not using wizard. The data is loaded with bcp / bulk insert. Version 2005

I know about an update query after the loading data, but this is my last resort if nothing else worked.

We don't have a staging table, the data is loaded...

Fast Track to MDX looks like a good book, but it looks like it's for version 2000. Do they have a 2005 edition ?

Thanks all for your tips, now it works 50%. Here is what I've done so far:

1. In Windows Explorer -> Manage -> Users and Groups I enabled Administrator.

2. Logged...

B.T.W., I just checked my status in Control Panel -> User Accounts and Family Safety -> User Accounts. It shows that Mark is Administrator.

I also have another idea: to install...

This is what I also suspected, Rick. But excuse me for maybe stupid question: how can I check if I am administrator on my PC ? This is Windows 7...

Here is what I tried to do to add myself to SSAS Admin group:

In Object Explorer in SSMS I right-mouse clicked on my connection to SSAS, clicked Properties. In Analysis...