Post reply

Matirx/Cube ??

  • June 27, 2006 at 10:44 am

    #366494

    I have an Excel Matix. Until now I've always created a table that had all the possible combinations. Is there a type of table or another object that would create a "Matrix"? Would a CUBE be an option? TIA!

  • June 27, 2006 at 11:51 am

    #646165

    A cube is more of a three dimensional object.  It sounds to me like you have 2 dimensions here, right?  Anyway, if you are looking for a method of storing your Excel data and being able to create a result set of all possible combinations, create 2 tables and store the data accordingly.  To create the result set, use a CROSS JOIN (cartesian product) when querying the data. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • June 27, 2006 at 11:58 am

    #646169

    Thanks John. I was trying to avoid having to create two tables if there was a way. But I guess not. I just thought maybe there was some sort of support for something like this. Thanks again!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply