Hi Devi,

Did you find a solution to your problem of filtering the cube data by user, as this is something I am also trying to do.

Regards

Shua

Me too. The wording of that option should have been "A hybrid of TWO or more of the above". By saying one or more, the other answers are covered off,...

BK,

You need to use the statements provided as part of your where clause i.e.

SELECT *

FROM table

WHERE table.field1 = 'test'

and (Field2 between DATEADD(YYYY, -1, DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0))

and...

Hi there,

The following select statement should give you the dates you are after;

SELECT DATEADD(YYYY, -1, DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)) AS [Last Year],

DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0) AS [This...

Thanks Jack - do I feel dumb now, all I needed to do was switch around the direction of the like statement! Cheers.

Hi,

As stated previously the error message always helps, but i'm guessing it is to do with a space after the full stop in the on clause of the inner join...

B....

Hi There,

I would try something like;

WITH GroupBY_CTE AS

(

SELECT max(TOTAL_USAGE) as MAX_TOTAL_USAGE, DATE_PROCESS

from dbo.avayautilizationtbl

WHERE

and DATE_PROCESS >= '2007-10-01 00:00:00.000'

and DATE_PROCESS <= '2007-10-31 00:00:00.000'

group by DATE_PROCESS

order by DATE_PROCESS

)

SELECT A.DATE_PROCESS,

A.MEASURE_HOUR,

A.MAX_TOTAL_USAGE

FROM dbo.avayautilizationtbl A...

Hi,

Are you using Report Builder (web app) or report Designer (visual studio basically)? If using Visual Studio Report Designer then right click on the column header area (brown area of...