[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Data Warehousing Multi-Valued fields (OpenInsight Specific) ====
=== At 06 JUN 2001 05:50:53PM Heidi Korell wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
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




</QUOTE>

[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=2A891E7A53E8C55885256A6300780437|View this thread on the  forum...]]