Tuesday, 27 June 2017

SAP DESIGN STUDIO INTERVIEW Question & Answer

Question & Answer

Q:  For a “net new” organization that is going to be using SAP ECC & BW in early-2014 should we be “scrapping” any Proof-of-Concept work we have done in Dashboard (Xcelsius) and start “clean” in the new Dashboard Design tool…?
A:  Recommend look at 1.2 version which planned for  GA in Q4 and build prototype; when comparing to Xcelsius, not all visual components are in Design Studio.
A:  Design Studio has OLAP features, mobile HTML5 technologies; build prototype in Design Studio 
A:  Design Studio still does not have offline feature  
________________________________________________________________
Q:  Will 1.2 version of Design Studio require the to be running under the the 4.1 version of the SAP BO-BI Platform…?
A:  1.2 BI Platform requirements are the same as 1.1 – read the PAM for the 1.1 version – service.sap.com/pam  
________________________________________________________________
Q:  We’ve created a couple of applications using Web Application Designer (WAD), how hard will it be to “migrate” to Design Studio?
A:  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. 
A:  May consider using Design Studio (DS) to rebuild application if complex as the technology is different.  
________________________________________________________________
Q:  When will DesignStudio be supported on Android, please?
A:  Currently requirement is on backlog – planned for releases after 1.2 – earliest date will be 2014 but no dedicated date.  
________________________________________________________________
Q:  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.
A:  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 
A:  This will work for local prototypes -BW 7.02 is sufficient.  
________________________________________________________________
Q:  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?
A:  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. 
A:  The other aspect is mobile – with BI platform you can use the mobile BI solution. 
A:  Also have NW portal mobile solution – but it is not a native iOS application but a link. 
A:  Look to future – broadcasting options; plan for broadcasting first enable in BI Platform and later in NetWeaver part.  
________________________________________________________________
Q:  Is this only for BW and OLAP? if yes, is there a plan to use it with other data sources?
A:  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.  
________________________________________________________________
Q:  When will geo maps/geo coding be added, please?
A:  This is planned for releases after 1.2 in backlog.  
________________________________________________________________
Q:  Does design Studio support Hierarchy?
A:  Yes Design Studio supports all OLAP features that BW provides – time dependent hierarchy, attributes, etc.
________________________________________________________________
Q:  Can Design Studio connect to R/3 systems and fetch data from backend tables. If not, are there any alternative tools?
A:  1.2 via SDK via web services; or use transient provider today (ehp 5 ECC 6.0 or higher)  
________________________________________________________________
Q:  What is the roadmap for supporting BW Integrated Planning? Rough Timeline?
A:  This is a very high rated in Idea Place – planning to do this in 1.3 next year – can’t promise though
________________________________________________________________
Q:  Will Integrated Planning functions be supported by Design Studio.
A:  Just answered – planned for 2014  

SAP BusinessObjects Design Studio 1.7

SAP BusinessObjects Design Studio 1.7

In this SAP Design Studio webinar replay,SAP BusinessObjects Design Studio, presents the key capabilities of the recently released SAP BusinessObjects Design Studio 1.6. Jie’s presentation includes a review of the scorecard, spreadsheet, CSV file as data source, and geomap enhancements and is followed by a product demonstration as well as a glimpse at the product roadmap.

The session concludes with a Q&A segment with our presenter.

Agenda:
- Introduction
- Overview of the SAP BI Client Portfolio – 01:07
- What is SAP BusinessObjects Design Studio? – 10:22
- New features and functions in release 1.6 – 18:14
- Product Demonstration – 27:32
- Roadmap – 51:29
- Q&A – 53:51



suman training
Contact numbers : +91 9972971235,+91-9663233300(India)
Email Id : Madhukar.dwbi@gmail.com,
YouTube: https://www.youtube.com/channel/UCyjPre0c-A-7EAzjqkKM1Ng
Facebook: https://www.facebook.com/?sw_fnr_id=725850671
Twitter: https://twitter.com/suman4tr
Website: http://onlinebusinessobjectstraining.com
http://sapboonlinetrainings.com
http://www.sap-bo-online-training.com/


Tuesday, 20 June 2017

sap design studio interview qns and ans


Can Visual Composer applications be migrated to Design Studios?
With current planning the answer is no as Design Studio is the premium alternative to WAD/Xcelsius and VC is different technology  
Does design Studio support Hierarchy?
Yes Design Studio supports all OLAP features that BW provides – time dependent hierarchy, attributes, etc.
What are the differences between Personal, Shared and Secured connections?
A Personal connection is created by one user and cannot be used by other users. The connection details are stored in PDAC.LSI file.
A shared connection can be used by other users through a shared server. The connection details are stored in SDAC.LSI file in the Business Objects installation folder. However one cannot set rights and securities on objects in a shared connection. Neither can a Universe to exported to repository using a shared connection.
A secured connection overcomes these limitations. Through it rights can be set on objects and documents. Universes can be exported to the central repository only through a secured connection. The connection parameters in this case are saved in the CMS.
What is a fan trap? How can it be solved?
In a universe structure, we may have 3 tables joined in such a way that, the 1st table has a one to many join with the 2nd table, which in turn has a one to many join with the 3rd table(A -< B -< C). In such a scenario, if a measure is present in the 2nd table and it is dragged along with any dimension from the 3rd table, the value of the measure will be inflated. Such a condition is known as a fan trap.
A fan trap is solved by creating an alias of the 2nd table and defining contexts such that, the normal table is joined only with the first table, while the alias is joined with both the 1st and the 3rd table. We would take 2nd table’s measure only from the normal table and other dimensions of the 2nd table from the alias table
Should we encounter fan traps in a data warehouse scenario? If so, then how?
If a data warehouse is based on the Kimball model, it is a dimensional schema. In a universe built on that DW, for a fan trap to occur in such a schema, we require direct join between two fact tables, which is against the principles of dimensional modeling.
On the other hand in a data warehouse based on Inmon model, it is a normalized schema. Though in such a case, universes are generally designed on Data Marts, which are dimensional schemas (where fan traps should not occur). However, if a universe is built on the DW (for the purpose of operational reporting), then a fan trap can occur in that universe
What are the 2 different approaches of implementing aggregate awareness? Which one is better in terms of performance?
The 2 approaches are as follows:
Aggregate tables are built in the database, which contains the dimension fields(not foreign keys) along with the aggregated measures. In the universe they are present as standalone tables, i.e they are not joined with any dimensions. Aggregate aware function is used to define both the dimensions and measures of such tables.
No aggregate tables are built in the database level. They contain the normal fact table at different granularities. In the universe, aggregate aware is used only to define the measures and aggregate incompatibility is set accordingly.
The first approach is better in terms of performance, since for the higher levels of aggregation, all the information is obtained for a single table. However, a large scale implementation of this approach in a dimensional schema is difficult. In most BI projects, the second approach is preferred.
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.  
When will geo maps/geo coding be added, please?
This is planned for releases after 1.2 in backlog.
Can Design Studio connect to R/3 systems and fetch data from backend tables. If not, are there any alternative tools?
1.2 via SDK via web services; or use transient provider today (ehp 5 ECC 6.0 or higher)  
How can Geo-Maps be integrated in Design Studio? Are there any 3rd party Add-ons which Design Studio support for the same ?
With 1.1 do not have; with 1.2 will not have geo maps; partner using SDK could do that but beta program has just started. 



SAP Design Studio Advanced Visualizations and Dashboards

SAP Design Studio Advanced Visualizations and Dashboards
suman training
In this SAP Design Studio webinar replay, we investigate the ChartsPLUS
 add-on developed by SAP Partner Archius. This SDK-based extension greatly
 enhances the visualization capabilities of SAP Design Studio and also
accelerates the dashboard development time.
http://onlinebusinessobjectstraining.com
Contact numbers : +91 9972971235,+91-9663233300(India)
Email Id : Madhukar.dwbi@gmail.com,
https://youtu.be/Y2mo0nfncUs
Website:
http://onlinebusinessobjectstraining.com

http://www.sap-bo-online-training.com/

http://sapboonlinetrainings.com