Skip to Content

SAP Analytics Cloud - Change Import Data Source for an existing SAC model

I have an existing SAC model that was created from BPC. This had a Target and Source Model and a BPC connection from the first build. Subsequently I have deleted the connection and created a new connection. I would like to use this new connection for the existing SAC model (as I have put a lot of stories on top of this model). However this does not seem possible

If I navigate to my model in SAC --> Import Data --> Import Data from SAP BPC

Taget Model --> model name ------- I cannot find my model. It appears I cannot create a connection for an existing SAC model?

Thanks

Graham

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 11 at 10:39 AM

    Hi Graham,

    Can you restore the file (connection? ) by going Files > Deleted files ?

    How about if you go: Browse > Models > (search for your model here) .. tick the row .. then 'import data from bpc' in the dropdown ..

    In the next dialog, you can 'create new connection' before mapping this connection to the existing BPC model.

    good luck !

    regards, H

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 09:38 AM

    Hi Graham - I am not using BPC; that said I think the target model is there but you can barely see it (in my experience) -see below

    Could you double-check?

    Add comment
    10|10000 characters needed characters exceeded

  • May 15 at 10:54 AM

    Hi Graham,

    If once we delete the connection we are not able to update the models built using that connection, So you have to create the connection again and go to the model click on a data source, select SAP BPC and select the connection you have created recently and write the same query what you have used in the model and click on create

    Under Draft sources open the query and map the fields and click on finish

    Note: Under import method use - Clean and replace option

    Add comment
    10|10000 characters needed characters exceeded