Drill Down Option

building reports webintelligence
1

Hi,

I have two reports.

In one there are information about the actual date. The drill down for that is Month -> Dept - > Employee

In the second are information about the leave date. The drill down for that is
LEAVE Month -> Dept -> Employee

In the second report, when I drill down, it is ok, but when I drill by, the business objects ask me which drill down I want to see (by month or by leave month).

I know this is because I have the same dept and employee level for both drill downs.

But the user don’t want to see this box (with the question).

How Can I resolve this? Are there other way?

Regards and thanks a lot!

santana (BOB member since 2009-04-16)

2

You would have to create two unique hierachies in the universe, i.e. by duplicating the objects and renaming as appropriate…

Mak 1 :uk: (BOB member since 2005-01-06)

3

How can I do this?

by duplicating the objects and renaming as appropriate ???

I created two hierarchies, one with month and the other with leave month, but the others level is the same for both hierarchies, and the report open a question box when i try the drill by, which hierarchies i want.

Can I change this?
Because the client doesn’t want to see this question box.

thanks for your replay.

regards,

santana (BOB member since 2009-04-16)

4

Create these in the universe, Leave Dept, Leave Employee, e.t.c. then create the heirachy.

Mak 1 :uk: (BOB member since 2005-01-06)

5

There one folder for information about Department (Name and Key) and other folder with information about Employee (Name, Add, …).
Do you think, the best way is I will create a new folder with information for Dept Leave and Employee Leave? Duplicate the information in the universe?

Is that?

thanks again!!!

regards,

santana (BOB member since 2009-04-16)

6

Thats what I was suggesting :).

Mak 1 :uk: (BOB member since 2005-01-06)

7

Ok!

I am going to change for this.

Thank you a lot!

Regards, Santana

santana (BOB member since 2009-04-16)

8

But it is common do you have the same information in different folders in the universe, because the drill down?

santana (BOB member since 2009-04-16)

9

For hierachies to be distinct and not prompt, when used with each other hierachies, you need to make them unique, therefore, you need to provide unique object names.

These can either be natural hierachies, defined by the order of objects in a folder, or universe defined hierachies.

Mak 1 :uk: (BOB member since 2005-01-06)