SAP Knowledge Base Article - Public

2324763 - Creating a Calculated Measure or Member

Symptom

How do I create a "Calculated" Measure/Member?

Environment

  • SAP Roambi Cloud

Resolution

How do I create a “Calculated” Measure/Member?

You can create calculated measures/members within charts or tables from the existing columns in your spreadsheet.

Note: This feature is only available with data sources using the raw data/flat vertical table format.  Data formatted with a pivot/crosstab will not have the option to add a calculated measure.

Calculated measures include:

  • Sum
  • Average
  • Count
  • Min 
  • Max

Calculated members include:

  • Day
  • Week
  • Month
  • Year
  • Day of the Week
  • Month of the Year
  • Hour
  • Hour of the Day

 

Creating a Calculated Measure:

 

Choose your desired table/chart and open the chart editor. Tap Plus(+) and select "Measures".

 

2016-06-01_10-41-11.png

 Tap on the Plus(+) to create your calculated measure.

 

2016-06-01_10-41-34.png

Choose your "Base Field", your desired "Summary Totals" and update your "Title". The new “measure” is at the bottom of your list of measures.

 

2016-06-01_10-41-54.png

 

Creating a Calculated Member:

 

Choose your desired table/chart and open the chart editor. Tap Plus(+) and selectMember.

2016-06-01_10-42-23.png

 

 Tap on the Plus(+) to create your calculated member.

 

2016-06-01_10-42-41.png

 Choose your Base Field, your desired Group By and update your Title. The new “Member” is at the bottom of your list of members.

Keywords

Analytics Publisher Create Measure Member Roambi , KBA , BI-ROM-CLD-PUB-BI , Roambi Cloud publishing clients – BI, Cognos & SSR , How To

Product

SAP Roambi Cloud all versions