Two dimensional data

hi all,

I have been assigned to find solution for a particular kind of
problem. I have to build a matrix comprising of rows and columns of
checkboxes, with the row and column specifying one dimension of data.
The row is the customer location information and column is product
information. The customer location is a tree, something like -
CONTINENT1 CONTINENT2.....
| |
COUNTRY1 COUNTRY2 COUNTRY3....
| | |
CITY1 CITY2.....

The product information also takes a similar form
PRODUCTTYPE1 PRODUCTTYPE2....
|
PRODUCT1 PRODUCT2.........

I believe you all got a fair idea about the x and y axis, though it is
difficult to make it understand without diagrams.

The key data is a matrix of checkboxes, each checkbox signifying a
unique combination of continent - country - city - producttype -
product. This is shown in a HTML page in my case. There is an option
for the user to add new customer or product dimensions - on doing this
the matrix screen should show that too. (All the data is sorted)

I have 2 tables: one for the customer location and one for product. I
have to insert a row in a table for each of the selected checkboxes
with the corresponding continent - country - city - producttype -
product combination. And of course, manipulate it later at my will.

As I was trying to find a solution, I found out that this type of
problem occurs whenever we are dealing with two dimensional data.

Has anyone come across similar problem? How the problem was solved? Is
there a pattern for dealing with two dimensional data?

-- S K.

What are you trying to accomplish once you've got this data structure
set up?

sketh13@yahoo.com wrote:

> hi all,
>
> I have been assigned to find solution for a particular kind of
> problem. I have to build a matrix comprising of rows and columns of
> checkboxes, with the row and column specifying one dimension of data.
> The row is the customer location information and column is product
> information. The customer location is a tree, something like -
> CONTINENT1 CONTINENT2.....
> | |
> COUNTRY1 COUNTRY2 COUNTRY3....
> | | |
> CITY1 CITY2.....
>
> The product information also takes a similar form
> PRODUCTTYPE1 PRODUCTTYPE2....
> |
> PRODUCT1 PRODUCT2.........
>
> I believe you all got a fair idea about the x and y axis, though it is
> difficult to make it understand without diagrams.
>
> The key data is a matrix of checkboxes, each checkbox signifying a
> unique combination of continent - country - city - producttype -
> product. This is shown in a HTML page in my case. There is an option
> for the user to add new customer or product dimensions - on doing this
> the matrix screen should show that too. (All the data is sorted)
>
> I have 2 tables: one for the customer location and one for product. I
> have to insert a row in a table for each of the selected checkboxes
> with the corresponding continent - country - city - producttype -
> product combination. And of course, manipulate it later at my will.
>
> As I was trying to find a solution, I found out that this type of
> problem occurs whenever we are dealing with two dimensional data.
>
> Has anyone come across similar problem? How the problem was solved? Is
> there a pattern for dealing with two dimensional data?
>
> -- S K.

Well I seem to have missed the vital part of all ... I need to store
the unique combinations of the continent - country - city -
producttype - product tuple which the user selectes by clicking the
checkboxes in the matrix in a table. This data will then be used for
sending email notification for the managers as alerts.



Joshua Frank <jfrank@archimetrics.noluncheonmeat.com> wrote in message news:<YlcLc.49822$5Y.19152@cyclops.nntpserver.com>...
> What are you trying to accomplish once you've got this data structure
> set up?
>
> sketh13@yahoo.com wrote:
>
> > hi all,
> >
> > I have been assigned to find solution for a particular kind of
> > problem. I have to build a matrix comprising of rows and columns of
> > checkboxes, with the row and column specifying one dimension of data.
> > The row is the customer location information and column is product
> > information. The customer location is a tree, something like -
> > CONTINENT1 CONTINENT2.....
> > | |
> > COUNTRY1 COUNTRY2 COUNTRY3....
> > | | |
> > CITY1 CITY2.....
> >
> > The product information also takes a similar form
> > PRODUCTTYPE1 PRODUCTTYPE2....
> > |
> > PRODUCT1 PRODUCT2.........
> >
> > I believe you all got a fair idea about the x and y axis, though it is
> > difficult to make it understand without diagrams.
> >
> > The key data is a matrix of checkboxes, each checkbox signifying a
> > unique combination of continent - country - city - producttype -
> > product. This is shown in a HTML page in my case. There is an option
> > for the user to add new customer or product dimensions - on doing this
> > the matrix screen should show that too. (All the data is sorted)
> >
> > I have 2 tables: one for the customer location and one for product. I
> > have to insert a row in a table for each of the selected checkboxes
> > with the corresponding continent - country - city - producttype -
> > product combination. And of course, manipulate it later at my will.
> >
> > As I was trying to find a solution, I found out that this type of
> > problem occurs whenever we are dealing with two dimensional data.
> >
> > Has anyone come across similar problem? How the problem was solved? Is
> > there a pattern for dealing with two dimensional data?
> >
> > -- S K.

How would you represent the n-tuple that on the 2D screen for them to
choose? The only thing I've ever seen that do this kind of thing are
OLAP tools like those in SQL Server. Also see this product:
http://datadynamics.com/Products/Pro...spx?Product=DC.

Basically, this lets you define a hierarchy of information, like
Continent < Country < State < County < City, and ProductType < Product
and provide the data. It then rolls up this information into an
intuitive display. If I understand your requirement, I think this would
do the trick.

sketh13@yahoo.com wrote:
> Well I seem to have missed the vital part of all ... I need to store
> the unique combinations of the continent - country - city -
> producttype - product tuple which the user selectes by clicking the
> checkboxes in the matrix in a table. This data will then be used for
> sending email notification for the managers as alerts.
>
>
>
> Joshua Frank <jfrank@archimetrics.noluncheonmeat.com> wrote in message news:<YlcLc.49822$5Y.19152@cyclops.nntpserver.com>...
>
>>What are you trying to accomplish once you've got this data structure
>>set up?
>>
>>sketh13@yahoo.com wrote:
>>
>>
>>>hi all,
>>>
>>>I have been assigned to find solution for a particular kind of
>>>problem. I have to build a matrix comprising of rows and columns of
>>>checkboxes, with the row and column specifying one dimension of data.
>>>The row is the customer location information and column is product
>>>information. The customer location is a tree, something like -
>>> CONTINENT1 CONTINENT2.....
>>> | |
>>> COUNTRY1 COUNTRY2 COUNTRY3....
>>> | | |
>>> CITY1 CITY2.....
>>>
>>>The product information also takes a similar form
>>> PRODUCTTYPE1 PRODUCTTYPE2....
>>> |
>>> PRODUCT1 PRODUCT2.........
>>>
>>>I believe you all got a fair idea about the x and y axis, though it is
>>>difficult to make it understand without diagrams.
>>>
>>>The key data is a matrix of checkboxes, each checkbox signifying a
>>>unique combination of continent - country - city - producttype -
>>>product. This is shown in a HTML page in my case. There is an option
>>>for the user to add new customer or product dimensions - on doing this
>>>the matrix screen should show that too. (All the data is sorted)
>>>
>>>I have 2 tables: one for the customer location and one for product. I
>>>have to insert a row in a table for each of the selected checkboxes
>>>with the corresponding continent - country - city - producttype -
>>>product combination. And of course, manipulate it later at my will.
>>>
>>>As I was trying to find a solution, I found out that this type of
>>>problem occurs whenever we are dealing with two dimensional data.
>>>
>>>Has anyone come across similar problem? How the problem was solved? Is
>>>there a pattern for dealing with two dimensional data?
>>>
>>>-- S K.

Joshua Frank <jfrank@archimetrics.noluncheonmeat.com> wrote in message


Hi Joshua,

Sorry for such a late reply to your post on my comment. I have gone
through the link you had mentioned in your previous post. It is
exactly the same type of a screen I want to show. Only difference is
that instead of the data fields I have checkboxes.

But my question was how to implement such UI? Is there a pattern
defined for such complicated UI's ? Since I am using DHTML ( I did not
have enough time for a ActiveX control, nor the neccessary skillset )
I foud it very difficult to post data accuratly. Also it is time
consuming. Finally I have made a similer one ( with less features ).
But it does not look good , I have to admit.

Thanks for your post.