Using xcelsius 2008 to build a scorecard view sap blogs. Migrating dashboards to sap businessobjects bi 4 ev. Xcelsius 2008 connectivity with sap nw bibw 7 connecting. This is a legacy system that involves using the life cycle method lcm. Migrating dashboards to sap businessobjects bi 4 ev technologies. It can be found in the sap service marketplace under xcelsius installations, and not under the patches. Make sure you download and extract out all of the files from the zip file and run the setup program from your hard drive. Jun 15, 2010 the basics of sap xcelsius software using crystal reports and sap bex in an sap bi environment. Microsoft excel xp20032007 is the only data source that can be used with xcelsius present 2008. Crystal xcelsius 2008,dashboards, universe designer qaaws creation. Issues and techniques related to scaling using charts. To give a hint of just what is possible with the xcelsius 2008 sdk below i have created a few sample xcomponents, each of which features in one or more of the xcelsius models below.
Xcelsius 2008 6 promoting qaaws queries 5 mins youtube. Information about dashboards also known as sap businessobjects dashboards, sap crystal dashboard design or xcelsius. Remove xcelsius 2008 expert guide to help you uninstall. Xcelsius 2008 is a software program developed by business objects. This post demonstrates how to apply the ideas presented in dynamic status update of check box components. Security in xcelsius 2008 using qaaws in one of our dashboard we have to implement row level as well as object level security on some of the columns. I hadnt had a chance to look at xcelsius 2008 until a week or. Query as a web service qaaws is a sap business objects bobj clientside tool that allows users to create and publish web services that can be made available over the web. Design a xcelsius dashboard, which consumes that web service. All options support bex query with bics being the best option as qaaws and biws rely on olap universe and its limitations for integrating with bex query. Worked with customized components and embedded them into xcelsius 2008 successfully by creatively bypassing technical limitations of xcelsius limited out of the box components. If the print book includes a cdrom, this content is not included within the ebook version.
Service qaaws, another sap businessobjects produce that exposes data from a. Xcelsius 2008 by business objects should i remove it. Xcelsius 2008 connectivity with sap nw bibw 7 connecting sap bi directly with xcelsius 2008. One of the cool additions introduced in xcelsius 2008 sp3 was a push button component. Xcelsius dashboards using qaaws and live office business. According to the bio on the back of the book, loren is editorinchief of xcelsius journal, the online magazine for xcelsius users. Xcelsius 2008 does not support using spreadsheets that have links to other spreadsheets or have macros in them. When importing the newly created bi web services into my dashboard this is on xcelsius 2008 sp3. The setup package generally installs about 117 files and is usually about 527. I thoroughly study the tutorials but whenever i generate the wsdl link on the qaaws and take import to it inside xcelsius it shows url unable to upload. Mar 27, 20 xcelsius 2008 5 passing prompt parameters to qaaws 8m 46s. Xcelsius 2008 refers to both xcelsius enterprise 2008 as well as sap crystal dashboard design 2008 and sap crystal presentation design 2008 the latest version of xcelsius 2008 is available to download from sap service marketplace and the sap crystal solutions downloads site make sure you download and extract out all of the files from the zip file and run the setup program from your hard drive. Xcelsius and business intelligence web services biws.
Qaaws is a business objects client tool that creates a web service, based on a query that connects directly to a universe. This video does the next step and proports the core benefits of qaaws and sees us still get the lowest level of data, but just what we. So it is a good idea to start with the empty spreadsheet that is embedded within xcelsius 2008. The definitive, comprehensive, official guide to xcelsius 2008 dashboards using xcelsius, you can create powerful, interactive dashboards, gather data from spreadsheets or databases, and deliver knowledge that can be instantly understood and acted upon.
Could you please advise me how to use qaaws in x celsius 2008. As an it professional who didnt use excel much before xcelsius, i really appreciate how loren brings his extensive knowledge of. The latest version of xcelsius 2008 is available to download from sap service marketplace and the sap crystal solutions downloads site. Using xcelsius, you can create powerful, interactive dashboards, gather data from spreadsheets or databases, and deliver knowledge that can be instantly understood and acted upon. If dashboards are a major driver of your bi and you are an existing xi 3. Use the qaaws wizard to copy the definitions to the target repository. Url and i have to use that url in my dashboard using qaaws connection. I do not have system available to check the same, but i believe flash file will throw errors on those columns and on subsequent calculations in the dashboard. Xcelsius is suitable for 32bit versions of windows xpvista7. Businessobjects xcelsius enterprise integrates with the businessobjects platform, including query as a web service qaaws or qaws, liveoffice and crystal reports. One of the features introduced in xcelsius 2008 sp3 was a dynamic series selection in charts.
As more people deploy xcelsius dashboard solutions, xcelsius connectivity options has become a hot topic and i am often asked to compare the most popular methods used by businessobjects customers which are query as a web service qaaws, live office and infoburstxds or xdm for nonboe deployments. Most of the time, autoscaling works well, but if your living is based on presentations and dashboards, you might want more finetuned control than autoscaling allows. Once these web services are created and published, they can be consumed like any other standard web service in software applications including xcelsius and crystal reports. Set security rights for objects at rowcolumn level, created custom, hierarchical list of values lovs and stored onto the repository. The basics of sap xcelsius software searchsap techtarget. A book that i have found very helpful is loren abdulezers xcelsius 2008 dashboard best practices. If you want to install the xcomponents in your version of xcelsius 2008 you will find the xlx xcelsius extension file here. Using qaaws to drive your xcelsius dashboards altek. In this book chapter excerpt, youll find an introduction to sap xcelsius 2008, a dashboard design tool that is part of the sap businessobjects suite.
Use features like bookmarks, note taking and highlighting while reading xcelsius 2008 dashboard best practices business objects press. Most people looking for xcelsius 2008 full version downloaded. Etl using oracle plsql, unix shell scripts, objects xi r3. Visual bi brings indepth expertise in servicing customers of various types.
The software is easy to handle and does not require any particular training. But should you stay with sap dashboards or move on to sap design studio. Xcelsius editions, xcelsius news, xcelsius present 2008 today, business objects, an sap company unveiled a new version of xcelsius, its called xcelsius present 2008. In xcelsius, i copied sql server folder to teradata. Enterprise business intelligence xcelsius 2008 and beyond. After installing xcelsius 2008 sp2 on the frontend and getting sap bi nw on ehp 1 sp5, i was able to get the connection working. Creating dashboards with xcelsius practical guide creating dashboards with xcelsius practical guide. Select the rows coming from the query and insert in the excel spreadsheet. Created universes on the top of sap bex queries, by using single sign on ssn. Sap crystal reports software enables you to easily design interactive reports and connect them to. In this book chapter excerpt, youll find an introduction to sap xcelsius 2008, part of the sap businessobjects suite.
Going live with xcelsius options, tricks, and tips. Qaaws is an xcelsius provided web service that gets data from a business objects universe using queries and exposes the url that can be used to fetch data at runtime from the database using the universe metadata. Hi techies, we are migrating the webi reports, universes. In addition to the xcelsius dashboard maintenance best practices using labels in excel i wanted to share other important aspects of making xcelsius dashboards easy to maintain and for other developers to understand. One such practice is having some kind of conformity in your approach to how you lay out the data for your xcelsius project. Follow the instructions on the software downloads page for. Mar 23, 2015 xcelsius 2008 refers to both xcelsius enterprise 2008 as well as sap crystal dashboard design 2008 and sap crystal presentation design 2008. Ensure that you load the correct script with the new server url assignments. If you would like to give your software a competitive edge, the xcelsius oem partner. Utilize the new interportlet communication ipc feature in dashboard builder 3.
Haris maruthullathil sap bibo consultant electronic government. The software lies within office tools, more precisely document management. Jun 11, 2009 using qaaws to drive your xcelsius dashboards keeping right in line with the other blogs that i have written about qaaws what is a qaaws and quick and dirty guide to creating a qaaws i decided to put together a quick one and a dashboard to show how to leverage your business objects universe to fuel your xcelsius dashboards. I am using xcelsius 2008 version, now want to connect it to the live data through a query as a web service. Xcelsius is the component with all the bells and whistles for dashboarding in the bobj environment. Using this software you could create the most amazing corporate information dashboards and analytical tools. This long awaited addition addresses an old request for the ability to hideshow a chart series at runtime. In this section, learn the basics of xcelsius software, and how to configure it.
Xcelsius 2008 fundamentals, xcelsius 2008 best practices and techniques, and advanced features. Xcelsius 2008 dashboard best practices business objects press kindle edition by abdulezer, loren. Crystal xcelsius dashboarding news, articles, training. With xcelsius 2008, we have alerts for selectors, so i am using this feature coupled with ignore end blanks to create a scalable list of icons without having to manually drag and drop a bunch of icon components. Define a data connection in xcelsius that refreshes on load and every, say 2 seconds after. Xcelsius 2008, a software developed by business objects, often gets into your computer via webpage browse or some freewares installation.
Using xcelsius 2008 to communicate with web intelligence and. How to use universe row level restriction using qaaws in xcelsius 2008. Sap bo xcelsius developer resume hire it people we get. If you have not yet moved on from xcelsius 2008, you should probably do so. Mar 27, 20 these videos are intended to give developers with prior knowledge of microsoft excel a full understanding of the core processes of creating a fully functioning, connected sap xcelsius dashboard. Xcelsius 2008 and sap netweaver bw connection business.
Keeping right in line with the other blogs that i have written about qaaws what is a qaaws and quick and dirty guide to creating a qaaws i decided to put together a quick one and a dashboard to show how to leverage your business objects universe to fuel your xcelsius dashboards. Now, with just a click of a button, you can copy push not only a single cell value, but multiple values in the contiguous range of cells to the destination range of the same size. The web service used to create this converter is free and can be found at click on the image to load the converter. Enterprise business intelligence xcelsius 2008 and beyond jeffrey strauss bi architect nick knol software engineer 3 rd quarter 2008. Creating dashboards with xcelsius practical guide bonn boston. Live currency converter using xcelsius and web services.
Using sap netwear bw connection to connect the sap bex queries into getting the data from xcelsius dashboards. Considering the past solution with qaaws on a bobj universe which is built on a sap bi query, i was expecting a lot from the direct connection. Select qaaws connection and import the query created in qaaws. Developed both static and dynamic dashboards like trend analysis, alerts, drill downs and charts like line charts, area charts and column charts, using xcelsius 2008. I had used excel sheet to create a dashboard in xcelsius 4. Xcelsius 2008 dashboard best practices business objects press enter your mobile number or email address below and well send you a link to download the free kindle app.
The most popular versions among the software users are 12. Download it once and read it on your kindle device, pc, phones or tablets. The book contains 16 chapters organized into three sections. Using xcelsius 2008 to communicate with web intelligence. Now we can connect to this universe that we created on bw data to xcelsius 2008 through one of the following two techniques. I personally have taken to recreating most of them from scratch. The basics of sap xcelsius software using crystal reports and sap bex in an sap bi environment.
As anyone who has been involved in developing xcelsius dashboards connected. Xcelsius and business intelligence web services biws part 2 says. My qaaws is pointing to sql server universe and say has wsdl url as aaa. Xcelsius 2008 is a visualization tool for creating interactive visual. Worked on generating wsdls by using qaaws based on the existing universes. Use spreadsheet table component and bind it with excel cell range where the rows are inserted from qaaws. Want to convert currency using live data feeds, here it is, a live currency converter using a web service. Despite numerous changes to the technological landscape, sap dashboards formerly known as xcelsius continues to be the preferred dashboarding tool of choice for many enterprises. Xcelsius developer resume profile hire it people we.
Take a look at the features of xcelsius and find out if this software meets your business needs. Creating xcelsius dashboards on bw infocubes xcelsius 2008. Im using sap dashboard design 6 and i need to update the. For non bw data we will need businessobjects enterprise in place with qaaws, lo or biws as bics with xcelsius supports only bex query data. The dashboards you see on this page are created by crystal xcelsius team as examples for people who want to try xcelsius. If you would like to give your software a competitive edge, the xcelsius oem partner program can be tailored to match your needs. Also you will find dashboards from some of the best xcelsius dashboarding consultants like analysis factory and bright point inc. Download the latest version of xcelsius free in english on. There are three different access in general methods using which xcelsius. Sap bo xcelsius developer resume hire it people we get it. Oct 18, 2010 businessobjects xcelsius enterprise has all of the features of xcelsius engage. For people who get easily intimidated by a lot of editions of the same software, dont worry, xcelsius present is same as xcelsius engage 2008 but with limited features. Ray li and evan delodder creating dashboards with xcelsius practical guide bonn boston 5771 db 3 8610 11.
For more information, please contact a sales representative. Using the empty spreadsheet will also reduce the risk that you use microsoft excel functions or plugins that xcelsius 2008 does not support. Xcelsius 2008 and business objects enterprise xi 3. While the xcelsius web part does show up in windows addremove software, i cant locate it when trying to add it as a web part on a sharepoint page.
To safely remove the program, the wrong way is to locate its folder, rightclick it and select delete, while quite a number of people are still doing this. How to migrate and upgrade dashboards based on qaaws. Part ii xcelsius 2008 best practices and techniques. Going live with xcelsius options, tricks, and tips jackson whitfield. This relieves you of the burden and drudgery of manually setting a chart scale.
I have found that you may need to modify some of the elements after your model has been upgraded. Then you can start reading kindle books on your smartphone, tablet, or computer no kindle device required. This means that to use boe xi 3 qaaws with xcelsius 2008, you must download the boe xi 3 businessobject client from the business objects support site and install it on your client machine. To install qaaws download the boe xi 3 businessobjects client. Office tools downloads xcelsius by sap and many more programs are available for instant and free download.
Xcelsius 2008 dashboard best practices business objects. Qaaws are using the olap bapi interface which is known. Xcelsius 2008 definitely has a lot of issues that will greatly annoy a seasoned xcelsius 4. I did note that the behavior does not occur when using qaaws, so that was the. Mar 26, 2008 the second item is a label based menu that is situated in the upper left most corner of the panel container component. In addition, it offers integration capabilities with web portals and reporting services. Using an xml file to retrieve the web services url. Simply open up your xcelsius 2008 xlf source file inside of dashboards and save as using the dashboards tool remember to always backup. Xcelsius 2008 tips everything xcelsius the xcelsius.
With xcelsius various output formats, users can save created files either as macromedia flash swf files, html, powerpoint, pdf, microsoft outlook, microsoft word or businessobjects enterprise. Xcelsius 2008 5 passing prompt parameters to qaaws 8m 46s. Ive spent a lot of time in 2008 and 2009 creating xcelsius dashboards for various clients. Features and functionality of sap xcelsius 2008 searchsap.
171 1264 17 906 1295 1280 743 1157 224 330 637 187 495 1459 506 1486 701 620 1148 1236 1534 346 190 142 404 659 603 320 447 304 1024 1097 834 364 1475 65 914 281 254 820 1383 1320 630 1391 420 304 1151