SAC Performance with Live Query Attribute reduction

[niels1515]

Hi, I have built a query for a live data connection in a CDS view. I am now consuming the query via a live data connection and want to increase the performance. I certainly need to reduce the dimensions here. But how do I get the attributes reduced?
For example, do I simply have to comment out the “AnalyticsDetails” in the CDS view:
@AnalyticsDetails.query.display: #KEY_TEXT
ShippingType

Or do I only get the attributes reduced if I reduce the dimensions?
How many dimensions are recommended in a live data model in the SAC? And what should be a target number for the attributes?

How can I see which dimension has the most Attreibute

Greetings Niels

[Yogeshwar_M]

Hi @niels1515 ,

To improve performance, filter out only the required dimensions and select only the necessary dimensions and measures in the CDS view query as shown below

Kindly upvote if you find it useful.

Thanks

[niels1515]

@Yogeshwar_M thx for your Response. But this is only working with an Import Data Connection. Do you have any other ideas?