5

SAP Analytics Cloud - Just Ask Feature

 7 months ago
source link: https://community.sap.com/t5/technology-blogs-by-members/sap-analytics-cloud-just-ask-feature/ba-p/13604997
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.
neoserver,ios ssh client

Just Ask is a new feature in SAP analytics cloud powered by Gen AI.

By the help of Just Ask one can query SAC Data models in a normal English Language and can get the expected result.

Steps to get started with SAC Just ask:

Step - 1 :   Click  on the :  himanshu_ts_sharma_2-1707910058181.png  from the Tabs at the right corner:

                  himanshu_ts_sharma_1-1707910032098.png

Step -2 :   Select a Model to Index for Just Ask from Manage Models feature.

                  himanshu_ts_sharma_1-1707976350733.png

Step -3 :  After adding a model to just ask one can :

  • Set the synonyms for the dimension and measures :-  By this user can query model without depending on the exact name of dimension and measure.

                                    

himanshu_ts_sharma_3-1707977203890.png

          For Example : We have created a synonyms "sales" for "before tax amount" measure.

  • Set the user specific rules in the model like :  whenever users queries a measure it displays the result with the cuts of specified dimension in the rule, set the include and exclude filters, set the sort orders.

                        

himanshu_ts_sharma_2-1707977103218.png

                     For Example : Before tax amount is to be shown by branch.

Step - 4 : Now since the model is ready so we can start querying our model.

               Some examples questions are jotted down below:

  • Q1 : Show me top 3 brands by Sales?

                              

himanshu_ts_sharma_4-1707977480269.png
  • Q2 : Who are my top3 consistent customers?

                                 

himanshu_ts_sharma_5-1707977564189.png
  • Q3 : Lowest performing branch by sales in East 

                      

himanshu_ts_sharma_0-1707980173508.png

                      So, we can do multi-dimensional query by adding Branch and East Zone

  • Q4 : What is my sales by month ?

                    

himanshu_ts_sharma_1-1707980219693.png
  • Q5 : Which customer city is generating most sales ?

                            

himanshu_ts_sharma_2-1707980318440.png
  • Q6 : Which branch is generating least sales for Ply

                             

himanshu_ts_sharma_3-1707980372338.png
  • Q7 : How the sales of product group ply performed over month

                        

himanshu_ts_sharma_4-1707980435799.png
  • Q8 :How did marketing spend impact sales by brands in Kolkata?

        Ans :       It shows Correlation of Marketing spend with Sales across Brands in a territory

                       

himanshu_ts_sharma_5-1707980483964.png

NOTE :

The model which we used have the following dimension and measures:

himanshu_ts_sharma_7-1707981326583.png
himanshu_ts_sharma_9-1707981367540.png

Please jot down your ideas and suggestion in the comment box to avail the full of this facility by SAC.

Also, please share your feedback on the blog .

Thanks for Reading,

Himanshu.


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK