Skip to Content
0
Former Member
Aug 14, 2013 at 10:56 AM

ANALYTIC VIEW PROCESSING AND SQL USAGE

48 Views

Hi Friends,

Why is it necessary to have a group by defined while querying on the analytical views in the SQL? How is the processing done at the analytic view?

I have a requirement in which I need to extract aggregate data(count) based on the time range that is passed.

for this we have an analytic view that gives me data set per day .(count(measure) with the normal attributes).

If I need this aggregation for a different period like for date range eg 1 month ,last 1 year etc how can this be accomplished by the same analytic view.

?

Please suggest.

Thanks,

With Regards,

Chetan Pant