SAP BusinessObjects – Semantic Layer

Recording and reporting data using SAP Business Objects

Analytics is the information resulting from the systematic analysis of data or statistics. SAP Business Objects platform is one of the best platforms for analytics and BI as it supports the digital world with real-time insight and data-driven decision making. I experienced its flexibility, scalability and self-service ability when I could share insights during my project work.   Here’s what I did in my project – I tried to reverse …

Read More »

SAP BOBJ Universe-IDT: How to Copy .dfx and .blx between Qualifiers under single .cns

HI, This document would be helpful when there is a need to create multiple .dfx and .blx on Qualifiers(multiple data bases) from a single .cns / .cnx connection in IDT. This requirement is worked with SAP BOBJ 4.2 version. There are no version dependencies. I had encountered such requirement where I need to use same tables and create similar joins but on different data bases under connection. For example : Under …

Read More »

Point of View on BICS vs UNX

This topic is discussed couple of times in Blog/questions. Here I am writing based on the project experience. When/how BICS or UNX is useful and Pros & Cons of each. SAP BI 4.X Connectivity for SAP BW: Benefits of Business Intelligence Consumer Services (BICS): SAP introduced BICS from BI 4.0 release. Web intelligence can connect directly to BEx queries by skipping extra universe layer through BICS connectivity. Benefits of using …

Read More »

Bulk renaming of Objects (and a lot more things) in a Universe (IDT)

(Update 1 – As of 10/24/2016 9:50 am (EST) – Please look at the end for update details) We’ve seen many Developers requesting for a feature that would help to rename Objects in bulk. One such idea was created in Idea Place, hoping that feature becomes a reality, and hopefully save hours of work. Bulk Objects Renaming in IDT – D32795 Actually, there is already a way to rename Objects. Let’s take …

Read More »

The Fate of the Universe Depends on You, Part 2 of 2

In part one of this series (see related SCN article, The Fate of the Universe Depends on You, Part 1 of 2), I made the case for whole-hearted adoption of the Information Design Tool to build universes. In part two, I’d like to provide some best practices for successful adoption of the Information Design Tool (IDT). Stop using Universe Design Tool The first best practice is simple. Just stop using …

Read More »

The Fate of the Universe Depends on You, Part 1 of 2

SAP BusinessObjects BI 4.0 shipped with two universe tools. The classic “Designer” tool, which generates universes with a UNV extension, was re-branded as the Universe Design Tool. Alongside it, a new tool called the Information Design Tool, which generates universes with a UNX extension, was introduced to create universes. The Universe Design Tool and its UNV format will one day be retired; however, SAP has not announced a date for …

Read More »

BI4.2 SP3: How to create and use Temporal Set to look into your data based on calendar?

In my previous blog *New BI4.2 SP3 feature* :  Working with BI Sets,  I showed how to understand, create set in IDT and then use it in Web Intelligence. Now, I will show you a sample about how to create and use Temporal Set to look into your data based on calendar. Scenario Before showing steps to create temporal set, please check the following result of Web Intelligence document. It …

Read More »

*New BI4.2 SP3 feature* : Working with BI Sets

According to this document SAP BI 4.2 SP3: What’s New In Semantic Layer,  the BI Sets support is the main enhancement in SAP BI 4.2 SP3 for Semantic Layer and the information design tool (IDT). Here, I will show you how to understand, create set in IDT and then use it in Web Intelligence. Introduction A Set is a structure that you define to group lists of values, which is …

Read More »

How to Export Universe Objects into an Excel

I would like to share how you can export the Business Layer objects into an excel document with all the object names in the column Environment: SAP BI Platform 4.1 Sp6 Patch 4                       Universe Details: UNX (IDT)                       Excel: 2013 Login to IDT and export the desired BL to a Text document. Open the text file and save as to a xls file. Open the xls file. It should …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration