How to Export Biar to Live environment in BI 4.1

Note: Make sure the biar file should be same version or lower version as your live system


Copy the biar file to a folder

and create a file name.properties and include the below parameters in it


importLocation=E:/LCMBIAR_files/12345filename.lcmbiar
action=promote
LCM_CMS=servername:6400
LCM_username=Administrator
LCM_password=<your Admin Pwd>
LCM_authentication=secEnterprise
Destination_CMS=servername:6400
Destination_userName=Administrator
Destination_password=<your Admin Pwd>
Destination_authentication=secEnterprise
includeSecurity=false
exportDependencies=flase
consolelog=true

Open Command prompt and

Run the BAT file from C:\Program Files (x86)\SAP Business Objects\SAP BusinessObjects Enterprise 4.0\win64_x64\scripts\lcm_cli.bat

Command: lcm_cli.bat -lcmproperty E:/LCMBIAR_files/12345filename.lcmbiar

Publications - There are no schedulable documents in the publication

Issue:

Publication schedule shows success but recipients don't receive the files

And the log says below

PublishingService:HandlerPool-0] BusinessObjects_PublicationAdminLog_Instance_2088808 - [Publication ID # 2088808] - There are no schedulable documents in the publication. (FBE60503)
2015-03-17 05:11:32,928 WARN [PublishingService:HandlerPool-0] BusinessObjects_PublicationAdminLog_Instance_2088808 - [Publication ID # 2088808] - Unable to find any distributable documents in scope batch with ID **********

Root cause:

Whenever you made changes to any publication, the recurring instance/schedule fails becz instead of finding the CUID it looks document ID.

For every change on that report, it generates new ID.

Fix:

Reschedule the instance from scratch 

For any questions/queries, please send me a message. I will reply as soon as possible to help you out

Tips for Fine Tuning Performance of the Webi Applet Interface (Java Report Panel)

Introduction

SAP BusinessObject Web Intelligence 4.1 introduces a number of improvements over the older XI 3.1 version. One of the major changes was to the Java based designer/viewer found within the BI Launchpad application. 

For more information

http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=340427897

This content cannot be displayed in a frame on BI LaunchPad or Business Objects 4.1

This content cannot be displayed in a frame

   To help protect the security of information you enter into this 

website, the publisher of this content does not allow it to be 

displayed in a frame.

Issue: After upgrading my BI version from SP3 to SP4, all the users who are on lower version of Java (6.0.55) seeing that error above while creating new report or even when try to modify the report. (Refreshing the report - no issue)

Fix: Upgraded the Java version from lower version to 7.0.55 or more will fix this issue.

After installing the new version java disable the current java version as below

Start --> ControlPanel --> Java --> Java (Tab)--> View --> (uncheck) and restart your Browser.

Better to reboot after the above changes

Process to setup SAP Lumira Data Access Extensions

This is beginner's guide to Lumira Data Access Extensions

What are Data Access Extensions (DAE) for SAP’s Lumira?

Simply they are self-contained console applications that present Lumira data from data sources that Lumira currently cannot connect to. Though Lumira can connect to many different databases right-out-of-the-box there are other data sources out there that it currently does not natively connect to. For example you may have a proprietary in-house database, open source system, online service, plain text data or something unique that it would be useful to have Lumira connect to.

What does the DAE have to do?

As mentioned it is a console application. Unlike other types of data connectors or plug-ins they are not loaded and kept in session. They are executed each and every time they are needed. The DAE at minimum has to:

1. Return a block of data that describes the format of the data being returned.
2. Append to the data format block any information or variables that have to be persisted if needed. Remember DAE are executed every time, so variables, like a username or password would be lost between data refreshes. This block is used by Lumira to send these variables back to the DAE so user does not need to be prompted for this information again.
3. Return a block of CSV data.
4. Respect the command line parameters sent to it by Lumira such as the action required and max row count requested.

How to enable Lumira to make use of DAE:

Lumira will not make use of DAE, you will need to enable this functionality by:

1. In C:\Program Files\SAP Lumira\Desktop, open the SAPLumira.ini file.
2. Add the following entries to this file and save it:
   
   -Dhilo.externalds.folder=C:\Program Files\SAP Lumira\Desktop\daextensions
   -Dactivate.externaldatasource.ds=true
3. Create the folder "C:\Program Files\SAP Lumira\Desktop\daextensions"

The next time Lumira is opened it will search the daextensions directory for subdirectories containing DAE executables and present them to you under the item External Datasource in the New Dataset dialog.

 Parameters that Lumira sends to the DAE?

• mode : This will either be preview, refresh or edit. Preview is used when first obtaining the data, before designing visualizations. Refresh is for
  obtaining the full dataset and edit is when the user selects Edit from the Data menu.
• size : The max number of rows to return back. Typically this is used for the preview and edit. A value of 0 means to return the whole data set.
• locale : The language locale being used.
• params : A semicolon delimited line that contains name value pairs describing the format of the CSV data and any other data you wish Lumira to persist. For example:

csv_separator=,;csv_first_row_has_column_names=true;csv_trim=true;row_limit=0;csv_encoding=windows-1252;csv_date_format=yyyy-m-d;csv_number_grouping=,;csv_number_decimal=.;

Actual work flow

The first and most important workflow is adding a new dataset. This happens when the user creates a new document or adds a data set to an open document.

When the user selects to refresh from the data menu Lumira starts on step 3 in the above diagram. When the user selects Edit from the data menu the
process is the same as the above diagram except that the mode in step 1 is now edit, and the params are populated:

  Note: Process flow diagrams are not my strong suite

The DAE is only open until it is finished returning the data to Lumira, simply if your DAE does not stop executing, Lumira will wait until it deems a database time out has occurred and the connection will fail. This means that best practices would be to open your connection be it to a server or a stream, retrieve the data, output the data and close your connections and then your application.

CreatingData Access Extension For Lumira

Please follow the link below

http://scn.sap.com/community/lumira/blog/2014/09/12/creating-my-first-data-access-extension-for-lumira

Business Objects Barcode setup for webi and crystal reports

Copy custom fonts to All APS servers installed or respective servers where APS installed and also while using on Webi use * before and after the Value.

We have seen issues on Crystal and this going to fix in SAP BOBJ Business Intelligence Platform 4.1 SP03 Patch 5

1. To use locally,  add the fonts locally to Control Panel\All Control Panel Items\Fonts

2.  Go to C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\fonts

on servers where ever you installed BO go to that. If it's windows

\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\fonts

and edit fontalias.xml

In terms of the Free 3 of 9 Extended font, the FONT NAME parameter should be changed to the same value as the Title of the font file. 

  <FONT NAME="Free 3 of 9 Regular">
    <FONTFAMILY PLATFORM="ttf" NAME="Free 3 of 9">
      <FONTATTRIBUTE BOLD="false" ITALIC="false" LOGICAL="Free 3 of 9" PHYSICAL="FREE3OF9.TTF"/>
    </FONTFAMILY>
    <FONTFAMILY PLATFORM="win" NAME="Free 3 of 9"/>
    <FONTFAMILY PLATFORM="java" NAME="Free 3 of 9"/>
    <FONTFAMILY PLATFORM="html" NAME="Free 3 of 9"/>
  </FONT>


<FONT NAME="Free 3 of 9 Extended Regular">
    <FONTFAMILY PLATFORM="ttf" NAME="Free 3 of 9">
      <FONTATTRIBUTE BOLD="false" ITALIC="false" LOGICAL="Free 3 of 9" PHYSICAL="FRE3OF9X.TTF"/>
    </FONTFAMILY>
    <FONTFAMILY PLATFORM="win" NAME="Free 3 of 9"/>
    <FONTFAMILY PLATFORM="java" NAME="Free 3 of 9"/>
    <FONTFAMILY PLATFORM="html" NAME="Free 3 of 9"/>
  </FONT>