Apply Filters to an SAP Analytics Cloud Story

Like in the previous tutorial Modify the Way Story is Displayed you extend the web app by UI elements that dynamically set the filter parameters of the URL in the code. You can easily see the effect of the change in the story that is rendered in the <iframe>.

1. Open the LogResponse.html file with an editor of your choice.

2. Copy the following code. In the file LogResponse.html replace the lines of code of the <style> element. You extend the internal CSS with the formatting of new UI elements, which are implemented later.

   <style>
   * {
     margin-bottom: 12px;
   }
   
   iframe {
     width: 100%;
     height: 900px;
   }
   
   label,
   p {
     display: inline-block;
   }
   
   input[type="text"] {
     width: 150px;
   }
   
   .left {
     width: 150px;
   }
   
   .middle {
     width:  150px;
     margin-left: 100px;
   }
   
   .right {
     width: 150px;
     margin-left: 100px;
   }
   
   p.right {
     margin-left: 125px;
   }
   
   p.middle {
     margin-left: 250px;
   }
   </style>
   

3. Now you provide the new UI elements. Copy the following code and paste it between the header element <h1> and <button> .

   <form id=displayParameter>
     <p class="left"><b>Filter Properties</b></p>
     <p class="middle"><b>Display Mode</b></p>
     <p class="right"><b>Page & Language</b></p><br>
   
     <label class="left" for="story" >Story ID</label>
   	  <input type="text" name="story" id="story" value="7E0050581E24D39CE10000000A784278"><br>
   
     <label class="left" for="model">Filter Model ID</label>
     <input type="text" name="filter" id="model" value="sap.epm:BestRunJuice_SampleModel">
   
     <label class="middle" for="r1">Embed</label>
     <input type="radio" name="displaymode" id="r1" value="embed" onclick="controlCB()">
   
     <label class="right" for="t1">Page</label>
     <input type="text" name="page_num" id="t1" value="1"><br>
   
     <label class="left" for="parameter">Filter Dimension ID</label>
     <input type="text" name="dimension" id="dimension" value="Location_4nm2e04531">
   
     <label class="middle" for="r2">Display</label>
     <input type="radio" name="displaymode" id="r2" value="display" onclick="controlCB()">
   
     <label class="right" for="cb" id="cb_label">Disable Page Bar</label>
     <input type="checkbox" name="pagedisabled" id="cb"><br>
   
     <label class="left" for="value">Filter Value ID</label>
     <input type="text" name="value" id="value" value="SA1">
   
     <label class="middle" for="r3">Edit</label>
     <input type="radio" name="displaymode" id="r3" value="edit" onclick="controlCB()" checked>
   
     <label class="right" for="t2">Language</label>
     <input type="text" name="language" id="t2" value="en"><br>
   
     <label class="left" for="operator">Filter operator</label>
     <select type="select" name="op" id="operator" value="in">
       <option>in</option>
       <option>notIn</option>
     </select><br>
   
     <label class="left" for="applyfilter">Apply Filter</label>
     <select type="select" name="ApplyFilter" id="applyfilter" value="yes">
       <option>yes</option>
       <option>no</option>
     </select><br>
   </form>
   

4. Copy the following code and replace the button click event handler. It sets the model name, dimension, filter operator and filter value into the corresponding URL parameters. The parameters out of the previous tutorial, like mode page and lang, are set as well.

   $("button").click(function () {
   
     var sStory		= $('#story').val();
     var sModel  	= $('#model').val();
     var sDimension	= $('#dimension').val();
     var sOperator	= $('#operator').val();
     var sValue 		= $('#value').val();
     var sAplFilter	= $('#applyfilter').val();
     var mode = $("input[name='displaymode']:checked").val();
     var page = $('#t1').val();
     var lang = $('#t2').val();
   
     var url = "<TENANT_URL>/sap/fpa/ui/bo/story/" + sStory + "?mode=" + mode + "&pageBar=" + pageBar +  "&lang=" + lang 	    //<<<<<<<<<<<<<<<<<<<<< NEEDS TO BE ADJUSTED!
     var data = {};
   
     if(sAplFilter === 'yes'){
   
   			url += "&f01Model="  + sModel + "&f01Dim=" + sDimension + "&f01Val=" + sValue + "&f01Op=" + sOperator; 	    
   		}
   
   
     var pageBar;
     var disabled = $("input[name='pagedisabled']:checked").val();
     if (disabled) {
       pageBar = "disable";
     } else {
       pageBar = "enable";
     }
   
     // 1.step: get the access token
     $.ajax({
       type: 'GET',
       data: JSON.stringify(data),
       contentType: 'application/json',
       url: '/getToken',
       success: function (data) {
         console.log('success');
         console.log(JSON.stringify(data));
   
         var token_details = JSON.parse(data);
   
         var postheaders = {
           'Authorization': 'Bearer ' + token_details.access_token,
         };
   
         // 2. step: get the SAC story
         $.ajax({
           type: 'GET',
           url: url,
           contentType: 'application/json',
           headers: postheaders,
           xhrFields: {
             withCredentials: true
           },
           success: function (data, status, settings) {
             console.log(settings.getResponseHeader("X-CSRF-Token"));
             console.log(JSON.stringify(data));
   
             $("iframe").attr("src", url);
           },
   
           error: function (xhr, ajaxOptions, thrownError) {
             alert(xhr.status);
             alert(thrownError);
           }
         });
       }
     });
   });
   

5. The code of the LogResponse.html file should look something like this:

   <html>
   
   <head>
   <title>SAC Embedding</title>
   <style>
   * {
     margin-bottom: 12px;
   }
   
   iframe {
     width: 100%;
     height: 900px;
   }
   
   label,
   p {
     display: inline-block;
   }
   
   input[type="text"] {
     width: 150px;
   }
   
   .left {
     width: 150px;
   }
   
   .middle {
     width:  150px;
     margin-left: 100px;
   }
   
   .right {
     width: 150px;
     margin-left: 100px;
   }
   
   p.right {
     margin-left: 125px;
   }
   
   p.middle {
     margin-left: 250px;
   }
   </style>
   </head>
   
   <body>
   <h1>Log on Successful</h1>
   <form id=displayParameter>
   <p class="left"><b>Filter Properties</b></p>
   <p class="middle"><b>Display Mode</b></p>
   <p class="right"><b>Page & Language</b></p><br>
   
   <label class="left" for="story" >Story ID</label>
   	<input type="text" name="story" id="story" value="7E0050581E24D39CE10000000A784278"><br>
   
   <label class="left" for="model">Filter Model ID</label>
   <input type="text" name="filter" id="model" value="sap.epm:BestRunJuice_SampleModel">
   
   <label class="middle" for="r1">Embed</label>
   <input type="radio" name="displaymode" id="r1" value="embed" onclick="controlCB()">
   
   <label class="right" for="t1">Page</label>
   <input type="text" name="page_num" id="t1" value="1"><br>
   
   <label class="left" for="parameter">Filter Dimension ID</label>
   <input type="text" name="dimension" id="dimension" value="Location_4nm2e04531">
   
   <label class="middle" for="r2">Display</label>
   <input type="radio" name="displaymode" id="r2" value="display" onclick="controlCB()">
   
   <label class="right" for="cb" id="cb_label">Disable Page Bar</label>
   <input type="checkbox" name="pagedisabled" id="cb"><br>
   
   <label class="left" for="value">Filter Value ID</label>
   <input type="text" name="value" id="value" value="SA1">
   
   <label class="middle" for="r3">Edit</label>
   <input type="radio" name="displaymode" id="r3" value="edit" onclick="controlCB()" checked>
   
   <label class="right" for="t2">Language</label>
   <input type="text" name="language" id="t2" value="en"><br>
   
   <label class="left" for="operator">Filter operator</label>
   <select type="select" name="op" id="operator" value="in">
     <option>in</option>
     <option>notIn</option>
   </select><br>
   
   <label class="left" for="applyfilter">Apply Filter</label>
   <select type="select" name="ApplyFilter" id="applyfilter" value="yes">
     <option>yes</option>
     <option>no</option>
   </select><br>
   
   </form>
   <button type="button">Display Story</button>
   <iframe id="attachframe"></iframe>
   <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
   
   <script>
   $(document).ready(function () { controlCB() });
   
   function controlCB() {
     var mode = $("input[name='displaymode']:checked").val();
     var cbLabel = $('#cb_label')[0];
     var cb = $('#cb')[0];
     if (mode === "embed") {
       cbLabel.style.display = "inline-block";
       cb.style.display = "inline-block";
     } else {
       cbLabel.style.display = "none";
       cb.style.display = "none";
     }
   };
   $("button").click(function () {
   
     var sStory		= $('#story').val();
     var sModel  	= $('#model').val();
     var sDimension	= $('#dimension').val();
     var sOperator	= $('#operator').val();
     var sValue 		= $('#value').val();
     var sAplFilter	= $('#applyfilter').val();
     var mode = $("input[name='displaymode']:checked").val();
     var page = $('#t1').val();
     var lang = $('#t2').val();
   
     var url = https://<TENANT>/sap/fpa/ui/tenants/<TENANT_ID>/bo/"+ sStory + " + mode + "&pageBar=" + pageBar +  "&lang=" + lang //<<<<<<<<<<<<<<<<<<<<< NEEDS TO BE ADJUSTED!
   
     if(sAplFilter === 'yes'){
   
   			url += "&f01Model="  + sModel + "&f01Dim=" + sDimension + "&f01Val=" + sValue + "&f01Op=" + sOperator; 	    
   
   		}
   
     var data = {};
   
     var pageBar;
     var disabled = $("input[name='pagedisabled']:checked").val();
     if (disabled) {
       pageBar = "disable";
     } else {
       pageBar = "enable";
     }
   
     // 1.step: get the access token
     $.ajax({
       type: 'GET',
       data: JSON.stringify(data),
       contentType: 'application/json',
       url: '/getToken',
       success: function (data) {
         console.log('success');
         console.log(JSON.stringify(data));
   
         var token_details = JSON.parse(data);
   
         var postheaders = {
           'Authorization': 'Bearer ' + token_details.access_token,
         };
   
         // 2. step: get the SAC story
         $.ajax({
           type: 'GET',
           url: url,
           contentType: 'application/json',
           headers: postheaders,
           xhrFields: {
             withCredentials: true
           },
           success: function (data, status, settings) {
             console.log(settings.getResponseHeader("X-CSRF-Token"));
             console.log(JSON.stringify(data));
   
             $("iframe").attr("src", url);
           },
   
           error: function (xhr, ajaxOptions, thrownError) {
             alert(xhr.status);
             alert(thrownError);
           }
         });
       }
     });
   });
   
   </script>
   </body>
   
   </html>
   

6. Adjust the variable url. Add the following filter parameters after the story ID:
   The sample story Sample - Revenue Analysis is available in every SAC tenant. In this tutorial we use this story but you can, of course, use your own story.

• https://<TENANT_URL>/sap/fpa/ui/bo/ + sStory + mode + "&pageBar=" + pageBar + "&lang=" + lang + "&f01Model=" + sModel + "&f01Dim=" + sDimension + "&f01Val=" + sValue + "&f01Op=" + sOperator

To apply a filter to a model of a story, you need to set the following parameters that can be applied to a story model. To identify a model, you also need the package name is, e.g. sap.epm:BestRunJuice_SampleModel. In this example sap.epm is the package and BestRunJuice_SampleModel the name of the model. Setting a filter also requires the dimension ID, the filter operator and the filter value ID. The model name together with the package name can be determined by using the following API: https://<TENANT_URL>/api/v1/stories?include=models. The result of this call is a JSON object that lists for your tenant all stories, their models and other meta data. The metadata for our sample story looks as follows:

{
  "name":"Sample - Revenue Analysis",
  "description":"The Best Run Juice Company",
  "createdBy":"XXXXXXX",
  "id":"7E0050581E24D39CE10000000A784278",
  "created":"2018-12-17T22:06:40.632Z",
  "changed":"2019-11-13T11:47:54.551Z",
  "isTemplate":false,"isSample":true,
  "models":[
    {
      "description":"Model for sample",
      "id":"sap.epm.Planned_Events_Sample:Planned_Events_Sample",
      "isPlanning":true
    },
    {
      "description":"Model for the sample story",
      "id":"sap.epm:BestRunJuice_SampleModel",
      "isPlanning":true
      }
    ],
  "changedBy":"XXXXXX",
  "openURL":"/sap/fpa/ui/tenants/XXXXX/bo/story/7E0050581E24D39CE10000000A784278"
}

The section models shows all models used by a story. The value of the id field provides the package name, followed by the model name. This is in the right format and can be used directly.

You can find a detailed description in the documentation SAP Analytics Cloud REST API.

An alternative way to get the model and package name is as follows: Navigate to Menu -> Browser -Y Files, search for your model and open it. The value is displayed in the address bar of the browser as shown on the screenshot below. To get the technical names of the dimension and possible filter values this is only possible on the UI. Lets continue there.

Finding the ID of a dimension is quite easy. First open the story, then click on the Story Filter icon in the tools section (1). The ID of the dimension is shown in the filter dialog, which can be opened by clicking the filter icon (2). Select the entry Dimensions, where you can see all available dimensions of a model.

Hovering over a dimension brings up a tooltip, which shows the dimension ID. In this example we want to filter on the dimension Location with ID Location_4nm2e04531. We will use this later on.

Finally, the ID of the filter value needs to be identified.
Starting from where we left in the filter dialog, we click on the dimension we want to apply a filter on. This brings up the set filter dialog, where you can see the ID of each possible filter value ID by hovering over the value. In our example we want to focus on California, which has the ID: SA1.