cancel
Showing results for 
Search instead for 
Did you mean: 

Drill option for Many to Many Relationship

Former Member
0 Kudos

Hi experts,

Is nobody there to answer my proble or Is my problem is not understand/complicated . At least excepting some feed back

i hope some experts are there to answer i am waiting for it.

Can any one help in this problem

I having two tables

table: 1

Company

Id----


Name

1----


A

2----


B

3----


C

table:2

Site

Id----


Name

1----


X

2----


Y

3----


Z

relationship between two table is like:

Tab1 and Tab2

1------1

1------M

M------1

M------M

Data values is like this below:

A --- X,Z

B --- X,Y

C --- Z,Y

According to above example i required drill option. when i drill down to company column A it shows the site table with respective columes X and Y. same with others.

Can it possible below example Site to Company If i drill up Site Z it should show me A and C same with others

Z -


AC

X -


AB

Y --- BC

Please help in this problem.

Thanks & Regard

Prasad

Edited by: prasad_gbp on Dec 9, 2010 7:58 AM

Edited by: prasad_gbp on Dec 9, 2010 2:34 PM

Edited by: prasad_gbp on Dec 10, 2010 8:02 AM

Accepted Solutions (1)

Accepted Solutions (1)

MariannevL
Advisor
Advisor
0 Kudos

Hi Prasad,

I"ll give it a try, but I'm not 100% sure I grasp the problem.

So let me start by translation drill hierarchy by drill path.

You can put any objects that make sense to explore in a row in a drill path,

they do not have to have a hierarchycal relationship.

Also, the object can be in more then one drillpath.

So in your case, I would define two drillpaths, one that goes from Company to Site,

and one that goes from Site to Company.

Now if you start at company A and drill down to sites X,Y.

You have two options:

1) drill up to company A again.

2) discard the company A selection (change drill down filter to all iso A)

and drill down to companies belonging to one of the sites shown.

Hope I got your question right,

Marianne

Answers (0)