Archive for category Business Objects

SSO for Business Objects (BOBJ) in FireFox

Copied from: http://scn.sap.com/thread/3456167

Here are the notes we have for configuring Firefox and Chrome config for SSO with Kerberos

 

A. To configure Mozilla Firefox (Version 15 and above only) for SSO:
1. Open Mozilla Firefox
2. In the URL field type in “about:config” and hit the enter key
3. Accept the warning
4. It will open the configuration console of Firefox
5. In the search bar type in “network.negotiate-auth.delegation-uris”
6. Double click and it will open one window
7. Type “http://hostname ” here which should be the FQDN of the server you want to access via SSO.(you can do multiple entries separated by a comma)
Example: http://sapqbw.insummit.com,http://sapportal.insummit.com,http://sapdbw.insummit.com,http://sapcrmd.insummit.com
8. Click OK
9. Now in the search bar type “network.negotiate-auth.trusted-uris”
10. Double click
11. Type “http://hostname ” here which should be the FQDN of the server you want to access via SSO.(you can do multiple entries separated by a comma)
12. Click OK
13. Restart the Firefox
14. Open your website
15. SSO should be working now

B. To configure Google Chrome for SSO:
1. run regedit and navigate   to HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Google\Chrome on a workstation that has Google Chrome installed, if it isn’t there you need to create the key
2. add the string value AuthNegotiateDelegateWhitelist
3. Enter the value either http://*insummit.com (to allow all hosts in your domain, or the FQDN and hostname of each URL separated by a semicolon
4. i.e. your webapps URLs are http://dev-bi.insummit.com and http://bi.insummit.com add the following http://*dev-bi.insummit.com; http://*bi.insummit.com
5. If you have multiple or many Chrome clients please consult your AD admin to see if he can deploy this setting via group policy to save on all the manual registry edits

 

 

No Comments

Crystal Reports for Visual Studio 2010 Production Release Now Available

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/22083

No Comments

Xcelsius Connect to SAP BW through SAP Web Service

Reference following document to connect to SAP BW Web Service

Web Services within BI Part 1

How to integrate Xcelsius 2008 with SAP NetWeaver BI without Integration Kit

Using Filter

Following is the step to pass filter parameter / values to the query:
GetQueryViewData    <- function
Parameter:    <- type: W3Query
NAME = FILTER_IOBJNM
VALUE = <Filter Name, e.g. Z3COMPANY>

NAME = FILTER_VALUE
VALUE = <Filter Value, e.g. ERHK>

ScreenHunter_04 Jun. 04 18.25

Please note that in order to pass the filter value to the query, following have to be done,

GetQueryViewData <- function

Parameter: <- type: W3Query

NAME = FILTER_IOBJNM
VALUE = <Filter Name, e.g. Z3COMPANY>

NAME = FILTER_VALUE
VALUE = <Filter Value, e.g. ERHK>

*Note: if you have more than 1 variable have to pass to web services, append the under stroke and sequence no. behind, such as,

NAME = FILTER_IOBJNM_1
VALUE = <Filter Name, e.g. Z3COMPANY>

NAME = FILTER_VALUE_1
VALUE = <Filter Value, e.g. ERHK>

*Tricky Tips: When making a filter for month, set it as “Free Characteristics” rather than “filter”, otherwise, it can’t be passed successfully to the web services.

ScreenHunter_01 Jun. 07 18.10

ScreenHunter_02 Jun. 07 18.10

Structure

Parameter

Description

FILTER_IOBJNM

FILTER_IOBJNM_N (optional)

Name of the characteristic / structure by which the system is to filter

Specify the technical name of the characteristic (for example, 0COUNTRY) or the structure (25 characters)

FILTER_COLLAPSE (optional)

‘X’ = Yes, ‘ ’ = No

Removing filter characteristics from the drilldown

The characteristics that are specified under FILTER_IOBJNM are taken from the axes after the filter has been applied. If you do not specify the parameters, the system assumes you want to use the value ‘X’ = Yes.

FILTER _SIGN_N (optional)

Row properties

‘I’ found values are added,

‘E’ found values are removed.


If the parameter is not specified, then the system assumes you want to use the value ‘I’.

If FILTER_IOBJNM_N is not specified for index n, the value from FILTER_IOBJNM is used, if available.

For filtering individual values, the following parameters are also specified:

Parameter

Description

FILTER_VALUE

FILTER_VALUE_N

FILTER_VALUE_EXT

FILTER_VALUE_EXT_N

Filter Value

Value, by which the system is to filter.

If the variant with ending ‘EXT’ is selected, the fully compounded value has to be entered in the external format, for example, 24.12.2000.

If the ending ‘EXT’ is not used, the fully compounded value has to be entered in the internal format, for example, 20001224 for 24.12.2000.

FILTER_VALUE_TYPE (optional)

FILTER_VALUE_TYPE_N (optional)

Type of value specified under FILTER_VALUE

‘VALUE’ : Characteristic value key

‘VARIABLE_EXIT’ : Exit variable name. The filter is set using the values returned by the variable exit. Parameter, interval, and selection option variables are allowed for customer and SAP exit variables, as well as for default values.

FILTER_OPERATOR (optional)

FILTER_OPERATOR_N (optional)

An operator

‘EQ’ = Individual value

‘LT’ = Less than

‘LE’ = Less than or equal to

‘GT’ = Greater than

‘GE’ = Greater than or equal to

If no operator is specified, then the system assumes you want to use the value ‘EQ’.

The following parameters are also accepted for filtering intervals:

Parameter

Description

FILTER_VALUE_LOW

FILTER_VALUE_LOW_N

FILTER_VALUE_LOW_EXT

FILTER_VALUE_LOW_EXT_N

Filter value – lower limit (not compounded)

FILTER_VALUE_HIGH

FILTER_VALUE_HIGH_N

FILTER_VALUE_HIGH_EXT

FILTER_VALUE_HIGH_EXT_N

Filter value – upper limit (not compounded)

Example

Ref: http://help.sap.com/saphelp_sm32/helpdata/en/59/edfe395dd76846e10000000a114084/content.htm

Filter Data Provider ’View1’ by Country: Germany

<SAP_BW_URL DATA_PROVIDER=’View1′ FILTER_IOBJNM=’0COUNTRY’ FILTER_VALUE=’DE’>

Filter Data Provider ’View1’ by First 3 Months

<SAP_BW_URL DATA_PROVIDER=’View1′ FILTER_IOBJNM=’0CALMONTH’ FILTER_VALUE_LOW_EXT=’1′ FILTER_VALUE_HIGH_EXT=’3′>

Filter All Data Providers by Costs and Countries: Germany and USA

<SAP_BW_URL DATA_PROVIDER=’*’ MULTI=’X’ FILTER_IOBJNM_1=’DRB9ZVVMBCHVX4F04Z1JGKYVC’ FILTER_VALUE_1=’DTG057U7OQ8K2ALKCMR2AWM14′ FILTER_IOBJNM_2=’0COUNTRY’ FILTER_VALUE_2=’DE’ FILTER_IOBJNM_3=’0COUNTRY’ FILTER_VALUE_3=’US’>

Filter All Data Providers by Current Month

<SAP_BW_URL DATA_PROVIDER=’*’ MULTI=’X’ FILTER_IOBJNM=’0CALMONTH’ FILTER_VALUE=’0CMONTH’ FILTER_VALUE_TYPE=’VARIABLE_EXIT’>

Changing Variable

Ref: http://help.sap.com/saphelp_crm60/helpdata/ja/47/a8bcfa73b12fe2e10000000a42189d/content.htm

Characteristic Value Variables

Characteristic Value Variables: Parameter Variables or Variables for Multiple Single Values

Parameter

Description

VAR_NAME_x

Technical name of the variable

VAR_VALUE_EXT_x

Characteristic values in external format

Key for characteristic value in external display

Characteristic Value Variables: Interval Variables

Parameter

Description

VAR_NAME_x

Technical name of the variable

VAR_VALUE_LOW_EXT_x

“From” characteristic value in external display

Key for characteristic value in external display

VAR_VALUE_HIGH_EXT_x

“To” characteristic value in external display

Key for characteristic value in external display

No Comments

Xcelsius Error #2170

Here is what you need to do
–>Export your visualization to swf
–>Run the Swf, right click on visualization and got to settings.

OR
Click
http://www.macromedia.com/support/documentation/en/flashplayer/help/settings_manager04.html

In 3rd Tab (Global Security Settings)
–> Check box “Always Allow”
–> In the Drop down (Edit location… select Add Location
–>Browse the swf file

That is it…now reopen the .swf file, it should not throw error.

No Comments

Business Objects Problem

  • WebBi cannot export external images (image not in BOE folder, get from a php / servlet)
  • WebBi can place different things, tables into one report. While Crystal Report 2008 doesn’t
  • Crystal Report can export external images
  • Crystal Report cannot connect to Universe to a OLAP cube (e.g. BW Cube / Query)

,

No Comments

Business Objects XI R2 Automated Backup Script

I wrote this quick little script to automatically take a backup of a BOXI R2 system.

It assumes a very simplistic, (development), environment where all BOXI services and a MS SQL 2000 database are all running on the same server.

If this is not the case things get a bit trickier. I will post a more advanced sample someday.


REM Ryan Fitzgerald - 2007-07-12
REM BOXI R2 System Backup Script
REM This script will backup the entire BOXI R2 system so that it may be restored at a later date
REM this may be used to rollback a failed release or in the event of a disaster as a recovery mechanism.

STOPPING SERVICES – must do this first so there is no activity on the CMS during the backup.

net stop “Central Management Server”
net stop “Input File Repository Server”
net stop “Output File Repository Server”

Set a date variable to create a new folder for the backup (this makes it easy to schedule weekly or whenever).

rem SETTING DATE VARIABLE
set dateString=%date:~10,4%%date:~4,2%%date:~7,2%
mkdir c:\BOXIR2Backups\%dateString%\

The /E specifies trusted login, you will probably want to replaces this with a /U and /P for username and password pair.

osql /E /Q “begin declare @CMSBackupFile varchar(255) set @CMSBackupFile = ‘C:\BOXIR2Backups\’ + CONVERT(VARCHAR(20),GETDATE(),112) + ‘\CMS’ + CONVERT(VARCHAR(20),GETDATE(),112) + ‘.bak’ backup database {CMS_DATABASE_NAME_HERE} to disk = @CMSBackupFile end”

The next OSQL command does the Audit database, this is not required but good to backup if you are using it.

osql /E /Q “begin declare @AuditBackupFile varchar(255) set @AuditBackupFile = ‘C:\BOXIR2Backups\’ + CONVERT(VARCHAR(20),GETDATE(),112) + ‘\Audit’ + CONVERT(VARCHAR(20),GETDATE(),112) + ‘.bak’ backup database {AUDIT_DATABASE_NAME_HERE} to disk = @AuditBackupFile end”

Copy the filestores, folders which hold all .rpt files and others, to the backup folder; your filestore may be located somewhere else. Check the Input/Output Filestore Server settings in CCM or CMC to see where your filestores are.

xcopy “C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\FileStore\” c:\BOXIR2Backups\%dateString%\

Start the services back up:

net start “Central Management Server”
net start “Input File Repository Server”
net start “Output File Repository Server”

And you’re done, congrats.

No Comments