locked
Reg : Master Data services import RRS feed

  • Question

  • Hi all

    I am using Microsoft Sql server 2012 Master data services.When i load data thru microsoft excel add in, the staging table for eg: stg.Category_leaf does not contain any data.Why?

    Is there any option that we can see data in stg.Category_leaf

    Rather if i insert thru sql query i can see the data.

    Please help 

    Thanks

    Thiru

    Monday, November 17, 2014 11:39 AM

Answers

  • The Excel Add-In loads data into the model using the Web Services API, instead of the staging API.

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Proposed as answer by Vincent Chen (X) Monday, November 17, 2014 9:07 PM
    • Marked as answer by Ms. Thiru Tuesday, November 18, 2014 5:09 AM
    • Unmarked as answer by Ms. Thiru Monday, December 1, 2014 9:47 AM
    • Marked as answer by Ms. Thiru Monday, December 1, 2014 9:47 AM
    Monday, November 17, 2014 2:04 PM
  • >thanks for the reply.so where can i see the data which i am loading through Excel add in

    It's visible in the Web UI, the Excel Add-In or any Subscription Views.

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Marked as answer by Ms. Thiru Monday, December 1, 2014 9:47 AM
    Tuesday, November 18, 2014 6:17 PM

All replies

  • The Excel Add-In loads data into the model using the Web Services API, instead of the staging API.

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Proposed as answer by Vincent Chen (X) Monday, November 17, 2014 9:07 PM
    • Marked as answer by Ms. Thiru Tuesday, November 18, 2014 5:09 AM
    • Unmarked as answer by Ms. Thiru Monday, December 1, 2014 9:47 AM
    • Marked as answer by Ms. Thiru Monday, December 1, 2014 9:47 AM
    Monday, November 17, 2014 2:04 PM
  • Hi David

    thanks for the reply.so where can i see the data which i am loading through Excel add in

    Thiru

    Tuesday, November 18, 2014 5:13 AM
  • >thanks for the reply.so where can i see the data which i am loading through Excel add in

    It's visible in the Web UI, the Excel Add-In or any Subscription Views.

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Marked as answer by Ms. Thiru Monday, December 1, 2014 9:47 AM
    Tuesday, November 18, 2014 6:17 PM