1

SAC model with csv table from DWC integration

 1 year ago
source link: https://answers.sap.com/questions/13773737/sac-model-with-csv-table-from-dwc-integration.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Search Questions and Answers
1 hour ago

SAC model with csv table from DWC integration

27 Views

I have a model and story in SAC.
I want to add an analytic table from DWC that i have created from a csv file to the model or story in SAC.
Specifically I need to do a left join(SAC model/story being the primary) based on a few domensions that exist both in the SAC model/story and the table in DWC.
Lets say 3 different ID dimension.

What is the best way to approach this?

Thanks for any help.

1 Answer
Sort by:
Best Answer
53 minutes ago

Yan Gerzon

If you want to just add a table based on another model/file/connection you can use the Add Data option

image.png

But you if you want to performs join between the two data set, you need to go for story blending (not supported in optimized design mode). For this you need to create the model first based on DWC.

image.png

Another option is to enrich your primary model with data from another data source in the data wrangling. I would not prefer this as it involves lot of regression for existing artifacts.

Hope this helps !!

Nikhil

Attachments
image.png (33.7 kB)
image.png (31.7 kB)
1 comment
9 minutes ago

Thanks for the reply.

"For this you need to create the model first based on DWC."
When I make a live connection between DWC and SAC the result is directly a story, not a model.
Should I make a different connection rather then a live one to be able to have the DWC data as a model?

Know someone who can answer? Share a link to this

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.

You must be Logged in to submit an answer.

Please provide a distinct answer and use the comment option for clarifying purposes.
10 characters required.

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK