Top 20 Interview Questions and Answers on SAP BUSINESSOBJECTS DESIGN STUDIO Updated 2022

1)  We’ve created a couple of applications using Web Application Designer (WAD), how hard will it be to “migrate” to Design Studio?

Depends on how complex WAD is; if using standard WAD, and not your own custom code; planning to provide conversion support.  Should be a low effort in that case; in case you add custom code and customizing, then it will be hard to migrate using the conversion tool. May consider using Design Studio (DS) to rebuild applications if complex as the technology is different.

2)  When will DesignStudio be supported on Android, please?

Currently, the requirement is on the backlog – planned for releases after 1.2 – the earliest date will be 2014 but no dedicated date. 


3)  Can we build a Design Studio local prototype against our SAP NetWeaver BW 7.02 system without the full BI 4.0/4.1 or older BOBJ platform.

If use BW runtime and want to store on BW, without BI platform, then you have minimum system requirements of BW 730 SP09 or BW731 SP7 

This will work for local prototypes -BW 7.02 is sufficient.  

4)  If we have a design studio app/dashboard based on BW queries, is there an advantage to hosting it in the BW environment vs. BI 4. X environment?

Based on today – 2 differences to consider.  First, if want to connect to multiple back-end systems within one application, then need a BI platform.  With the BI platform, you can connect to multiple systems.  With BW, can only connect to one system.

The other aspect is mobile – with the BI platform you can use the mobile BI solution. 

Also, have an NW portal mobile solution – but it is not a native iOS application but a link. 

Look to future – broadcasting options; plan for broadcasting first enable in BI Platform and later in NetWeaver part.  

5)  Is this only for BW and OLAP? if yes, is there a plan to use it with other data sources?

Design Studio 1.1 can connect to BW and HANA as backend systems.  Plan to connect to other data sources such as universes in future releases.  

6)  What about combinations of sources like HANA + BW, BW + UNX?

Multi-source universes are not yet supported.


7) What is the join related problems and how did you solve it?

Advantages and disadvantages of alias and context. For loops, you can use either alias or context. For alias, you need to create an alias table. 

When you have one end of join you need to create an alias to solve the loop. If you have more than one fact table you go for context. 

It is nothing but creating a path to query. This advantage is that you do not have to add tables.

The disadvantage is it will ask the user to choose the context to run the query. 

The disadvantage with alias is you need to create a table that will increase the size of the universe.

8) what are the steps involved in bo enterprise deployment?

you need to have a database to create a database connection, then you need to install the enterprise software where you need to install either any of the web servers available like tomcat, IIS, WebSphere or you can use the existing web server already there on the server where you are trying to install the software. by default, you have MySQL Installed, but if you have a database already you can use the existing database by giving the user id, PWD, and instance name of the database to create and install the repository, it will automatically install the software.

9) Any plans to introduce data connectivity to excel/flat files and Databases like that exist in Lumira?

That is available today using the data source SDK – go to

10) We find that it takes longer to develop dashboards in the design studio due to scripting requirements for even basic tasks. What’s done to address this issue?

See what is coming in 1.5 for self-service scenarios and templates

11) It seems like a confusing strategy to have platform builds for BI and HANA. Should we somehow plan for BI 4 to be deprecated in favor of HANA?

BI4 is the most feature-rich for Design Studio including Mobile BI – per SAP at SAPPHIRENOW

12) How do you convert unv file to unx file?

Using UMT Upgrade Management provided with BI 4 for prior releases or in IDT you can do a direct conversion.

13 ) When you convert a UNV file to UNX files, which of the features are not supported?

In IDT, it doesn’t convert OLAP universes created with prior releases. It is recommended to make a connection to the OLAP source to take dimensional modeling advantages.

You can’t convert universes based on stored procedures using IDT.

Using IDT, you can convert linked universes however they are not supported in BI 4.

14) What do you understand by custom hierarchies?

They are used to perform custom drills down on objects from the same or different classes in the Universe. To create a Custom hierarchy, go to Tools → Hierarchies.


15) What is the difference between a cnx and a CNS file?

.cns – secured Repository connection

.cnx – local unsecured connection. If you use this connection it will not allow you to publish anything to the repository.

16) What is the Chasm trap? 

When you join a dimension table with two fact tables with too many relationships when you drag a dimension along with measure from both the fact tables, the value of measures is inflated. This is called Chasm trap.

17) What is Fan trap? How do you resolve this?

In a Universe, when you have 3 tables in structure and the first table is joined with one too many relationships with the second table which is connected with one to many relationships with the third table and when you drag a measure from 2nd table and dimension from 3rd table, the value of the measure is inflated, this condition is called Fan trap.

18) What is Aggregate awareness? How do you use this?

Using aggregate awareness, you can use pre-aggregated data in tables in the database. It is used to improve query performance by processing fewer rows.

When you add an aggregate aware object in the query, the query generator retrieves the data from the table with the highest aggregation level.

19) What is the difference between thick and thin client?

For a thin client, you do not need to install the software. You need to have an IP address of the webserver and you can access the application. For full clients for example if you want to open or edit desktop intelligence reports and web rich clients you need to install software on your desktop.

20) What is the difference between xir2 and xir3?

It is the same architecture. But they have clubbed all the servers into one server called BI server in xir3. In xir2 if you look at the central configuration manager the servers are mentioned individually. You have webi rich client and in xir3 you have more integration with the sap tool.