How to Permanently Disable Result Rows in Analysis for Office (AFO)

[former_member462348]

Hi Experts

When am using Analysis for Office, each and every time when I drop the columns, Result rows are getting generated and its obviously takes more time to display the required data when running the report for large Data sets.

I need to remove the Result rows manually after doping the columns. But is there any other way or settings to do in Excel, to permanently avoid displaying the Result rows in Analysis for office.

I am using the version - 2.4.3 Patch 2. Kindly help me to solve this.

Thanks
Rufus Samuel

[harish_kancharla]

How to disable the Result set in Analysis for office Permanently , when ever I insert new row Result is showing , and data limit is exceeding.

[TammyPowlas]

Hello Rufus - the fastest way is to turn off results back in the BEx query, assuming that is your data source.

What is your data source?

Performance has improved with Analysis Office 2.6

Separately, for long times navigating, you can also look at the pause/refresh feature.

[former_member462348]

Hi Tammy,

I am using HANA Calculation Views as the Data Source. And my views has many columns like 50 Plus.

the fastest way is to turn off results back in the BEx query - But Actually how to Turn off in Analysis For Office ?? Can you please share me the Screenshot where that option is.

Thanks
Rufus