Community
Technology Blog Posts by Members
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP Analytics Cloud - Just Ask Feature

Himanshu_Sharma_26
Explorer
‎2024 Feb 16 8:45 AM
14,835

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7 Comments