Posts

Showing posts with the label SAP Business Objects BI 4

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo

Desktop Compatibility Pack (DCP) with SAP BI Platform 4.1 SP1

Image
Desktop Compatibility Pack (DCP)  The “Desktop Intelligence Compatibility Pack” has been delivered in Fix Pack (FP) 6.1 which is to be installed over Desktop Intelligence XI 3.1 SP6 desktop product.  When installed, it  allows the Desktop Intelligence reports, users, universes and database connections to be managed by the BI 4.1 platform.  The goal is to allow Desktop Intelligence users and content to move to BI 4 as easily as possible. The Desktop Intelligence Compatibility Pack helps in scenarios with reports are difficult or costly to convert to Web Intelligence. Don't bet on "DCP" to keep your Deski documents alive, this feature is only there to facilitate your migration project and nothing more. We must not forget that a migration project is often associated with a project to convert your Deski (.REP) documents to Webi (WID). The  steps to follow for installing are the following: 1.       Install SBOP Enterprise Clients 3.1 Service Pack 6

HTTP Status 500 - BI Launchpad URL after moving BI 4 server under Windows Domain

After moving the server under Win Domain both cmc and bi launchpad url erased the following error: Environment  SAP BI 4.0 SP 8 Microsoft Windows Server 2008 R2 HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception java.lang.NullPointerException         com.businessobjects.servletbridge.customconfig.Config. (Config.java:37)         com.businessobjects.servletbridge.customconfig.ConfigReader.getConfig(ConfigReader.java:274)         com.businessobjects.pinger.TimeoutManagerFilter.getSessionState(TimeoutManagerFilter.java:201)         com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:82) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs. The problem was caused by the user wich started SIA wich was Windows Domain user that was administrator of the machine, we hav

SAP BI 4 - Scheduling reports error - source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]

 Scheduling reports error -  source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]  Environment SAP BI 4 SP8  The BI 4 server is not in windows domain  but SIA service is runned by a domain user As suggested in other B.O. forum we perfomed the following steps: in CMC,  the Job Server  must use a NETWORK SERVICE user that has all the permissions to read/write, that run's as a service, log on as service account etc. ( admin user) ; user has full read/write access to the folders.  we are following  the UNC naming conventions while specifying the folder name including the sub-directories. So when we scheduled reports in order to create acrobat files on a network folder such as \\ServerName\Path  directories. the scheduled istance Fails  and raises the error source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]  Solution: In our case we decide to move the server in the Windows Domain and this solved the p

Query Builder:queries for extract reports refreshed after o before a specific date

Query Builder:queries for extract reports refreshed after o before a specific date which could be useful to extract Webi reports in a specific folder with their name , owner, cuid, update date that have been refreshed since a date select si_name, SI_NAME, SI_OWNER,  SI_CUID, SI_PARENT_FOLDER_CUID, SI_UPDATE_TS FROM CI_INFOOBJECTS where SI_KIND='WEBI' and  SI_NAME NOT like '%Nuovo documento Web Intelligence%' and SI_INSTANCE='false' and SI_UPDATE_TS > '2013.01.01.00.00.00' and SI_PARENT_FOLDER = 851970 order by SI_UPDATE_TS asc Removing   SI_KIND='WEBI' you can extract also other document kind select si_name, SI_NAME, SI_OWNER,  SI_CUID, SI_PARENT_FOLDER_CUID, SI_UPDATE_TS FROM CI_INFOOBJECTS where  and SI_INSTANCE='false' and SI_UPDATE_TS > '2013.01.01.00.00.00' and SI_PARENT_FOLDER = 851970 order by SI_UPDATE_TS asc You can also exclude Administrator as owner  select si_

CMC BI 4.0 -Visual Difference

Image
Visual Difference SAP BusinessObjects  Business Intelligence 4.0  - Version 4.0 SP2 Fixpack 5 Features - Visual Difference framework allows easy identification of changes - Comparison plug ins and viewers for each BI content type. (Eventually…) - LCMBIAR viewer answers: “How is this version of the BI application different from a previous version?” - Future service packs will provide comparison viewers for universes and other content types - For example, will answer: “What is different between these two versions of a universe? Can I easily merge changes?” - Impact Analysis - Understanding which objects in a universe have changed allows tester to focus only on reports which use changed objects. See Also Visual Difference Overview

Lifecycle management console features: Overrides - Visual Difference Overview

Lifecycle management console features SAP BusinessObjects  Business Intelligence 4.0  - Version 4.0 SP2 Fixpack 5 Lifecycle management console is now included in SAP BusinessObjects Business Intelligence servers install package. New Visual Difference capabilities allow easy identification of changes. Scriptable promotions supported via a command line interface. • Central Management Console– Visual Difference, Promotion and Version Mgmt. Lifecycle management is now in CMC: New Objects supported Categories based promotion is now supported. Server group promotion is supported however the servers are not promoted. LCM is now localized. • Job is copied • Job is migrated Update Source system of job when Overrides no longer job specific  Supports new improved BI platform Audit infrastructure There are 2 new features specifically for integrated deployments with BW: • SAP Authentication is now supported. • Integration with the SAP standar

BI 4 - LCMBIAR Overview - LCM Command Line Tool

LCMBIAR Overview - LCM Command Line Tool SAP BusinessObjects  Business Intelligence 4.0 Version 4.0 SP2 Fixpack 5 Allows to: Promote content between Development, Test, and Production SAP BusinessObjects BI 4.0 environments. Allows you to use scripting to automate the import of objects. Terms BIAR and LCMBIAR:   BIAR :(BI Archive) is a collection of any binaries associated with a BI object and its associated metadata, all materialized in a zip file. An LCMBIAR file is the same idea, but each object is stored in an individual BIAR. Considerations:  Lifecycle management tool is to promote objects from BI platform 4.x to BI platform 4.X version only.  Upgrades from a previous BO version to BI 4.0 must be done using the Upgrade management tool. To rollback a job you need to use the UI, not command line  LCM Command Line tool is not used when CTS+ is available. What can you do with LCM Cmd line tool?  Report developer creates LCM Job with cont

BI 4.0 - How to import or export a LifeCycle Manager BIAR file using command line utility

SAP NOTE 1634962 - BI4 - How to import or export a LifeCycle Manager BIAR file using command line utility If you need to export or import a Life Cycle Manager (LCM) BIAR in BI 4 using command line utility. Environment l SAP BusinessObjects Business Intelligence Platform (BI) 4.0 l SAP BusinessObjects Business Intelligence Platform (BI) 4.1 Follow these steps: 1. Create a Properties file: Start by creating a properties file (Example c:\lcm1.properties) as below. Note that the names of properties and lcmbiar files are not specific and can be anything. While the below examples are provided with Windows syntax, they are applicable to unix environments as well with minor changes to file path locations. Here is an example of a properties file to EXPORT to an lcmbiar file: exportLocation=C:/lcm1.lcmbiar action=export LCM_CMS=localhost:6400 LCM_userName=Administrator LCM_password=password LCM_authentication=secEnterprise Source_CMS=localhost:6400

Information design Tool - How to refresh the structure of a universe

Image
In order to refresh the structure of the universe in the Information design Tool Open the Data Foundation  Click on detect button and select Refresh Structure as you can see in the following image See also Publishing Universe with IDT

BI 4 Error - Index is not ready. Please try again later (PSS 01004)

Index is not ready. Please try again later (PSS 01004) Environment BI 4.0 SP 8 When we tried to find a document name in the search field the error above has been raised. Resolution Go to CMC->Application-> Right Click 'Platform Search Application'->Properties Go down in the page and select the option "Rebuild Index" , save and close. Let the index rebuild  and Restart the SIA Check also the SAP NOTE http://service.sap.com/sap/support/notes/1634413 See also BI 4.0 errors list

BI 4 Error - QTJ 00519 Refecence @select could not be resolved

After migrating an Universe from XI R3.1 SP 4 to BI 4 SP 8 and converting it in UNX format for a filter object the following error was erased  Riferimenti non risolti:  : @Select(OGGETTI SPECIALI\Cod Anno) it missed the root folder of the object Riferimenti non risolti:  :  @Select( ORDERS \OGGETTI SPECIALI\Cod Anno) so the solution was to replace the first string with the second! See also Sap BI 4.0 errors list

Information Design Tool - How to create a Native filter

Image
How to create a object filter in Information Design Tool Go in th Business Layer an click on insert object button selecting filter object Assign it a name flag the check 'Native' filter select it as Active object and select the where condition in SQL Assistant (check the prompt syntax on the bottom of image behind) Properties See also Bublish unx universe from IDT

BusinessObjects Environment Cleanup activity using Query builder

BusinessObjects Environment assessment using Query builder This includes identifying unused BI content (Users, Universes, reports,etc.). We are going to see more in detail about identification of unused objects using Query Builder in this document.   Let us see how to identify unused objects in each category listed below     1. User Community          a. Users not logged in for the past 6 months             SELECT TOP 1000 SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS            WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER'           AND SI_LASTLOGONTIME < '2013.06.30' ORDER BY SI_NAME          b. Users who never logged in to system              SELECT TOP 1000 SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS            WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER'             AND SI_LASTLOGONTIME IS NULL ORDER BY SI_NAME          c. Users not in any gr

SAP Business Objects Query Builder

Business Objects Query Builder Among Business Objects tools there is an application named Query Builder which can be used to query the Business Objects Meta Data repository in order to collect more information and details about your  Business Objects reporting system. Its url is: http://BOserver:port/AdminTools/ How to create a query Queries are created in a language SQL like. Unlike Sql language there are not a lot of functions supported (like nesting SQL statements, the GROUP BY clause or the DISTINCT function). Below the possible functions in Query Builder within the different clauses of a query are described: (SELECT, FROM, WHERE, ORDER BY). Some examples behind: A list of the Id and Name of all universes SELECT SI _ID, SI _NAME FROM CI _APPOBJECTS WHERE SI _KIND = 'UNIVERSE' Total num ber of Web Intelligence Reports SELECT COUNT(SI _ID) FROM CI _I NFOOBJECTS WHERE SI _KIND = 'WEBI ' A list of 10 0  Crystal Reports with all properties SELE

BI 4 - IDT error: ambiguous object path - Checking integrity from Information Design Tool shows an error parsing expression: ambiguous object path

On converting a unv universe in unx format in Indormation Design Tool with a generic error after tracing IDT we found the following error and solution: Checking integrity from Information Design Tool shows an error parsing expression: ambiguous object path Environment:  BI.4 - Information Design Tool - SP 5 on Windows Server 2008 R2 Cases: When a dimension and a filter has the same name in Information Design Tool, the Check Integrity returns an Ambiguous Object Path error. Or After converting the universe from UNV to UNX the check integrity gives Ambiguous Object path error. The issue is resolved on Support Package 5 with Patch 1 or Support Package 6. See Also: http://businessobjectsbi4.blogspot.it/2013/09/sap-bi-40-errors-list.html

How to publish an Unx from Information Design Tool (SAP BI 4.0)

Image
How to publish an Unx from Information Design Tool (SAP BI 4.0) In order to publish an UNX Universe  go to  Local Project  Select the .blx you want to publish  (right click)   do the check integrity  first  then select Publish in the repository as you can see in the following image: Read also Universe on Sap Hana

BI 4 Solution to: cannot see connections in Report Conversion Tool

Image
Cannot see connections in Report Conversion Tool Environment SAP BI 4 SP 5 In order to solve this problem I inserted the BO server name and its IP  in Hosts file under: C:\Windows\System32\drivers\etc Read also: BI 4 - How to download webi rich client Webi XI 4 - Changing query data source Sap BI 4 Webi-connecting to Bex query SAP BI 4.1 Supports SAP BusinessObjects Desktop Intelligence 3.1 SP6 FP 6.1 in viewing mode Disable automerge dimension on WebI X 4.0

How to download Webi Rich client in SAP BI 4.0

Image
How to download Webi Rich client in SAP BI 4.0  The Web Intelligence Rich Client can be installed from the BI Launchpad: In  BI Launchpad s elect Preferences  Select Web Intelligence.  Click on the (installation required) hyperlink next to Desktop or Desktop (Windows only).

SAP BI 4 - Error: Server not found or server may be down (FWM 01003) null

Error: Server not found or server may be down (FWM 01003) null Environment SAP BI 4.0 SP 5 First of all you can check if  your CMS is up an running from CMC. If the SIA is running, but not the CMS this usually means there is a problem with the connection to the CMS database. Reconfigure DSN for a normal connection, with username/password and retest. Read also related  SAP Notes:  1387464 - Error while logging to Central Management Console or Infoview "Error: Server domain:6410 not found or server may be down (FWM 01003) null" https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3133383734363426  1338496 - Error: Server xxx:6400 not found or server may be down (FWM 01003) null while login to Infoview or Central Management Console https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F