• LOGIN
  • No products in the cart.

SAP BODS Interview Questions

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

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

When will DesignStudio be supported on Android, please?

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

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.

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 BI platform. With BI platform you can connect to multiple systems. With BW, can only connect to one system.
The other aspect is mobile – with BI platform you can use the mobile BI solution.
Also have 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.

Are you Looking for SAP Bods Training? Please Enroll for Demo SAP Bods..!

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 the future releases.

What about combination of sources like HANA + BW, BW + UNX?

Multi-source universes are not yet supported.

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

Advantages and dis advantages of alias and context. For loops you can u see either alias or context. For alias you need to create alias table.
When you have one end of join you need to create alias to solve loop. If you have more than one fact table you go for context.
It is nothing but creating a path to query. In this advantage is that you do not have to add tables.
Dis advantage is it will ask the use to choose the context to run the query.
Dis advantage with alias is you need to create table which will increase size of universe.

What are steps involved in bo enterprise deployment

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

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 help.sap.com/boad

10) We find that it takes longer to develop dashboards in 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

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

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.

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 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.

What do you understand by custom hierarchies?

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

What is the difference between a cnx and cns file?

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

What is Chasm trap?

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

What is Fan trap? How do you resolve this?

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

Are you Looking for SAP Bods Online Training? Please Enroll for Demo SAP Bods..!

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 less number of rows.
When you add an aggregate aware object in query, query generator retrieves the data from table with highest aggregation level.

What is diff between thick and thin client?

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

What is diff 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 sap tool.

October 31, 2019
GoLogica Technologies Private Limited  © 2019. All rights reserved.