try something like this

SELECT NON EMPTY {[Measures].[b1/b2/b3]} ON 0,

NON EMPTY {[a1].ALLMEMBERS)} ON 1

FROM CUBE_NAME

Hi Guys,

any thoughts about this post!

can help would be appreciated

Thank you

No i dont have a calender table but i do have public holidays table

but again that contains dates only does not contain time

Intresting topic

I was looking into doing something on the same lines but with excel (create new spreadsheet based on grouping).

I have created reports which can create different tabs in the...

I am using report builder 3.0 which is pretty similar to visual studio 2008

there is refresh button in report builder for clearing the cache

same way there is a refresh button...

That works like a charm

Thanks for your help

sunday is supposed to be the last day of the week

Monday is the first day of the week

and sunday is the last day of the week in my query

what do i do in that case??

Hi kingston,

Thats spot on

and very clever

should have though about that

the other thing which i noticed is

when i am trying to find the firstday of the week for 04/09/2011 it...

Hi andre,

Totally agree with you

I might have not been clear in my previous post

This is just a part of my query

SELECT 'Week' + CONVERT(VARCHAR(8),DATEDIFF(WEEK, DATEADD(MONTH, DATEDIFF(MONTH, 0, '2011-09-02'), 0), '2011-09-02')...