I am trying to create a warehouse procedure in OI 3.7.2 into SQL 7. I have been successful until I try to do multivalued fields. Not having much experience with OpenInsight, I am using the Create Warehouse Wizard.

When asked how many tables to warehouse into, I selected 2. I chose the single-valued fields for my first table. Then when creating the second table, I am using the default primary key and the @MV (since I don't have a unique mv field to use). Then I selected the multi-valued fields to warehouse. When I try running the Warehouse Procedure, it won't work (it says Failed to create SQL tables). Can anyone give me an idea of what I am doing wrong? Let me know if I need to give more info.

Thanks,

Heidi Korell

View this thread on the forum...