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 custom code; plan 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.
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.
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 the 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. the 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, we 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 enabled in BI Platform and later in NetWeaver part.
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.
What about the combination of sources like HANA + BW, BW + UNX?
Multi-source universes are not yet supported.
What are the join related problems and how did you solve them
Advantages and disadvantages of alias and context. For loops, you can see either alias or context. For an 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.
Dis advantage is it will ask the user to choose the context to run the query.
Dis advantage of an alias is you need to create a table that will increase the size of the universe.
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, or 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
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 the design studio due to scripting requirements for even basic tasks. What’s been 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
| Learn more information from the GoLogica “SAP ABAP Training“ |
How do you convert the unit file to a Unix 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 a UNX file, 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 drills down on objects from the same or different classes in the Universe. To create a Custom hierarchy, go to Tools → Hierarchies.
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.
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 a measure from both the fact tables, the value of measures is inflated. This is called the Chasm trap.
What is a Fan trap? How do you resolve this?
In a Universe, when you have 3 tables in structure and the first table is joined with too many relationships with a 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.
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 a query, the query generator retrieves the data from the table with the highest aggregation level.
What is the diff between thick and thin clients?
For thin clients, you do not need to install software. You need to have the IP address of the web server and you can access the application. For full clients, for example,e if you want to open or edit desktop intelligence reports and web-rich clients 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 a Webi rich client and in xir3 you have more integration with the sap tool.
Related Articles:
🎯 Who uses SAP BPC?
🎯 SAP Lumira Interview Questions and Answers
🎯 SAP Variant configuration(VC) Interview Questions and Answers
🎯 SAP C4C Technical Interview Questions and Answers
🎯 SAP SRM Interview Questions
🎯 SAP Production Planning Interview Questions
🎯 SAP Customer Services Interview Questions
🎯 SAP HANA Administration Interview Questions