Archive for category Business Objects
SSO for Business Objects (BOBJ) in FireFox
Posted by allenkwc in Business Objects on May 14, 2014
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
Crystal Reports for Visual Studio 2010 Production Release Now Available
Posted by allenkwc in .net, Business Objects on March 15, 2011
Xcelsius Connect to SAP BW through SAP Web Service
Posted by allenkwc in Business Objects on June 4, 2010
Reference following document to connect to SAP BW Web Service
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>
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.
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 |
Xcelsius Error #2170
Posted by allenkwc in Business Objects on June 1, 2010
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.
Business Objects Problem
Posted by allenkwc in Business Objects on June 12, 2009
- 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)
Business Objects XI R2 Automated Backup Script
Posted by allenkwc in Business Objects on May 15, 2009
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.