cannot see the Appsets

[raghu_ram]

Hi All,

Upgraded from BPC 7 SP 4 to BPC 7.0 SP6 but the SP6 is not working well.

Uninstalled BPC 7 SP6 and then re-installed SAP BPC 7 SP4. Got ApShell up and

running. But, the other appsets are not accessible. In the new

AppServer db I even populated table tblAppSetInfo with the missing

appsets. However, they are not showing up in the drop down in the

connection wizard.

Please advice.

Raghu.

[Former Member]

Also, you may need to add the appset to the tblAppSetInfo db...

[raghu_ram]

thanks,

Raghu.

[i045436]

Hi,

This because your user has no access to those appsets. You have to add your user, appset name and rights 7 into tblAppSetAccess (you can copy the line from apshell and change the appset name). Then you enter into your appset and process security in order to have all user access.

Normally, when you uninstall an dinstall back other BPC version, you have to save AppServer in order to recover the sppset/user information.

Hope this can help you,

Mihaela

[PatrickFavre]

Hi,

Mihaeal is right, and after having assigned the access to your user and your appset, you'll have to re-run a connexion wizard, in order to enable your application set in the drop-down list.

Best Regards,

Patrick

[raghu_ram]

Hi,

Could you clarify me what is right 7.

regards,

Raghu.

[i045436]

7 is sysadmin,

[PatrickFavre]

Hi again,

If you open "tblAppSetAccess" table in AppServer database, you'll understand.

Value "7" is the default value in UserType column (sysadmin.

But this could also be done from the Admin UI, where you can setup security for a particular user on particular application in an application set. After assigning those rights and running the connection wizard again, you'll see your application set in the drop down list.

Hope this helps.

Best Regards,

Patrick