SAP Knowledge Base Article - Public

2812912 - How can I delete or remove columns in Canvas / ORD reports ?

Symptom

This article explains how to delete existing columns from ORD / Canvas Reports

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
    • Online Report Designer
    • Report Centre
      • Report - Canvas

Resolution

'Live Data'  Datasource

  1. Edit the Report under concern
  2. Select and edit the query (component) under concern
  3. Choose the 'Edit' Tab

    3_liveData.png
  4. Click the table from which you would like to delete a column

    4_liveData.png
  5. Uncheck the column under concern and wait for the changes to load

    5_liveData.png


 'Advanced Reporting' Data source

  1. Edit the Report under concern
  2. Select and edit the query (component) under concern 
  3. Select the 'Objects' tab and edit the table from which you would like to remove / delete columns from

    advRepObj3.png
  4. Uncheck the column(s) you would like to remove and click 'Apply'

    advRepObj4.png


  5. Alternative to steps 3 and 4: Click the Columns tab
  6. Select the column you would like to remove
  7. Click the X icon - 'Delete Selected Column'
    advRepObj5.png

Keywords

Delete, Remove, del, column, report, ORD, Online, Designer, Canas, Center, Live, Data, REALMs, ODS, Advanced, Reporting, data, source, detailed , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Suite all versions