Jul 11, 2017 how to repoint webi reports converted from deski to a freehand sql connection. Web intelligence will then scale the documents contents to fit everything on 1 page horizontally. Of course, weve known that this day would come for nearly ten years, and some people started early in migrating their deski documents to web intelligence webi. Simplified and flexible management, implementation and documentation of businessobjects xi security oneclick security changes using dynamic web matrices. Business objects web intelligence webi advanced techniques. Business objects web intelligence xi 3 interview questions. To open an existing deski report that has been migrated to the bi 4. With this solution, deski documents that require additional time to convert can be consumed from a bi 4. Installation guide pdf business intelligence platform installation guide for unix, 4. This is a handy tool for business users for analytical and ad hoc reporting. Perform an impact analysis across the objects and tables. Business objects and infoburst training handout knowledge.
Sep 29, 2014 interview questions and answers free pdf download page 18 of 51 deski report when one drags the measure object with the dimension object of a particular granularity, the measure column from the fact table of the corresponding granularity is selected in the bo default query. Free hand sql support create a document based on free hand sql in bi launch pad the ability to use free hand sql is now controlled via a security right set at connection level. If your company uses infoview, and has 3tier deployment of desktop intelligence, you can log in to desktop intelligence via infoview on the web. The free hand sql call to the oracle stored procedure that we wrote in bo xi r2 deski report does not work in webi free hand sql bi 4. This document lists specific platforms and configurations for the businessobjects enterprise xi 3. Ppt m2 overview deski powerpoint presentation free. Sap businessobjects business intelligence suite document version. Jan 06, 2012 as you probably know by now, with the release of sap businessobjects business intelligence 4. The question has been asked so many times, including from clients, that i decided to attempt to put together a comprehensive list of the differences. Business objects developer resume samples qwikresume. Qliktech provides qlikview desktop for free as an unlicensed client tool that limits you to what you can share with others, but still lets you experience the power of the tool by yourself.
This will allow you to continue using deski while converting your other deski reports to webi. Business objects report writing guide cms net california. Top 20 business objects interview questions and answers. What are all the differences between desktop intelligence deski and web intelligence webi. It will show warning, if you edit, it will replace with new values and click ok. During your training session, we will complete the following steps to finalize the creation of your new webi account and confirm the deski reports you moved to the business objects repository have been converted to webi reports. Sap businessobjects desktop intelligence configipedia. Deski documents based on free handsql can be fully converted to webi since bi4. Instead of going through rct converted reports partially converted and fully converted, i would be happy to provide more details on how we can achieve the webi reports 100% and what are the workarounds we have used for each issue we. As you probably know by now, with the release of sap businessobjects business intelligence 4. Apr 19, 2012 deski always added the new objects to the block automatically. You can also remove items from the result objects panel by selecting the field and pressing delete on your keyboard or by using the remove icon. Good understanding and work experience of data models such as snowflakes, star and normalized excellent dashboard designxcelsius work experience sap bw environment work experience installed businessobject on sand box.
What it doesnt mean is that youll need to print the document on a3 paper you can if you want to, but you dont have to. Sap businessobjects business intelligence bi platform. What are the different versions of business objects that you have worked on. Dec 18, 2014 this post is the continuous of my previous deski 3. But not all the deski documents are converted to webi through report conversion tool. Web intelligence free hand sql fhsqlstored procedures in. Migrating from desktop intelligence to web intelligence. The desktop intelligence compatibility pack dcp is solution that allows customers to use deski xi 3. Select the object and click edit and perform whatever the changes you want in that object lov. Jun 08, 2015 the free hand sql call to the oracle stored procedure that we wrote in bo xi r2 deski report does not work in webi free hand sql bi 4.
This training is intended for advanced users of the web intelligence version of business objects. To save a report to your favorites folder or a shared folder from. But invariably, i would end up moving them someplace else, or removing them the block, because i didnt want them in that block. In deski, the use case is for power users to effectively add variables to universe objects reusable variables across reports. Business objects report conversion tool sql server dba. If you export a document with a page size set to a3 to pdf, youll notice that the pages are larger in the pdf and youll need to zoom out further to see the whole page at once. If there is any feature which doesnt available in webi is present in the deski. Businessobjects desktop intelligence deski java and vs. So, dpvalue only works, if you used the appropriate function of business objects to create the hidden list of values.
As per my experience good interviewers hardly plan to ask any particular question during your interview, normally questions start with some basic concept of the subject and. Installation guide pdf business intelligence platform installation guide for windows, 4. Dimensions would be added to the right of existing dimensions, and measures would be added to the right of existing measures. Share insights and make better decisions with the sap businessobjects business intelligence bi suite. It allows the desktop intelligence reports, users, universes and database connections to be managed by the bi 4. Work in a multi user environment where, for example, one person can work on the business layer while another modifies the data foundations of the universe. You have the option of viewing folders or categories. Version manger for sap vm4sap is a sap bi version management, source control, source audit and deployment product that enables version management across multiple controlled documents within the sap environment. While creating queries on universe you can find the information on objects that you have to use in query. We ranked the top skills based on the percentage of business objects developer resumes they appeared on. If you want to load external lov for a particular object, then click the object and select personal data from the properties section.
What are the key differences between boxi r3 and sap bo 4. Business objects is a dynamic business intelligence reporting solution from business objects. There was a deski compatibility pack which allowed a deski client to connect to a bi4. Thirdparty contributors business objects products in this release may contain redistributions of software licensed from thirdparty contributors. Classes are used to group similar objects in a report.
Data access and analysis 3 table of contents table of contents 3 part i introduction chapter 1 introduction to desktop intelligence 19. Classes are used to organize objects in some logical manner. Free sap business objects training demo sap bo bj training. A powerful set of businessobjects administration tools for enhanced security management, auditing, backup recovery and impact analysis.
The rct is really buggy and not intended to be an enduser tool. Deski isnt exactly back but you no longer have to wait to get your deski reports converted to web intelligence to move to the latest sap businessobjects platform. This post is the continuous of my previous deski 3. They even provide free online training to get you started. Conversion from desktop intelligence to web intelligence.
The document contain links to web applications using the retired deski documents. You can view the deski reports in webi, but not webi reports in deski. Support your growth with a single, centralized platform for reporting and visualization. Web intelligence, the business intelligence reporting tool, is a part of sap businessobjects product suite. Accessing data and data analysis business objects, the business objects logo, crystal reports, and crystal enterprise are trademarks or registered trademarks subqueries and calculations. Top 31 most important sap bo interview questions and answers. Sep 21, 2016 free sap business objects training demo sap bo bobj training sap bo bj training sap business objects tutorials sap business objects tutorials for beginners 2017 sap bo online training. Using web intelligence, business users can create basic, medium, and complex reports from transactional data in database to meet business requirements. Once the report has been opened, its business as usual. The only restriction is that free hand sql data providers in web intelligence must be based on secured connections, while deski supports both personal and secured connections for free hand sql data providers.
How to repoint webi reports converted from deski to a freehand sql connection. Subclasses contains further subcategory of objects in upper level of a class. Simplified and flexible management, implementation and documentation of businessobjects xi security oneclick security changes. There are two possible solutions, depending on the version of sap businessobjects youre using. Repoint webi reports converted from deski to freehand sql. Access to the best deski conversion tool if you have desktop intelligence deski reports, there are so many features in bi4. How do you migrate deski to webi reports in business objects. This document lists sample applications using the businessobjects deski java and visual studio solution developer kit sdk. Business objects is an integrated query, reporting and analysis solution for business professionals that allow them to access the data in their corporate databases directly from their desktop and present and analyze this information in a business. Do you have sap businessobjects desktop intelligence users. Where to begin learning business objects training options.
If you look in the toolbar under page setup scale to page width, youll be able to set the page width to 1 page. We all know that business objects desktop intelligence is no more part of sap bo 4. Desktop intelligence users guide reporting techniques and formatting 19. Below weve compiled a list of the most important skills for a business objects developer. Minor release update guide pdf minor release update guide, 4. The authors have done an admirable job of updating the material from the previous versions of the book. You can add fields from the available objects pane to the result objects panel by selecting the desired field and dragging it into the results objects panel or by doubleclicking the field. In the past couple of years, ive chatted with several companies who are long time deski shops. Basic sql like select from a table does work in free hand sql of webi bi 4. Desktop intelligence will continue to be supported on xi 3. Businessobjects is an integrated query, reporting and analysis solution for business professionals that allow you to access the data in your corporate databases directly from your desktop and present and analyze this information in a businessobjects document. End of 2015 there wont be any update maintenance other than priority for desktop.
Instead of going through rct converted reports partially converted and fully converted, i would be happy to provide more details on how we can achieve the webi reports 100% and what are the workarounds we have used for each issue we faced in the conversion. Sap businessobjects why should i migrate from deski to. Desktop intelligence users guide reporting techniques and. Mar 17, 2015 to open an existing deski report that has been migrated to the bi 4. The samples demonstrate deski document exporting, viewing, modification, printing, and more. Business objects is an integrated query, reporting and analysis solution for business professionals that allow them to access the data in their corporate databases directly from their desktop and present and analyze this information in a business objects. Sap can call you to discuss any questions you have.
Top 20 business objects interview questions and answers pdf. Mar 21, 20 additional new features for deski users. Business objects provides a set of tools for building data warehouses very efficiently. The suite is made up of several tools that can either be purchased and used individually or together. Nov 19, 2014 the desktop intelligence compatibility pack dcp is solution that allows customers to use deski xi 3. Migration from deski to web intelligence michaels bi safari. Dear readers, these sap webi interview questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of sap webi. Web intelligence, the business intelligence reporting tool. Manage all the objects and variables in the report. Sap businessobjects why should i migrate from deski to webi. With the feature, you may alter the way to use objects brought from the universe, e. Mar 21, 2017 deski documents based on free handsql can be fully converted to webi since bi4.
Good understanding and work experience of data models such as snowflakes, star and normalized excellent dashboard designxcelsius work experience sap bw environment work experience installed businessobject on sand box for feature evaluation and comparison. Also scheduling can be done directly in webi xi r2, where as we need additional software to schedule deski reports. Deski and webi scope of features business intelligence. Sap businessobjects desktop intelligence sap help portal. Interview questions and answers free pdf download page 18 of 51 deski report when one drags the measure object with the dimension object of a particular granularity, the measure column from the fact table of the corresponding granularity is selected in. Saving the whole deski business objects report out using vb. This release includes change in naming conventions with dawn of new reporting tools and phasing out some of old ones as well. Sap business objects is a business intelligence tool that provides the combination of analysis, reporting and querying intended to find instant answers to the businessrelated questions and help management improve their decisionmaking process. Data access and analysis when the query panel appears, only the universes classes are visible. You select the location where your deski reports were previously saved and click retrieve. Public folders and categories are created by the business objects team, and can be viewed by users, depending on their security access.
Free hand sql in deski to webi has been an issue in migrations before, but now webi supports free hand sql and the conversion is painless during an upgrade. Differences between desktop intelligence and web intelligence. A free powerpoint ppt presentation displayed as a flash slide show on id. Once completed, the user can consolidate their work, and deploy a common. Web intelligence free hand sql fhsqlstored procedures. Free hand sql see note 1 below see note 1 below see note 1 below see. Free sap business objects training demo sap bo bobj training sap bo bj training sap business objects tutorials sap business objects tutorials for beginners 2017 sap bo online training. M2 overview deski data quality course ad hoc chg enh to par m2 has transitioned from 5.353 35 453 202 1160 673 664 1015 604 151 251 1503 1564 325 873 342 1257 491 1554 1465 611 1278 657 1043 1438 67 831 1301 1309 1204 1438 353 759 423 573 95 355 1088 731 131