1 2 3 16 Previous Next

BusinessObjects BI for SAP

228 Posts

This 'blog post was originally written as an introduction to the session run at TechEd, Vegas which was re-run as an ASUG webinar on November 3rd, 2015.

I was asked to write a short 'blog post introducing the customer story session to give people an idea of whether it was relevant or of interest (hopefully both).


Short version: The session deals with the many challenges of implementing a global BI4 instance for BW (and preparing for HANA) in a complex integrated global environment.


The presentation starts with a story that involves beer and pizza in a server room. If that isn't enough reason alone to attend then I will outline the topics I plan to talk about and discuss with people in the room.


The central theme of the presentation is the "IT reality" when trying to rollout global buzzwords. Even when the hype coalesces into a mature product the challenge of implementing it and integrating it a global enterprise is fraught with complexity and challenges.


Management hears "Cloud". I see "legal", "data sovereignty" and "integration".


When I attend any conference I pay attention to all the new buzzwords and associated hype but file them away for future use because my reality is trying to deliver last year's buzzwords or, in the case of "self-service" and "cloud BI" or even "BusinessObjects BI for SAP BW" I am actually still attempting to deliver buzzwords from several years ago.


I am not alone in this. I have been presenting at TechEd, Sapphire and Gartner events for the last four or five years and find my presentations consistently well received by peer customers and partner organisations facing the same or similar challenges.


For the last five years our organisation has been implementing a single global instance of SAP ERP with an accompanying global BI reporting solution (deploying BusinessObjects BI4 against SAP BW 7.3).


The solution was built "in the cloud" but this did not involve little fluffy things featuring unicorns and rainbows. Deploying in the cloud was tough. This is what deploying in the cloud looked like to me:


The above diagram is just of the BI platform but that was only part of the story. The integration of the BI platform (SAP BI4) with SAP BW (as both reporting source and 3rd party authentication entitlement system) was a challenge in itself but we also had to integrate with NW Portal (for presentation) and with SAP Solution Manager (for CTS+ and monitoring) and with Identity Access Management. Each of those integrations has pains and challenges beyond anything I could have imagined (and I have quite a good imagination).


There is plenty of advice out there about selecting the right products from the BI suite to meet your use case, unfortunately not may of them take "reality" into account. So I cover that as well. For example, two years ago the "right" product "on paper" for our requirement was Design Studio but "in reality" for our requirements, it was not ready. So what did we do in the interim? I'll talk about that.


Need new features or fixes? Think that "upgrading to the next version" or "applying a service pack" is trouble-free? Nope. I'll cover that too.


I actually expected the session to then cover integration with Solution Manager at length but a new "reality on the ground" emerged, the migration of BW on Oracle to BW on HANA. I'll have quite a lot to say on that subject especially around managing BW growth prior to migration. What I will be getting really worked up about though is the way we are having to overthink the HANA architecture to find a compromise between delivering value and high license costs.


You will be pleased to know that, once I have got all that off my chest I will actually be talking about the value we delivered from our reporting capabilities.


The topic I end with is the one I normally get most worked up about, the buzzword that has been the bane of my life for many years, "self-service". If you were at SAP Insider for my session there then you may already have an idea what happens to that buzzword in my presentation. If not (or if any of the above sounds like it might be useful, insightful or just plain entertaining) you will just have to come along to the session and find out.


Debate, discussions and heckling welcomed before, during and after the presentation. Hopefully see you there. For those who can't attend I will upload the session slides after the event.


Twitter: @CheOpsLaw

How to fix error when the OLAP connection gets deleted



Applies to:

SAP BI Analytic. Business Intelligence Tools | BI & Analytics | SAP




This Document describes how to fix the error which occurs when the developer accidentally deletes the connection.

Author           : Lakshminarasimhan Narasimhamurthy

Company     : Electronic Government Authority, Ras Al Khaimah

Created on  : 04/SEP/2015



Author Bio

Lakshminarasimhan Narasimhamurthy is BW certified and ABAP certified consultant and worked on multiple implementation, development and support project's within India and outside of India in SAP  BW, BI and ABAP. He has worked for fortune 500 clients like Nestle, Warner Bros, General Electric. He is strong in HANA modeling and strong in BO/BI tools like WEBI, Dashboard, IDT, Lumira.



Scenario –

We have a report created over an OLAP connection and by mistake another developer has deleted this OLAP connection. This document gives solution to handle such case.



Step by step approach –

We have an OLAP connection inside the folder “Lakshminarasimhan”.

The OLAP connection is pointing to the BEx.

This BEx query is going to be the DataSource for our WEBI.



OLAP connection can point to

  • Individual BEx query


  • Infoprovider ( All BEx  queries within the Infoprovider are available for reporting)


  • BW  server ( All BEx queries of all Infoproviders can be accessed)


I have created a simple WEBI document given below. 

The report shows the difference between the case registration date and the case judgment date which gives the time take to give the judgment.

The query is executing fine. Now another developer has deleted the OLAP  connection by mistake and the report throws the below error.


First Error, when the user tries to refresh the report –



Second error, when we go to the WEBI report in the design mode and then edit the WEBI with data and then “Data Access” ----- “Edit”





Now we try to check if the BEx  query has been deleted or the  BEx query “Allow external access” check box has been removed etc, finally we identify that the OLAP connection is missing. Now we create a new connection to the BEx query. In WEBI we have an option “Change Source” .






Select “Specify a new data source”  and then select the BEx query,all the mappings will be tested by the system. The system checks if all the characteristics and key figures used in the WEBI are existing in BEx  query with same technical name and description.




If suppose a key figure is missing in the BEx  query but being used in the WEBI report then we will have the below message for the particular key figure being highlighted with yellow tool tip


You can reinsert the missing key figure and then try the same process again. Now all of the mappings are done and successful.




The report is working fine again.


Other references --


BI Platform Analytics | Business Intelligence | SAP


Thanks to my colleague's Balu Renganathan and Gowri Shankar.

Last week I attended the excellent SAP Insider event in Nice. On the final day of the conference I delivered my own presentation "The Battle to Define and Deliver Self-service" detailing the progress made to enable self-service capabilities on a large global BI deployment that I've worked on for nearly five years.


By the end of the presentation the audience in the room were unsurprised, or even in agreement, when I stated that I'd had a "Morpheus" moment and was now taking this to it's logical conclusion, actually killing off the term self-service! Because this wasn't a slide but something I thought of as we were talking, directly after finishing I composed and posted the following (tongue-in-cheek) tweet:


Without the context of the presentation (and accompanying discussion with the audience) more than few people misinterpreted what I was saying (or missed the joke) and therefore I thought it was worth taking the time to document how I (along with what I felt was the majority of the audience) arrived at this conclusion.

The presentation originated from (and expanded on) a two year old blog-post I wrote here on SCN: The War on "Self-service". In that post I argued that "self-service" was not "a thing" but "something optionally done by a thing" i.e. that Lumira was not self-service in it's own right (and that is how it was being marketed) but a data visualization tool that could be used by IT to deliver a BI document or, optionally, delivered in such a way that end users could modify/create/share their own documents. In short, I argued, self-service is not something you deliver (because it is a capability/verb) and instead something you optionally enable in something you deliver (something tangible like a product/noun). The original post was unremarkable but attracted some very interesting comments including this fantastic response from Donald MacCormick of Antivia (and formerly Vice President for Strategy, BI Platform at SAP) which broadly supported my case.

The presentation I delivered at SAP Insider described the current landscape two years later with our implementation of self-service capability built into IT delivered BI. The major topics were:

  • The role of enterprise and solution architecture in defining and delivering BI capabilities, including self-service

  • Using solution patterns and standards to drive consistent behaviors and experiences globally

  • Technical deployment options and challenges with the BI platform (relative to enabling self-service)


I'm going to walk through just the relevant slides to explain what led to the "Morpheus" statement. At a very simple level we have been deploying a global ERP and BI deployment. replacing regional BI with BEx reporting.


One of the visions was to remove the barrier to adoption that was the creation of change requests to IT every time someone wanted even a minor change in a BI report. We wanted to enable analysts/consumers/superusers to easily modify the flexibly built reports and save personal or team variants.

Early on, because the term self-service is ambiguous, therefore open to everyone having their own opinion on what it is (a large part of the problem obviously), we defined what we intended to enable within the scope of this project so that we could share this with the people who matter most, the people who use it.

Using mostly Analysis OLAP reports we easily enabled levels 1 and 2 (while figuring out if BW Workspaces or HANA views would best support level 4)



These types of self-service enabled reports were already deployed in production, however when we played this capability back to the BI user community a senior (exec) and BI champion was asked what his expectation was from self-service. His answer wasn't quite what we expected.


Pausing on this slide for a while I confirmed the statement the exec made which was "I get fed up waiting for someone to run a report for me, self-service means access to the BI system and being able to get the report myself". I then asked if anyone in the room would have considered this to be "self-service" and most agreed with me that we would consider this simply using the report. I took this a step further and asked if "printing the report" once it had been run would be self-service, again no, simply "use" of the report.

Well, I asked, what if the user ran the report and then swapped a couple of columns around and then printed it? What if they adjusted the formatting and type of charts then saved a variant copy in the BI platform to share with other users? Isn't this all simply "using" the report? What if, un-satisfied with this particular report, a new report from the same source was created, isn't that ultimately simply "using" the product?

As most people seemed to agree that everything we had just talked about as being "self-service" was simply some of the many ways of using the system then actually it wasn't simply that self-service was not a "thing" in its own right, it wasn't a thing at all. It doesn't exist! That's when Morpheus entered the room and offered us the red pill...


Of course that isn't all there is to say (and that's a fraction of the content we covered) but hopefully it's enough for people to think twice when offered the blue pill of self-service!


This is a session I attended last week.  These are my notes and anything stated in the future is subject to change.


It was a full house in attendance:



Below are some highlights.


Figure 1: Source: SAP


Figure 1 shows themes of cross client and interoperability.  SAP said they are looking at the big picture, how share amongst solutions


Figure 2: Source: SAP


BI4.1 SP6 due in June


Users can recall values (BI Variants) is first planned for Web Intelligence


Universe on BEx is single source


Figure 3: Source: SAP


Coming post 2015 is authored universe access to ERP tables


Figure 4: Source: SAP


Two themes for Design Studio convergence strategy BEx and XCelsius use cases


The speaker said it is “Never a sexy topic when you talk performance”  regarding parallel query execution


Design Studio 1.5 will still single source universe support


Geomaps can up to 10 layers; change base layer maps at run time; alternative street maps are provided


More custom templates are provided


Figure 5: Source: SAP


New chart picker – 22 chart types available


Figure 6: Source: SAP


When exporting, it is a static data set


Figure 7: Source: SAP


Planned innovations include calculations at run time


Snapshot to analysis office is planned


What is shown in Figure 7 is planned for second half of 2015


Figure 8: Source: SAP


Future direction is typically 12-18 months out; plans include local calculations, multi-source universe support and common annotations


Figure 9: Source: SAP


Figure 9 shows planned innovations and future directions (12-18 months out) for Analysis OLAP


Figure 10: Source: SAP


Analysis Office 2.1 is planned for release soon


Figure 11: Source: SAP


I hope to have another blog to cover this better but Figure 11 covers Lumira-BW integration planned for later this year.

Question & Answer

Q: Authored universes – will it do select statements?

A: Stripped down functionality on authored universe focused on business layer



Upcoming ASUG Business Intelligence Community W... | ASUG

Don't Delay - Submit your ASUG SAP TechEd Abstract Today

World Premiere SAP Design Studio 1.5 ASUG Annual Conference - Part 1

In another edition of the Diversified Semantic Layer podcast, we were joined by David POISSON to discuss how SAP gets to use SAP BusinessObjects and SAP Analytics to run SAP (the podcast was a while ago, but the write-up is happening now).


Here is the embedded video, and below are the highlights.



00:20 Welcome back David Poisson!


02:50 Pleasantries are finally over, and it’s time to start. Apparently SAP has potentially 65,000 end users which runs on a single BI platform. The Sales organization has 5,000 people who regularly use an Explorer Sales Pipeline and several Web Intelligence reports.


05:00 HANA comes up by complete accident – apparently people love that they have zero latency in their reports.


05:45 David continues to rub it in – 4.1 has a higher degree of sustainability and so their internal platform support team plays a lot of tiddly winks.


07:00 SAP has around 40 servers on 4 different landscapes to serve up that – 10 VMs in Prod. (editors note: I must get to 4.1).


08:20 NO PHYSICAL MACHINES! 6 people manage it, and SkyNet is a far smaller threat.


09:44 More “Na-na na-na-na” from David.  Unlimited licensing. Apparently SAP folks are surprised when they get a WebI report anymore, just because of all the choices. RIGHT TOOL FOR THE JOB!


13:40 Every SAP IT person is supposed to meet with at least one customer each year. It doesn’t always work out, but a noble goal.


15:30 JUICY QUESTION ALERT – What impact does SAP IT (as a customer) have on the product direction?


17:55 SAP IT is a pretty decent utility for SAP Support – it’s a a place where they can help troubleshoot paying customers’ issues. #labmice


19:45 SAP used to have Qlikview. Sounds like nobody misses it.


22:15 Jamie gets subversive – “What can’t you deliver?”


24:40 Dashboards should explain to the end user.


27:30 Looking nice isn’t enough for a dashboard – I need great information to drive utilization.


29:00 Timo ELLIOTT is a great internal resource; others, less so.


32:20 Mobile is where it’s at.


35:25 ADVICE HOT TAKE: If you are new to BusinessObjects, start with 4.1. If you aren’t new, get there anyway.


For the original post, please visit the DSLayer website, and to subscribe to the podcast, please visit us on iTunes.

When the current installation does not contain all the necessary features, or some features of the SAP BusinessObject BI platform (4.0 or 4.1) need to be removed, there is a way to change that without having to uninstall or completly re-install a system.

From the list of installed patches and service packs select the first installation (whether BI 4.0 or BI 4.1) in the example below click on SAP BusinessObjects BI platform 4.0 (this is a bit unkward as your current patch level is SP5 of BI 4.1):


A button showing Change/Uninstall instead of Uninstall will be displayed, click on this button to launch setup:

uninstall_change button1.png

Instead of the setup for BI 4.0, this will launch the setup for the BI 4.1 SP5 (current service pack level installed from this example), you have to choose Modify, in order to go to feature selections screen:

Application maintenance.png

Feature selection screen will allow you to pick the missing features for the current service pack or patch and not the initial installation (in this example you will install features for BI 4.1 SP5 and not BI 4.0):

feature selection.png

Click on next and the new features will be deployed at the current patch or service pack level.

As probably a lot of you are aware by know, the ASUG BI community is very active and is constantly organizing great webinars for the community.


To make sure that people are not "missing out" on these great opportunities, I will post a list of upcoming webinars on a regular basis here.

For all webinars :


Start Time : 11:00 AM (CT), 12:00 PM (ET), 10:00 AM (MT), 9:00 AM (PT)

Duration : 1 hour

So here the webinars for the next 2 weeks:






  • Jan. 28: Customize SAP BusinessObjects Design Studio Dashboards for the Enterprise

    As a replacement for SAP Business Warehouse Web applications, users learn how to develop SAP BusinessObjects Design Studio dashboards with a standard look and feel. Helpful tips for using style sheets and images are presented. During this session, several dashboard design approaches for performance optimization are discussed and examples given.


  • Feb. 2: Running SAP Business Warehouse on SAP HANA on AWS Cloud - Kellogg Story

    Get insights on how Kellogg implemented SAP Business Warehouse on SAP HANA in a hybrid cloud with AWS. Learn how Kellogg worked with AWS for its initial proof of concept (POC) and deployment. Learn how a fully supported SAP BW on SAP HANA scale-out environment can be deployed in less than 30 minutes for POC and dev/test systems in a pay-as-you-go model.

I hope you enjoy these session.


Please note, that these are webinars organized by the ASUG BI group and for joining you need to be a ASUG Member.

SAP BusinessObjects Web Intelligence and Crystal Report for Enterprise now supports (from BI 4.1 SP05) manual entry of values for variables.


With this enhancements the end users now would be able to simply type in a values in the text box for manual entry instead of selecting each values from List of Values.

Note: Manual entry would be enabled on Web Intelligence and Crystal Reports for Enterprise clients only when the BEX Query variable is created with “Manual Entry/Default value” processing type in BEX Query designer

Bex Query Parameter.png

Upon updating your environment to BI 4.1 SP05, Manual entry of values would be supported on following variable types.

  • Single value variable
  • Multi single value variable
  • Interval (range) value variable
  • Single keydate variable
  • Formula variable
  • Selection Option variable


By default, selection option variables are mapped to a range. In order to use this feature, selection option variables has to be mapped to a multi-value prompt, for which you would have to run the following command depending on the client.

Note: Manual entry support will be enabled for other listed variables types by default with BI 4.1 SP05

For Webi:

  • Webi Rich Client: Run Registry Editor and Add the entry “Dsap.sl.bics.variableComplexSelectionMapping=multivalue” in the following registry key and restart the client

       registry path.png

  • Webi Java and DHTML Viewer: Launch CMC -> Servers -> WebI Adaptive Processing Server ->Properties -> in command line parameters add the entry “Dsap.sl.bics.variableComplexSelectionMapping=multivalue”


For CR:

  • CR4E: In the config file, add the entry “sap.sl.bics.variableComplexSelectionMapping=multivalue” and restart the client

        Config file is located at “[Install_Dir]\Crystal Reports for Enterprise XI 4.0\configuration\config.ini”

  • CR Viewer: Launch CMC -> Servers -> Crystal Reports Processing Server ->Properties -> Java child VM arguments add the entry  “Dsap.sl.bics.variableComplexSelectionMapping=multivalue”


With Manual entry of values you can make use of expressions and patterns to reduce the number of values to be filled and speed up the selection process depending on the requirement, following are couple of examples.

  • Single member: 1
  • Interval: 1 – 5 (do include the spaces)
  • Expressions with operators: >4 , >=4 , <4 , <=4
  • Exclusions: !5 (any key but 5)
  • Combinations: 1 – 10 ; !5 (all the keys from 1 to 10 except 5)
  • Patterns: *1 : all keys that end in 1 (for ex. 01, 11, 21) and *1* : all keys that include 1 (for ex. 01, 10, 11, 12, 13, 21)

Webi runtime.png

The support for manual entry of values does not have any impact on the existing capability to select values from List of Values, users can still continue to make use of list of values for providing values for prompts.


With this enhancement, following is the consolidated list of clients supporting manual entry of values for variables.


  • Web Intelligence
  • Crystal Report for Enterprise

    Dashboarding & Apps:

  • Design Studio

    Agile Visualization:

  • Lumira Desktop
  • Analysis, edition for Microsoft Office
  • Analysis, edition for OLAP
  • Explorer


Refer to SAP Note 1869560 for detailed SAP Integration support matrix for BI on BW.

Simon To

BI Mentors Monday

Posted by Simon To Nov 10, 2014

SAP Mentors Monday are public webcasts where we share information, experience, and success stories with the community. There are a couple sessions coming up that are presented by the SAP Mentors who are BI-focus. Greg Myers, Owen Pettiford, Jamie Oswald and I are teaming up to present different BI stories.


Please mark your calendar. The following is the tentative agenda.


Part 1:

Date/Time: Dec 15, 2014,  4:30 PM Eastern/3:30 PM Central/1:30 PM Pacific

Presenters: Greg Myers and I

Topics:  -- I will talk about Location Intelligence dashboarding.

              -- Greg will share about a monster BI 4.1 deployment with 20 servers in a cluster serving 60,000 users.



Part 2:

Date/Time: Jan 12, 2015,  4:00 PM Eastern/3:00 PM Central/1:00 PM Pacific

Presenters: Owen Pettiford

Topics: -- This session will cover Lumira Server, Fiori Business KPI and Fiori Launch Pad.


Access Information:

SAP Connect: https://sap.na.pgiconnect.com/sapmm +1-720-897-6637,, Participant Passcode: 170 133 7730#


Owen Pettiford bio from SCN: I am an experienced consultant who has been working with SAP and non-SAP systems since 1991. This experience enables me to help client understand how to extend SAP in ways that are approved by SAP.My vision is to deliver SAP to anyone, anywhere, on anything.Since 2005 I have worked with clients to create architectures and designs based on Service Oriented design principles. I have completed many (30+) Enterprise SAP Roadmaps for clients across 12 industry sector which has given me a wide knowledge of common patterns and problems.I now head CompriseIT with Dean Wood and since 2008 we have been building apps on top of SAP for many clients and keeping up to date with what is coming next - and helping clients to understand this and incorporate into their landscapes.I am and SAP Mentor and have a degree in Computer Science.Specialties: SAP Enterprise SOA, SAP Business Suite, xApps, Composite Applications, Service Oriented Architecture, Integration, Business Process Management, Mobility, HANA, SAP HANA Cloud.





This blog discusses the use case where we can use list of values generated in SAP Business Objects Information Design Tool's (IDT) data foundation layer for SAP HANA input parameters (from SAP HANA information view).

As we know that we can map SAP HANA input parameters to universe parameters in data foundation layer of IDT and this can be done by creating derived table in IDT. If you are not sure how to achieve that then please refer to document here. You would need to write a SQL statement to create derived table in IDT. I would like to suggest you to look at SQL statement generated in HANA studio when you preview your data. You can copy the part in green and then use it in IDT (as shown below).

SQL Statement in SAP HANA Studio:

SQL Statement in IDT:


When we use SAP HANA input parameters in Information Design Tool then the list of values created in SAP HANA doesn't come along. For example, following is the input parameter created in SAP HANA information view (using SAP HANA studio). We are using other HANA information view (see "View/Table for value help:*") which contains text attribute for distribution channel.

When we preview data in SAP HANA studio then the we can select from list:

However, this list is not visible or comes along with input parameter in IDT.


In this case, we can create list of values from same HANA information view or data model, which contains text attribute of distribution channel in data foundation layer of Information Design Tool. Please use following steps:

Click on "List of value based on SQL" under "Lists of Values" section in IDT's data foundation

Write the SQL statement and hit "Save" to save data foundation layer.

Once list is created then use it to map with distribution channel parameter.


Now, you should be able to carry this list as well as input parameters to IDT Business Layer and use them as universe prompts. Please note if you are using HANA variables then these variables are visible in data foundation layer and we can use them as Universe prompts as well. HANA variables did not have this issue/gap. So, you can use variables instead of input parameter based on your use case.


If you have attended the Developer Wars at the ASUG's SAP Analytics and BusinessObjects Conference last month, you know how exciting, energetic and entertaining it is. If you have not attended this event, you might want to make a mental note to check it out next year. My blog and the ASUGNews blog can give you some idea of what the Developer Wars is about.


But meanwhile, Megan Fox and Joy Coates from the beneficiary organization, Jobs for The Future, and the winning team from NTT Data have graciously agreed to do a webcast on Wednesday October 15, 2014 from 12:00 - 1:00 PM Central Daylight Time (10 - 11 AM Pacific Daylight Time). Access information will be added later.


This is the 3rd year that ASUG is hosting the Developer Wars at the BusinessObjects Conference. It is getting better and better each year, thanks to the countless hours spent by the ASUG volunteers and the wonderful ASUG staffs. And of course, the fantastic MC performance by our fellow SAP Mentor Jamie Oswald. This is a great representation of what a user community is about.


This year we have 4 teams entering the contest. Three of them are SAP partners and one of them is consisted of SAP customers (code named The Expendables). NTT Data team, code named Optimal Optimizers, have won the contest and they are going to show you their winning solution.


Please mark your calendar and join us on this webcast.





These are the access information:

SAP Connect: https://sap.na.pgiconnect.com/sapmm +1-720-897-6637,, 170 133 7730#

US iPhone: +1-720-897-6637,, 378 224 4518#
US BBerry: +1-720-897-6637 x378 224 4518#

Participant Passcode: 378 224 4518#

Country Number

US and Canada   1-866-312-7353

US and Canada   1-720-897-6637

US and Canada   1-646-434-0499

US and Canada   1-484-427-2544




This was an SAP webcast last week.




Full disclaimer - I am not using this functionality


Figure 1: Source: SAP


Figure 1 shows the type of connectivity between BW and Web Intelligence.


Figure 2: Source: SAP


Size the system correctly; this cannot be emphasized enough the SAP speaker said.


SAP speaker said to size yourself or hire SAP Consulting services


Go to https://service.sap.com/sizing then go to Sizing > Sizing Guidelines > Analytics


It is updated; latest update was in February of this year and is relevant to SAP BusinessObjects Web Intelligence


Figure 3: Source: SAP


The number processing servers and  how many concurrent connections are important considerations per Figure 3


Single processing server per machine; ensure disk cache is available – no limit in memory


Figure 4: Source: SAP


Out of box, you need to better size APS, the SAP speaker said


Figure 5: Source: SAP


Request time out – mimics the amount of time it waits to hear back from a service/server when it gets the data back


Regarding the safety belt see SAP BusinessObjects Increasing Stability by Setting Limits on Max. Retrievable Cells From SAP BW into Web Intelligence Using BICS


Figure 6: Source: SAP


Upgrade, the speaker said to see more performance improvements


Figure 7: Source: SAP


SAP speaker said “Don’t use ConnectionServer32” listed in Figure 7


Figure 8: Source: SAP


Implementation of lean was not fully achieved until BI4.1 SP02 patch 1


Figure 9: Source: SAP


For me, bullet number 3 was new (“determine the actual error being thrown by WebI rather than the error reported to the end user”)


Figure 10: Source: SAP


Run query using RSRT back in BW

Run query through Analysis OLAP/BEx Analyzer – issue is with BW/BICS and not WebI


Figure 11: Source: SAP


Not all features of a BEx Query are supported by Web Intelligence


Look up SAP Note 1869560 - see http://service.sap.com/sap/support/notes/1869560


Figure 12: Source: SAP


Error is thrown when WebI processing server encounters an error when communicating another service, as shown in Figure 12


Figure 13: Source: SAP


See note below:



Reproduce error while have End to End trace


Figure 14: Source: SAP


Do a more refined search; capture root cause error and search for that


Speed up processing of incident – include trace files


Provide raw file to SAP Support – “Do not filter it”, the SAP speaker said


Figure 15: Source: SAP


Figure 15 is a summary.


Full disclosure - I am not using BW with Web Intelligence but these are things you can do with most of the tools when working against BW.


Consider attending SAP TechEd && d-code .  Join ASUG for the ASUG SAP TechEd Pre-conference HANDS-ON: SAP BusinessObjects BI 4.1, SAP BW and SAP BW on SAP HANA – All in One Day, October 20th.  This includes exercises for BW and Web Intelligence. Register today


Also see:

Stay Ahead : Attend TechEd && d-code – Win Big SAP BI BusinessObjects HANA Hands-on Sessions


The roadmap Integration of SAP BusinessObjects BI Suite with SAP BW and SAP ERP was just updated as well (SMP logon required)


This post is about how to avoid scheduling when there is no data fetched from database. Sometime there is client requirement that they don’t want to receive reports when there is no data.

The only way we could stop scheduling the report when no data, is to make scheduling failed so that it doesn’t send any email to recipients.

We can make scheduling fail when there is a runtime error in the report.  So the runtime error considered is 1/0.

Let us consider we have one data provider1 in our report and which gives me results in the report. And for some date there is no data.  Below are the steps to make scheduling fail.


  • Create a new data provider(Query 1)
  • Use Custom Query script and keep the FROM and WHERE clause same as that of "Query 1" script, which is the actual report script. Change the SELECT clause as below :
SELECT  1/count(*)
FROM Query1
WHERE (keep same condition as of  Query 1)
  • When there will no data from Query1, your count wlll be zero and 1/0 will throw error and scheduling gets failed.







In case you may have missed, SAP TechEd d-code is now SAP TechEd && d-code.


Continuing our ASUG meet the speaker series, I am pleased to introduce Kumar Chidambaram of Sigma Aldrich.  His session is EA 215, titled A Holisitc Approach to BI Using SAP HANA, SAP BW, and SAP BusinessObjects.  Get to know Kumar below (photo of Kumar provided by Kumar):




Kumar is working as an IT Director at SIGMA ALDIRCH CORP and is responsible for business intelligence & analytics and SAP technology and a member of the IT leadership team.. He has worked with SAP products & Implementations since 1998 in different roles and responsibilities.  At Sigma Aldrich he is currently running a ‘green field ‘SAP implementation program called SAP NEXT, with SAP HANA as the core technology platform. Their current implementation scope includes following ECC, CRM , SRM , TM , EWM, HR, GTS , APO , BI , Business objects and allied products .  His go live date is Jan 2016.  They have been an SAP customer since 1997 using several of SAP products including ECC 4.7 and BW on HANA currently .


His personal career spans over two decades engaged in different roles in management and IT, spanning manufacturing & service industries and across different parts of the world including Europe & USA. He holds a degree in science and an MBA among other professional certifications.


He lives in Saint Louis, Missouri, with his wife  Sukanya and says he is blessed with two daughters Swathi ( a third year medical student) and Smrithi who is entering college this year.   He personally enjoys Indian classical music, reading fiction  & travel. He enjoys walking long distances across nature trails or quiet surroundings.


I met Kumar in March at an SAP event and found him to be articulate, knowledgeable and forthright.  This is the type of customer-speaker you want to hear from when you attend a SAP event.


Here is his abstract below of his session:


As part of Sigma-Aldrich's strategy to implement a robust and scalable enterprise data warehouse (EDW), they recently migrated their SAP Business Warehouse powered by SAP HANA platform and implemented an SAP BusinessObjects platform and allied toolsets to support their wide user base ranging from desktop to mobile. Hear their practical experience.


So add Kumar's session to your agenda today.



Join ASUG at SAP TechEd && d-code

Venetian/Palazzo Congress Center

ASUG SAP d-code Las Vegas sessions are now published - for a complete listing please see here

Save the date Monday, October 20th for ASUG SAP TechEd d-code Pre-conference Day


Meet ASUG SAP d-code Speaker Charles Reeves - Implementing Enterprise Master Data Management

ASUG SAP d-code SAP BW 7.4 powered by SAP HANA Speaker - Introducing Pawel Mierski

ASUG SAP d-code Sessions Are Published - Featuring SAP Mentors

Journey to Mobile BI - Meet ASUG SAP d-code Speaker Peter Chen

Did you know?

Simon To

Developer Wars 2014

Posted by Simon To Jun 30, 2014


Are you good at building dashboards and visualization? Do you want to let the world know how good you are? This is your chance. Show off your visualization skill at the Developer Wars (DevWars) at ASUG SAP Analytics and BusinessObjects Conference!


This year, the Conference is on September 22-24, 2014 at Omni Fort Worth Hotel (1300 Houston Street, Fort Worth, TX 76102). These are some important links:

Conference Registration: http://www.asugonline.com/asug-sap-businessobjects-user-conference/

Developer Wars Rules: http://www.asugonline.com/wp-content/uploads/2012/10/2014_Dev_Wars_Rules.pdf

Developer Wars Team Submission: http://www.surveymonkey.com/s/TQ89T5W


This is the third year that we host the Developer Wars. It is getting better every year. Last year we had chosen City Year as our beneficiary organization to receive all the visualization solution provided by our contestants. It includes, but not limited to, the winning solution from The Bollywood Spartans team. If you have not been to the Developer Wars, it is a fun-filled event that you don't want to miss. There is an excellent blog written by Marie Alami and Avery Horzewski on last year's Developer Wars.


You can also watch our wonderful MC, Jamie Oswald (@oswaldxxl), and the last year's event on YouTube.


The contestants are not only graded on how to resolve the business problem. They are also graded on how to present the solution. Showmanship is a big part of the competition. And that makes the Developer Wars so unique and so much fun.


So what are you waiting for? Get your team together and sign up! See you at Fort Worth in September!


Simon To


Filter Blog

By author:
By date:
By tag: