Analytics Blog

Dsg Subscribe Mail Web

Blogs (Analytics Blog) (Analytics Blog)

SAP BusinessObjects BI 4.2 Platform – Information Design Tool and more

Part 3 of 3
thumbnail

Brandon Novy
1 Year Ago

This third and final blog of my three part series discusses changes to SAP BusinessObjects 4.2.  Part one of the series discussed changes to the platform.  Part two discussed changes to the reporting tool, Web Intelligence.  This final entry discusses the semantic layer, Information Design Tool as well as a new feature in Crystal Reports.

Information Design Tool

Dynamic default universe prompts

Dynamic prompts allow a developer to change what appears in the prompt of a report.  Previous to BusinessObjects 4.1 Support Pack 6, report developers would typically pick a date and were stuck with it until the next time a report ran.  With dynamic default universe prompts, a formula can be used to change the value in the prompt dynamically, such as today’s date.

Let’s say a report developer wanted a prompt to show the first and last day of the month, because that it how a report commonly runs.  However, they still want to give the report viewer the opportunity to change one of the dates for one-off analysis.  Dynamic default prompts allow this without having to design a cumbersome solution.

Build the Parameters

This example will create a parameter for the first day of the month and a second for the last day of the month.  This will be designed in the business layer, but it also possible to create dynamic prompts in the data foundation layer.

FirstDayOfMonth and LastDayOfMonth parameters

Building a Prompt

Warning!  After building the formula, DO NOT uncheck Set default values.  You will lose the formula and have to undo or worse – recreate the formula.

Building a prompt

First Day of the Month

Use Formula to build the default values for First Day

First Day formula

Last Day of the Month

Use Formula to build the default values for Last Day

Last Day formula

Test in Web Intelligence

Start build Opening date prompt in WebI

Select Use Universe Parameters

Select FirstDayOfMonth parameter

Repeat the Web Intelligence steps for Last Day and run the query

Final output of end-user prompt screen

Linked Universes

Linked universes have been available in version 4.x using the classic Universe Design Tool.  SAP has finally included them in the Information Design Tool giving developers one less reason to stay on the classic platform.

The process for creating a linked universe has changed.  A developer must start with a pre-existing universe and create a linked universe from it.  Once created, the developer can add tables to the new universe which reads from the original universe.  Changes to the original universe are automatically reflected in the new linked universe.  Both the data foundation and business layer from the original universe are available in the linked one.

Select a published universe in IDT and then select Create Linked Universe

Fill out names of business layer and data foundation for the new linked universe

Data Foundation containing regular and linked tables

Business Layer containing normal and linked folders and objects

 

Crystal Reports

A new feature in both flavors of Crystal Reports (2016 and Enterprise 4.2) is Vertical Alignment.  Before this feature, if a developer wanted text displayed at the bottom of a text box, he or she would have to add carriage returns or other tricks to have text displayed in that position.

Format Editor showing Vertical Alignment option in Crystal Reports 2016

That wraps up our three-part series on the new features of SAP BusinessObjects 4.2. 

I hope that you have found the information beneficial.  Please provide comments and let me know what you think of these new SAP BusinessObjects 4.2 features.

Form

Talk To Our Experts