Setting Viewer preferences in BOE 4.1

[rick_kruyf3]

While the CMC does allow some of the BI Launchpad preferences to be customized, the only attributes that can be set are in the preferences, General Panel.  This does not apply to preferences for the viewer or locale.

SAP has provided some code that can be added to your BOE deployment to resolve this.

SAP NOTE 1659566 - How to Apply Preferences to All Users Accounts in BI 4.0 (works for 4.x)

Download the zip file and extract the 2 files to tomcat\webapps\AdminTools

The utility clones a specified users preferences to all members of a specific group.  It is better to use a create a temporary user and set the preferences than to clone an existing user unless you have validated all of the setting for the specific user.

Check preferences for a user.

• Logon to Admin Tools
• run the following query
  select si_id, si_name, si_data from ci_systemobjects where si_kind = 'user' and si_name in ('userid', 'userid2')

The SI_DATA property bag only exists for users where the preferences have been changed in the BI Launchpad (or preferences were migrated from 3.1 InfoView).

To show users using default preferences run the following query in AdminTools

select si_id, si_name, si_data from ci_systemobjects where si_kind = user and si_data = Null

The user viewer preference for Webi is stored in the si_data property bag in the field si_data.document_WIViewTechno, valid values are I, H, P, and J

(I = 3.1 Interactive, H = 3.1 Web or 4.1 HTML, J = Java, P = PDF).  You can query to find the users for each viewer using the following query.

select si_id, si_name, si_data from ci_systemobjects where si_kind = user and si_data_documentWIViewTechno = 'P'

The si_data.documentWIViewTechno can not used in the where clause but not in the select.  Trying to select the field while result in no field being returned, to see the values, the full property bag si_data must be returned.