Grouping dates

Last Post 09 Jul 2004 06:01 AM by scardoso. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
scardoso
New Member
New Member

--
09 Jul 2004 06:01 AM
Hi!

I want to get data from, for example, 1 to 15 of June, but i want to receive the information by month.

Example:

select
{sales} on columns,
{[Dim_Date].[June].[1]:[Dim_Date].[June].[15]} on rows
from cube1

This query will return the sales by day, but i want by month.

Can someone help me?
You are not authorized to post a reply.

Acceptable Use Policy