I was searching the SAP website for information on new features of SAP Business Objects – Information Design tool(IDT)(Previously Universe Designer). I came across a webpage which SAP has put together to  list all the video tutorials for Information Design Tool. Use ->SAP Business Objects – Information Design tool(IDT) Online video tutorial link to watch the videos.


Back to Blogging !!!

Posted: September 28, 2012 in Uncategorized
Tags: ,

After being quite for a while I am back on the field. Last few months had been very busy and was getting ready for the prime time of blogging again. Here I am back again !!!

Look out for some new blogs on the exciting topic of BI …..

Over the past several months, a number of certification exams have been released to SAP and Pearson VUE delivery centers.  Typically, once an exam is released for delivery at SAP, its release at Pearson VUE will occur approximately 2-4 weeks later.  Below are the exams recently-released to SAP delivery centers hyperlinked to their web description (which provides certification details, competency areas, schedule, and roles & tracks).  Pay special attention to the competency areas tab where the list of courses needed for preparation are located.

·         C_HANAIMP_70 – SAP Certified Application Associate – SAP HANA 1.0

·         C_TBI30_73 – SAP Certified Application Associate – Business Intelligence with SAP BW7.3 and SAP BI4.0

·         C_TBW55_73 – SAP Certified Application Assoc. – Modeling and Data Management with SAP BW7.3 and SAP BI4.0

·         C_BOCR_11 – SAP Certified Application Associate – Crystal Reports 2011

·         C_BOWI_40 – SAP Certified Application Associate – SAP BusinessObjects Web Intelligence 4.0

·         C_EP120_701 – SAP Certified Development Associate – SAP NetWeaver Portal 7.01

·         C_TEP10_702 – SAP Certified Technology Associate NetWeaver Portal 7.02

·         C_TBIT51_73 – SAP Certified Technology Associate – Process Integration with SAP NetWeaver (PI 7.3)

·         C_TM_80 – SAP Certified Application Associate – SAP Transportation Management with SAP TM 8.0

SAP Education is proud to announce the launch of a certification program for SAP HANA.  The certification “SAP Certified Application Associate – SAP HANA 1.0” provides successful examinees a globally recognized mark of excellence by validating their experience with SAP HANA 1.0 from a technical and application perspective.

Key Facts:

Target audience:  Partner consultant, SAP consultants, and customers that engage in SAP HANA projects in modeling and implementation roles.

Delivery options:  Through SAP training centers (available on November 25, 2011) and Pearson VUE (planned availability on December 14, 2011).   If in the US or Canada, please use promotion code 10CERTSS once registration opens at a Pearson VUE delivery center on12/14/2011.

Certification title:  SAP Certified Application Associate – SAP HANA 1.0

Booking code:  C_HANAIMP_10

Exam structure:  3 hour multiple-choice exam with 80 items

The certification builds on the knowledge gained through related SAP HANA training and preferably refined by practical experience:

·         an instructor led 2-day introductory course TZHANA

·         a 4-hour recorded introductory training RHANA

·         a self-paced Online Knowledge Product (OKP) OHA10

The current education portfolio for SAP HANA will be complemented by the following in-depth training.   All courses will be available on theSAP HANA 1.0 (SP03) release by the end of 2011 or early 2012.

·         Installation  Administration (TZH200)

·         Implementation & Modeling (TZH300)

·         SAP BW on SAP HANA 1.0 (TZBWHA)

The program has been published on the online training catalog as a separate curriculum for SAP HANA 1.0. Our multi-channel delivery approach (classroom based, virtual delivery, online) allows learners to get the knowledge they need in the best possible format.  In addition, we have made finding and acquiring this knowledge simpler than ever for customers by combining individual courses into pre-defined packages which can be found via Accelerated Learning Packages for SAP HANA.

Here are the scenarios for “Maximum binary output size limit reached” error –

– When a large Web Intelligence report is exported to CSV format, we get error: Max Binary file size limit exceeded. The document is too large to be processed by the server. Error WIS 30271

– In Web Intelligence, when attempting to save a report to Excel or Portable Document Format (PDF), the following error message appears:

“Max binary file size limit exceeded. The document is too large to be processed by the server. Contact your database administrator. (Error: WIS 30271)”.


This error message appears because Business Objects Enterprise allows documents to be saved up to the limit set for Web Intelligence Report Server in the Central Management Console (CMC). The default file size limit is 50 megabytes for binary file types like PDF and Excel.

Solution –

To resolve this error message, you will need to increase the Max Binary file size value.

1. Open the CMC.

2. Browse to Servers

3. Click on your Web Intelligence Report Server.

4. On the Properties page, increase the Maximum Binary File Size (Default value=50 MBytes; Maximum value = 65535 MBytes)..

5. Apply the setting and allow the Web Intelligence Report Server to restart.

Increasing these values too high could impact Web Intelligence performance when users attempt to save excessively large files.

Recommendation –

Thresholds are built to protect the system. If there is valid business reason, then by all means, go ahead and adjust the parameters as needed to solve the problem. However, I would use this opportunity to look into the report itself, and see if this is the best way to present/publish the information.

Before increasing the Max binary file size ask your user –

– Do You really need such a large Excel/PDF file?

– Can some of the unnecessary columns be dropped

– Can some filter be applied on the report to reduce the no of rows

If none of the above can be done then go ahead and increase the size.


Dashboard Design

SAP BusinessObjects Dashboard Design (formerly called Xcelsius) contains new features and

enhancements that are focused on improving productivity and direct enterprise data connectivity. These features and enhancements include new and updated support for SAP BusinessObjects Universe queries and integration with SAP BusinessObjects Enterprise.


Dashboard Design caching and processing servers

A new data processing layer is available for enterprise data connectivity and is designed to address the scalability and performance requirements of large scale dashboarding deployments. It includes two new servers: a Dashboard Design Cache Server and a Dashboard Processing Server. The Dashboard Design Cache Server provides data caching and sharing on consistent data models (Relational Universe queries) off the Semantic Layer, and the Dashboard Processing Server manages query processing requests. Both servers are integrated into standard BI Platform services including auditing and monitoring.


Query Panel

A new Query Panel is available for creating Universe-based queries in Dashboard Design. To define a query, you can now drag relational universe objects, dimensions, and measures from the Query Panel to the canvas. You can also define the order that result objects are returned by the query, the data sort order, query filters, and single- or multi-selection prompts. The Query Panel also provides a data preview of the query.


Query Browser Panel

The new Query Browser Panel displays a summary view of result objects, filters, and prompts included in the model and provides quick access to the Query Panel for creating and editing queries. You can also refresh queries from the Query Browser to update query data that is bound to components. When you drag a query from the Query Browser Panel to the canvas, a Prompt Selector component is automatically added to the model.


Direct data binding

In Dashboard Design, you can now bind data from query result objects directly to charts and selectors. When data is bound directly to charts and selectors, the component displays a preview of the query data on the canvas in design time.


Universe Connectivity components

The Components Browser contains a new Universe Connectivity category dedicated to query data connections. The Universe Connectivity category contains two new components: Query Prompt Selector and Query Refresh Button.

The Query Prompt Selector component automatically handles prompt value selection behavior based on the metadata for the query prompt. The Query Prompt Selector component is available in three styles:

• Single value

• Single or multiple selection with List of Values

• Single or multiple selection with cascading List of Values

If the prompt includes a list of values, the Query Prompt Selector component allows users to search for or browse through the list at runtime and also select whether the values are shown or hidden in the model.

The Query Refresh Button component allows users to request a refresh of the query data from within the model at runtime.


Regional Data Format by User Preferred Viewing Locale

Data formatting controls how data, such as dates, times, currency, and numeric values, is presented to users. In previous versions of the product, the data format was determined by the locale set when the model was created. Dashboard Design now allows models to format their data using dynamic regional data formats, which means that the format can be changed automatically to match the end user’s preferred viewing locale.


You do not need to do anything to configure regional data formatting. When Dashboard Design models are saved on the platform, the model automatically adjusts its data format settings to match the preferred viewing locale set in BI launch pad.


Text translation

In Dashboard Design, most text contained in models published to the platform can be translated to other languages through the Translation Manager. When a model is saved to the platform, the translation workflow is enabled and translation experts translate the text used in the model. The text translations are then published to the platform and combined with the model to create localized versions of the model. At runtime, user’s see the localized version that matches their preferred viewing locale.

The following text in Dashboard Design models can be translated:

• Most text input including titles, subtitles, series names, category names, and so on.

• Data in Excel ranges that are marked as translatable by the model designer.


Dashboard Design objects


Dashboard Design introduces a new object type in SAP BusinessObjects Enterprise. Previous versions of the software required two objects: an Xcelsius object for working with the model in the designer, and a Flash object for running the model. The new Dashboard Design object holds both the design document (XLF) and the Flash file (SWF) in a single object.

If the object is opened in Dashboard Design and modified or changed through the Translation Manager, the SWF cached in the Dashboard Design object is automatically updated to reflect the changes. Model designers do not need to re-export the Flash object separately for users to receive the latest changes.

Dashboard Design objects support object-level security. For example, system administrators can set the user rights to block certain users or user groups from modifying or even viewing the dashboard.For models that have Universe query connections, system administrators can specify preferred server groups for query caching and processing. Object-level caching options override server-level settings,so system administrators can allocate resources and adjust processing settings to accommodate individual model requirements.


Lifecycle Management of Dashboard Design objects

To integrate with Lifecycle Management support in SAP BusinessObjects Enterprise XI 4.0, the new Dashboard Design object maintains relationship and dependency information, including the model’s:

• relationship with Universe queries

• dependency on QaaWS and Universe objects in QaaWS connections

• dependencies on correspondingCrystalreports, Interactive Analysis documents, and Universe

objects in Live Office connections

With integration to Lifecycle Management tools, system administrators can check dependency information for Dashboard Design objects and make sure all dependent objects are promoted together.

Dashboard Design models access SAP BusinessObjects Enterprise data through a Web Services

connection. If the model is migrated to a different location, such as from a testing system to a production environment, the Web Services URL might change. To support this scenario, Dashboard Design models accept dynamic Web Services URLs at runtime. BI launch pad and the CMC retrieve the Web Services URL from the Web Services application object for the Web Services connection.

SAP today announced that it is building on its collaboration with Google to help customers manage large data volumes in intuitive, visual displays and facilitate faster, more-informed decisions. SAP plans to enhance its business analytics software with location-based data capabilities, allowing people to interact with real-time information via Google Maps. The plans continue a strong history of collaboration between the companies, most recently on advances for SAP


Click here to



50% discount promotion code for certification exams taken at US and CA Pearson VUE delivery centers before 9/30/2011.


For a list of exams available at Pearson VUE, please refer to their website at http://www.pearsonvue.com/sap.

Free Sample Questions for SAP Business Objects Web Intelligence(BOWI-30) Exam

Which three output context expressions are valid extended syntax expressions? (Choose three.)

A. Where Section In [State]

B. Where ([State] = “CA”)

C. In Section Where ([State] = “CA”)

D. Where ([State]=”CA” And [Year] =”2006″)

E. In Block Where Section = [State]



Answer: BCD