This problem has been bugginh me since friday! After a good weekend I managed to find the solution 🙂

ALTER VIEW [dbo].[neoset_dailySalesManReport]

AS

SELECT distinct TOP (100) PERCENT s.contentid, s.entryDate...

sorry guys, my bad...I was I wasnt concentrated enough

I use the dimension wizard to generate the new dimension. I cannot see how I can specify that the date there can be of integer format. Can you elaborate on...

I am talking about the pattern::

UPDATE t

SET var1 = var2

FROM someTable,(

...

where is this bi workbench..?do I built cubes with it?

seems to be good...I was searching with olap tutorial and the results were not good...thanx

what exactly should I change there?

Thanx a lot, finally Sql on my pc...

I am downloading right now...I hope this works

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000:...

No there is no such exe...!!!

It's my home pc, I checked out my account in the control panel and I am the admin...

Surfing the net I found out that I can solve this problem by...