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
- Create a Story using live datasphere model in SAC.
- Add a table.
- 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
- To use a non-aggregated list table, move the story/table to a model based on an extended SAP HANA live connection。
Refer to: Use Non-Aggregated List Tables (New Table Build Experience) | SAP Help Portal - For product improvements, submit an enhancement request refer to the article below:
2424376 – How do you create an enhancement request and provide feedback for SAP Analytics Cloud?
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
SAP Knowledge Base Article - Public