on 12-09-2010 6:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.