action = exportXML
exportBiarLocation = recurring.biar
userName = Administrator
authentication = secEnterprise
CMS = localhost
exportDependencies = false
includeSecurity = false
exportQueriesTotal = 1
exportQuery1 = select * from CI_INFOOBJECTS where SI_RECURRING=1
SET BO=C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0
"%BO%\win32_x86\jre8\bin\java.exe" -jar "%BO%\java\lib\biarengine.jar" recurring.txt
Sometimes you are not allowed to transfer files between machines but you can transfer text via clipboard. A little hack how to transfer a file using a standard Windows utility certutil.
Create a text file encoding the file
certutil -encode file.exe file.txt
Open and copy text
Create a new file on the remote desktop and paste the text
Decode the file into exe
certutil -decode file.txt file.exe
Sometimes a connection cannot be promoted by Promotion Management with the error:
Resolution Status=Copied, Dependency Status=All the required dependencies are included., Commit Status=Commit attempted and failed., Promotion Status=Failure : Relationship would not be a tree after update so bailing.
It may help to promote connection using BiarEngine. This can display a better message explicitly saying object's ID causing the dependency issue, for instance:
%WINDIR%\System32\odbcconf.exe CONFIGSYSDSN "SQL Server" "DSN=macoprod|Description=macoprod|SERVER=10.2.151.18|Trusted_Connection=No|Database=macoprod"
%WINDIR%\SysWOW64\odbcconf.exe CONFIGSYSDSN "SQL Server" "DSN=macoprod|Description=macoprod|SERVER=10.2.151.18|Trusted_Connection=No|Database=macoprod"
To prevent accidental start of a batch file (e.g. restarting services or a starting load), you can add the following lines in the beginning.
- Use Y as a first argument when scheduling the file
- You will be prompted to answer whether you want to continue, if you start the batch.
if /I "%1"=="Y" goto start
set /p continue="Continue (Y/N): "
if /I "%continue%"=="Y" goto start
rem ... your script ...
A query is based on eFashion universe and returns two objects: measure [Promotion Cost USD] and dimension [Duration].
The variable [Cost] is defined as
=If [Duration]>0 Then [Promotion Cost USD]/[Duration]
The following formula in report’s cell returns #MULTIVALUE
If I just replace the variable with the expression, it will return correct value
=Sum(If [Duration]>0 Then [Promotion Cost USD]/[Duration])
The following formula also returns correct value
CREATE VIEW C_FINANCEENTRYPV WITH SCHEMABINDING AS
CREATE UNIQUE CLUSTERED INDEX C_FINANCEENTRYPV_01 ON C_FINANCEENTRYPV (
SELECT * FROM C_FINANCEENTRYPV WITH (NOEXPAND)
This post describes the steps to repair CMS database and Filestore using SAP BusinessObjects reposcan.exe.
Note that this may delete some items from CMS or Filestore if the dependencies are not found. Make sure that you have made necessary backups before applying reposcan.
You can run the tool without repairing option (or with -repair off). This will scan the environment and make the report of inconsistencies which will be saved to the output folder.
1. Create folder C:\Reposcan
2. Create file reposcan.ini in the folder
-inputfrsdir "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\FileStore\Input"
-outputfrsdir "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\FileStore\Output"
For Oracle, the first two line should be:
For SQL Server:
The value for dbkey can be found in Central Configuration Manager under CMS Cluster Key Configuration:
Here you can also see DNS under CMS System Database Configuration.
3. Create file reposcan.bat
"C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\reposcan.exe" -optionsfile "C:\Reposcan\reposcan.ini"
4. Run the file reposcan.bat
You can get the list of all commands running the reposcan without options:
"C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\reposcan.exe"
Server Manager > Manage > Server Manager Properties > Do not start Server Manager automatically at logon