on ‎2023 Aug 17 3:51 AM
Hi Experts,
We're currently utilizing Datasphere (DWC) as our backend data warehouse, and we've employed SAC as our frontend reporting tool. A new business requirement has arisen, wherein users need the capability to rectify entries (update in analytics report and save) within the analytics reports. However, upon investigation,
I haven't come across any inherent write-back feature within the DWC tools. I'd greatly appreciate your insights on how we might be able to implement this functionality for our customers.
Your suggestions are most welcome.
Regards
Satrajit
Request clarification before answering.
Hi,
We are on or way to have a seamless integration between SAC and DS. For now, this is how you can architect it
1. Create a planning Model in SAC (same structure as you have in analytical story)
2. Load data from DS into this model
3. Create Input story (input form) on this model (Business Users can enter/modify the data using this input story (input form)
4. Export adjusted data from SAC to DS
5. Combine view on Original and adjusted data
6. Create a story in SAC on this view
You can refer the previous answers to create the connection to import and export data from SAC to DS.
I hope this helps
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 13 | |
| 8 | |
| 7 | |
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.