Business Objects - How we drill up week to Month?

GeekInterview.com > Interview Questions > Data Warehousing > Business Objects

Go To First | Previous Question | Next Question

Business Objects | Question 21 of 242

How we drill up week to Month?

Total Answers and Comments: 6

Last Update: June 13, 2008 Asked by: reddeppa

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

April 12, 2006 20:23:16

zahoorahmad

Member Since: April 2006 Contribution: 7

RE: How we drill up week to Month?

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.

Is this answer useful? Yes | No

April 14, 2006 07:28:42

reddeppa

RE: How we drill up week to Month?

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?

Is this answer useful? Yes | No

April 17, 2006 01:25:57

sithu

Member Since: March 2006 Contribution: 46

RE: How we drill up week to Month?

Create a unique reference for the week (ie numbering)

Cheers,

Sithu, sithusithu@hotmail.com

Is this answer useful? Yes | No

March 08, 2007 15:14:51

Neha

RE: How we drill up week to Month?

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.

Is this answer useful? Yes | No

August 19, 2007 02:43:08

jgd.ramesh

Member Since: August 2007 Contribution: 11

RE: How we drill up week to Month?

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

Is this answer useful? Yes | No

June 13, 2008 13:58:37

sandeepkumarc

Member Since: March 2008 Contribution: 5

RE: How we drill up week to Month?

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

Is this answer useful? Yes | No

Go To Top