Skip to Content
Technical Articles
Author's profile photo Sreelakshmi Gopal

Calculated Fields in SAC Story

Introduction

Create calculated measures and dimensions in stories of Sap analytics cloud. One of the major advantages of creating these formulas in stories instead of model is that we can use it onetime for the particular story or if we forget to add any calculated fields in model as well.

Methods using an Example

For example creating a bar/column chart with a calculated field.

 

Select create calculation from measures

There in Calculation editor you can see different types of calculation methods which are

  • Calculated Measure
  • Restricted Measure
  • Difference From
  • Aggregation
  • Date Difference
  • Dimension to Measure

And on the right hand side you can see different types of available objects like input controls and formula functions like functions ,operators and conditions.

*Calculated Measures

Calculated Measures are used to apply any kind of mathematical formulas to our data. Here we are using different kinds of functions, operators and conditions.For Example we need to find out the Total duty Percentage.So Total duty value divided by Total accessable value formula used.

*Restricted Measures

Restricting a measure value to a particular dimension.

Here we restricted measure No of shipments  for 0 to 2 Days.

*Difference From

Create a measure that reflects  the calculated difference in value between two time periods like year over year, quarter over quarter  and  month over month.

*Aggregation

The Aggregation calculation creates a measure with an aggregated values such as sum, count or another aggregation types. To produce an aggregate value, SAP Analytics Cloud create  mathematical functions on a measure that  return a single value. Different types of aggregation methods are given below.

Sum : Sum of the selected dimensions.

Count : Count of the selected dimension.

Count dimension : Count of dimension without measures are available.

Average : Average value of Measure values across particular dimensions.

Min : smallest value of selected dimensions.

Max : Largest value of selected dimensions.

These are the mainly used aggregation operations.

*Date Difference

It is used to findout the particular difference between two date fields.If the date field are null this function does not detect the particular datefield.

 

*Dimension to Measure

Dimension to Measure based calculations allow you to convert a string to a numeric value.

Calculated Dimension

From the Dimension of designer select create calculated Measure.

Mainly there are two types of calculed Dimesion methods Which are

*Calculated Dimension

Calculated Dimesions are used to do the calculations of dimensions using mathematical formulas.

*Measure based Dimension

Measure based Dimensions are used to group particular values based on  measures .

Here we grouped clearance time based on 0 to 2 days and Above 2 Days.

Conclusion

This Blog is based on my short term experience in SAP Analytics Cloud. Creating calculated fields in story has been shown here in this blog. Please correct me if there is any mistake.

References:

https://www.sapanalytics.cloud/resources-applying-aggregation/

https://www.sapanalytics.cloud/resources-in-story-calculations/

 

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Dinesh Anblazahan
      Dinesh Anblazahan

      thanks for sharing, have you created calculated dimension at model level?

      Author's profile photo Sreelakshmi Gopal
      Sreelakshmi Gopal
      Blog Post Author

      Hi Dinesh Anblazahan ,

      yes i have created.The same way we can create in model level too.

      Thanks,

      Sreelakshmi

      Author's profile photo Nimish Garg
      Nimish Garg

      Hi Dinesh,

       

      yes, you create calculated column a model itself. Also you can calculate the ageing buckets at model level.

      I have created two scenario where I am calculating buckets in model level and same thing replicated at story level as well.

       

      Thanks

      Nimish Garg

      Author's profile photo shilpa MukG
      shilpa MukG

      hi,

      I have no of weeks(counter) as measure in hana calculation view.in SAC i want to display the no of week count on top of fiscal year hierarchy mainatined in sac like(Y,Q,M).how to achieve that?