cancel
Showing results for 
Search instead for 
Did you mean: 

Show/Hide Table columns in SAC Dashboard with Linked Analysis

GavinMonteiro3
Participant
0 Kudos

Hi,

We are building a SAP Analytical Cloud (SAC) Dashboard.

It is in a table format, where business has a requirement to select columns that should be visible

Below is the format that should be visible.

GavinMonteiro3_0-1716970505721.png

Below columns should be available as a checkbox (all these columns are present in the model as well)

GavinMonteiro3_1-1716970528095.png

In case, business select these columns, then additional columns should be visible in the table.

GavinMonteiro3_0-1716970849529.png

 

How can we achieve this in SAC ?

 

@N1kh1l do let me know if you have any suggestions to achieve this.

 

Regards,

Gavin.

 

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert

Hi GavinMonteiro3,

  For such use case, I would suggest to use data analyzer instead of story table. Or you could allow user to navigate from story table to data analyzer where he can freely decide how to analyze the data. Check this help page for more detail: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/3bd79ad3e58442e7a5499...

Best regards, William

GavinMonteiro3
Participant
0 Kudos

Hi William,

Thank you for your response.
Yes, Data Analyzer is always an option. 
I just wanted to understand if there is a way to achieve this from stories without using Data Analyzer.