zahoorahmad

 Profile Answers by zahoorahmad 

• Apr 12th, 2006

 

In data Warehouse when u change + symbol to - , u would c all the aggregation level in that + this is called rolling down.

So if u again click over that - it would again compressed back to +. This is call drill up.

your Aggregation levels woudl b like

Year>Month>Week>Day>Hour>Minutes>Seconds.

So by changing the symbol from - to + at month aggregation level u can drill up.

reddeppa

• Apr 14th, 2006

 

i think u r not getting my point,,?right..

see in weeks means we have 53 or 54 weeks in year ..right..

my point now which weeks belongs to which month..thats i want how it findout..?

or other it predefined?

sithu

 Profile Answers by sithu 

• Apr 17th, 2006

 

Create a unique reference for the week (ie numbering)

Cheers,

Sithu, sithusithu@hotmail.com

Neha

• Mar 8th, 2007

 

Create a Dimension with the following defination

Select
@select(salesmonth)
where
@Select(SalesWeek) = @Prompt('Select a Week','A','SalesWeek',Mono,)


depending upon the week selected you will be able to drill up to the month.

jgd.ramesh

 Profile Answers by jgd.ramesh 

• Aug 19th, 2007

 

First you set in report level?customer hierarchies and then using drill mode

sandeepkumarc

 Profile Answers by sandeepkumarc 

• Jun 13th, 2008

 

Very simple,  click scope of analysis-> select by hierarcy radio button -> check boxes of year and month -> click ok ->run->generate report-> click drill tab ->you will get another report with drill symbol on it -> open it-> right click on the table-> play around...


Rex