Improving authoring experience for SAP Direct Query reports

No comments

The experience while authoring reports using direct query for SAP data source is sometimes not optimal. Every click sends a query to the data source and we have to wait for the visuals to refresh….

Here is how I work around this issue. It’s not ideal but makes authoring experience a little better.

  • From the ribbon, select File -> Options and settings -> Options.
  • In the Options dialog, select Query reduction.
  • Use the check boxes to reduce cross filtering and enable filter button on slicers and filters.

DQAuthoring_1

With this configuration, now I can reduce the number of direct queries while building the visual. It will be ideal to have a pause option so I can complete creating visuals and un-pause once done.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s