We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Can you view the SQL behind an FAW visualization?
I am quite new to FAW/ADW HCM and have been tasked with creating a new View. I have a few questions please:
- How can you view/copy the SQL behind an FAW visualization?
2. Is the correct method to get new data from HCM to FAW to a) create a data augmentation table and b) extend the Semantic model by customizing an existing subject area or addition of a new subject area to allow reporting on augmented data extracted in ADW?
Any other advice would be greatly appreciated!
Thanks!
Best Answers
-
Thanks Sumanth
0 -
@JDCal - Thank you for acknowledging the response. Could I kindly ask you to mark the comment that helped resolve your query? This would greatly assist other community users who refer to the thread by clearly indicating the solution and avoiding any ambiguity. Thank you!
0
Answers
-
@JDCal - Please find the answers as below:
In order to get the details of an SQL created for a visualisation, you can check session logs. Please refer the article below for steps/navigation and other details.
For the OOTB content you don't have to create augmentations, but if you have a customized requirement, then the flow described by you is correct to get the data of custom table to FAW warehouse and visualise it in FAW OAC. Thanks.
0 -
@JDCal - Could you kindly mark the post as answered if it helped? Doing so will help other community members find solutions more efficiently. Thank you!
0