Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

         Ans :

                              himanshu_ts_sharma_4-1707977480269.png

  • Q2 : Who are my top3 consistent customers?

                                  

                                      himanshu_ts_sharma_0-1708270917540.png

 

  • Q3 : Lowest performing branch by sales in East 

         Ans:

                 

                      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 ?

         Ans : 

                    himanshu_ts_sharma_1-1707980219693.png

  • Q5 : Which customer city is generating most sales ?

       Ans: 

                            himanshu_ts_sharma_2-1707980318440.png

  • Q6 : Which branch is generating least sales for Ply

         Ans : 

                             himanshu_ts_sharma_3-1707980372338.png

  • Q7 : How the sales of product group ply performed over month

        Ans:

                        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_1-1708270949179.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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

4 Comments
Labels in this area