cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to find [HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Settings\DataSource]

saravanan_a
Active Participant
0 Kudos

Hi Experts,

As per sap note 1656983, in order to extend cell size, we need to specify "ResultSetSizeLimit"="-1" in path

[HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Settings\DataSource]

But we are unable to find this path in windows registry. i.e., AdvancedAnalysis\Settings\DataSource is not available.

Please suggest how to achieve this.

FYI. we are using AA version 1.2

Thanks,

Saravanan.

Accepted Solutions (0)

Answers (4)

Answers (4)

0 Kudos

Hi,

As a retail customer I totally understand the need for more than 500K cells. We are currently running with a BW setting of 4.1 M cells.

Running Windows 7 64Bit we created the registry settings in the Wow6432Node folder

[HKEY_LOCAL_MACHINE\Software\Wow6432Node\SAP\AdvancedAnalysis\Settings\DataSource]

"ShowBicsSample"="True"

"ResultSetSizeLimit"="-1"

Hope this helps.

John B

kelly_stone1
Participant
0 Kudos

Hello Saravanan - have you figured this out.  I am having issues with this as well.  I have added said registry entry and this has not changed a thing.  Any help would be appreciated.  I am on 1.4.2.

kelly_stone1
Participant
0 Kudos

Yes - I am answering my own question.  Because it may help others.  When it is set to "-1" it uses the values defined in BW system which is 500,000 by default.  Use a higher number instead of "-1".

The parameter on BW is set in the RSADMIN table for object BICS_DA_RESULT_SET_LIMIT_MAX

shawn_mcdowell1
Explorer
0 Kudos

Kelly,

It is always helpful for others when you "answer your own question" and then post it for everyone else to learn, thanks! 

I'm glad you found the setting, but I would caution setting the limit about 500k.  Yes, I know Excel can do 1M records in later versions, but do you REALLY want the users to pull back a phone book worth of data? I know we are often pressured into this scenario, but you may want to investigate adding some variables to the query or inquire more about the business process to see if there are better ways to accomplish the business goals.

Good luck!

-S

kelly_stone1
Participant
0 Kudos

Shawn - I 100% agree...and yes the pressure is there.  Thanks.

Regards,

Kelly

shawn_mcdowell1
Explorer
0 Kudos

One more option you might try is an Open Hub.  Still an "export" but you might be able to dictate the timing of the when the file is populated rather than a user hitting the system for 1M+ records ad hoc.  Good luck 😃

Former Member
0 Kudos

For your reference, here a screenshot from a (working) manually created setting:

Former Member
0 Kudos
Hello,
you can go ahead and create the registry settings manually. Quote from the users guide:

"The settings and the correct path in the registry are described in the list of available settings. If a

setting is not yet in the registry editor, you can create the missing keys manually."

BR
Victor