# DataSet Migration **URL:** \ **Category:** Q&A\ **Tags:** data-source, dataset, Business-Intelligence-Engineer, quick-sight\ **Created:** [July 20, 2023, 3:37pm UTC](https://community.amazonquick.com/t/dataset-migration/15968 "2023-07-20T15:37:56Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![vshivku1](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vshivku1](https://community.amazonquick.com/u/vshivku1)\ **Post date:** [July 20, 2023, 3:37pm UTC](https://community.amazonquick.com/t/dataset-migration/15968/1 "2023-07-20T15:37:57Z")
Hi Team , I am migration my Obiee rpd based model in Quicksight Dataset and i am getting the following the problems . Here is the explanation about the tables and it relationship . Table 1; Revenue (Fact ) Table 2 : Customer (Dimension) Table 3 : Address (Dimension) Table explanation : Revenue is fact table and is joined with Customer table and for every 1 customer row in Customer table has multiple records in Revenue table . Address is joined with Customer table and every 1 customer there are mutilple address in address table. ISSUE : when I create this design in OBIEE rpd and then create a report and in a report if i select 1 dimension from customer table and 1 measure from revenue table it gives me correct result as what is there in database . On the contrary when i do the same in Quick Sight as it is getting joined with all 3 tables it gives me duplicate rows . I can attach sample data for all 3 tables if it is required. Thanks & Regards Shiv ---
**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\ **Post date:** [July 20, 2023, 5:17pm UTC](https://community.amazonquick.com/t/dataset-migration/15968/2 "2023-07-20T17:17:04Z")
Hi @vshivku1 - Yes please, please share sample data . This is an interesting observation. @David_Wong - Any advise. Regards - Sanjeeb ---
**Author:** ![vshivku1](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vshivku1](https://community.amazonquick.com/u/vshivku1)\ **Post date:** [July 21, 2023, 5:58am UTC](https://community.amazonquick.com/t/dataset-migration/15968/3 "2023-07-21T05:58:27Z")
Attached is the data for the above tables . Revenue & Customer joining condition : Cust\_key = Cust\_Key Customer & Address Joining condition : Address\_Key = Address\_key Thanks & Regards Shiv ---
**Author:** ![vshivku1](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vshivku1](https://community.amazonquick.com/u/vshivku1)\ **Post date:** [July 21, 2023, 6:06am UTC](https://community.amazonquick.com/t/dataset-migration/15968/4 "2023-07-21T06:06:51Z")
@Sanjeeb2022 How should I attach the files. Please suggest me . Thanks & Regards Shiv ---
**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\ **Post date:** [July 21, 2023, 6:15am UTC](https://community.amazonquick.com/t/dataset-migration/15968/5 "2023-07-21T06:15:25Z")
There is an option to insert data as a table. Its a new feature in the settings. ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/3/359b63b1d37b149d11159a3d9cc1e212a612c1b5.png) Can you use that and upload sample data ( ensure you should not share PII info). Regards - Sanjeeb ---
**Author:** ![vshivku1](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vshivku1](https://community.amazonquick.com/u/vshivku1)\ **Post date:** [July 23, 2023, 4:41am UTC](https://community.amazonquick.com/t/dataset-migration/15968/6 "2023-07-23T04:41:37Z")
Hi @Sanjeeb2022 Apologies for the delay . Is there any other options available . Inserting table and inserting values is a tedius process . it has its own limitations. I can share on drive . There is PI information in this dataset. ---
**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\ **Post date:** [July 23, 2023, 4:36pm UTC](https://community.amazonquick.com/t/dataset-migration/15968/7 "2023-07-23T16:36:30Z")
Hi @vshivku1 - In that case, I will advise you to raise a ticket to AWS Customer support and show the use case so that they can analyze it and provide the solution w.r.t Quick Sight. To raise a ticket, please follow the link - [Creating support cases and case management - AWS Support](https://docs.aws.amazon.com/awssupport/latest/user/case-management.html) In parallel, I am also trying to create some dummy data and replicate the usecase. We may not exactly build the back end query like OBIEE but the output of both reporting tool should be same. Regards - Sanjeeb ---
**Author:** ![vshivku1](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vshivku1](https://community.amazonquick.com/u/vshivku1)\ **Post date:** [July 24, 2023, 6:17pm UTC](https://community.amazonquick.com/t/dataset-migration/15968/8 "2023-07-24T18:17:08Z")
Hi Team , @eperts @Naveed I am migration my Obiee rpd based model in Quicksight Dataset and i am getting the following the problems . Here is the explanation about the tables and it relationship . Table 1; Revenue (Fact ) Table 2 : Customer (Dimension) Table 3 : Address (Dimension) Table explanation : Revenue is fact table and is joined with Customer table and for every 1 customer row in Customer table has multiple records in Revenue table . Address is joined with Customer table and every 1 customer there are mutilple address in address table. ISSUE : when I create this design in OBIEE rpd and then create a report and in a report if i select 1 dimension from customer table and 1 measure from revenue table it gives me correct result as what is there in database . On the contrary when i do the same in Quick Sight as it is getting joined with all 3 tables it gives me duplicate rows . I can attach sample data for all 3 tables if it is required. Thanks & Regards Shiv ---
**Author:** ![eperts](https://avatars.discourse-cdn.com/v4/letter/e/50afbb/32.png) [@eperts](https://community.amazonquick.com/u/eperts)\ **Post date:** [July 24, 2023, 6:47pm UTC](https://community.amazonquick.com/t/dataset-migration/15968/9 "2023-07-24T18:47:20Z")
Hi @vshivku1 - Couple of questions: 1. With OBIEE are you querying the database live, ie direct query? 2. With Quicksight are you querying the database live, or using SPICE? Can you also confirm the relationship between Customer and Address? Is it many-to-many? ---
**Author:** ![vshivku1](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vshivku1](https://community.amazonquick.com/u/vshivku1)\ **Post date:** [July 24, 2023, 7:10pm UTC](https://community.amazonquick.com/t/dataset-migration/15968/10 "2023-07-24T19:10:21Z")
Hi @eperts , Yes I am querying the database live for OBIEE. In Quick Sight i have created a spice layer. Relationship is One to many . 1 customer can have multiple address in address table. I am happy to share the sample dataset .but i am not able to upload it here. Thanks & Regards Shiv ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [October 20, 2023, 1:55am UTC](https://community.amazonquick.com/t/dataset-migration/15968/11 "2023-10-20T01:55:17Z")
Hello @vshivku1 ! Were you able to find the solution for this or are you still running into trouble? I also recommend raising a support ticket with AWS for this particular case. I am going to archive this topic since it has been open for an extended period of time. If you would still like assistance with this, or if you have a new Quick Sight question, feel free to post a new topic in the community so you will be at the top of the priority list for a response from one of our Quick Sight experts. Thank you! ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [October 20, 2023, 1:55am UTC](https://community.amazonquick.com/t/dataset-migration/15968/12 "2023-10-20T01:55:20Z")