SAP Knowledge Base Article - Public

3779223 - Unable to change the table type from crosstab to a non-aggregated list when using live datasphere as data source in SAP Analytics Cloud

Symptom

  • Unable to change the table type from crosstab to a non-aggregated list when using live datasphere as data source in SAP Analytics Cloud

Environment

  • SAP Analytics Cloud
  • Live Datasphere

Reproducing the Issue

  1. Create a Story using live datasphere model in SAC.
  2. Add a table.
  3. Try to change the table type from Crosstab to a non-aggregated list.
    ==>Notice that there is no chance to do this.

Cause

  • The non-aggregated list table type is only available with an extended SAP HANA live connection
  • With a SAP Datasphere live connection only Crosstab is available by design.

Resolution

Keywords

sac, story, table, new table build experience, non-aggregated list, crosstab, change table type, extended hana live connection, datasphere live connection, hana live, list table, aggregation, by design, table type unavailable, switch datasource , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud all versions