In this post jim brogden, a bi consultant from daugherty business solutions explains how to refresh, open and pass variables to web intelligence from xcelsius in a businessobjects 3. Xcelsius sdk everything xcelsius the xcelsius gurus network. Now create a child web intelligence report using efashion universe. I attended the sap sapphire event last may and spent time in the business objects lab.
Please see below the snapshot of the query of webi report. This license permits end users to view live refreshable xcelsius analytic models. I am passing one webi report in xcelsius url button component. 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. If the users would like to print one of the dashboards, crystal reports will be called via opendocument. Instead of installing a complete office application or even a large plugin, o3 intended to install a tiny plugin to the microsoft office system.
Handling session management and other issues in url. If you are unsure of your account information, contact your system. Refresh, open, and pass variables to web intelligence from. We spend countless hours researching various file formats and software that can open, convert, create or otherwise work with those files. Business objects 4 opendocument url not working with. Im looking for someone to create an xcelsius 2level dashboard with two filters, using excel. The software lies within office tools, more precisely document management. Jun 07, 2010 for example, you can combine this with report variables on a webintelligence report to pass data from the report as a prompt value to opendocument. Sap businessobjects explorer and xcelsius end of life doesnt. Since we need to pass the selected values of year and state from dashboard to web intelligence report, it needs to have optional prompts for year and state. The remote report has to have the prompts set up to receive and process incoming calls from declarative opendocument url calls. For example, you can combine this with report variables on a webintelligence report to pass data from the report as a prompt value to opendocument. Use excel to open or save a worksheet in the opendocument. Modify the url of the web services modify the url of the embedded opendocument calls modify the.
I only require someone to complete the excel import file and ensure the dashboard performs as desired. Navigate from xcelsius to a web intelligence document and. Yes it can be achieved via using open document link. Viewing documents using opendocument sap businessobjects. I have a xcelsius dashboard with a url link button to open a webi report. Passing parameters between sap xcelsius dashboards. Information about dashboards also known as sap businessobjects dashboards, sap crystal dashboard design or xcelsius. Jun 15, 2010 the basics of sap xcelsius software using crystal reports and sap bex in an sap bi environment. Crystal xcelsius best practices and workflows for building enterpri. Hello, i am new to the forum but not to business objects xcelsius. But when i use the link in xcelsius, via a url component, i get the following message. Celogontoken is a variable that stores the session token generated by boe business objects enterprise generates when a user successfully logs in.
Opendocument format is ready to help your documents stand the test of time. Dashboards objects formerly xcelsius 2 basics of the sap businessobjects opendocument call. Drilling down from dashboard to web intelligence report. This software and documentation is commercial computer software under federal acquisition. Crystal xcelsius dashboarding news, articles, training. Crystal xcelsius provides interactive visual analytics to present data through powerpoint, pdf, outlook. Download opendocument software free software foundation. Xcelsius widget best practices for bi desktop sap blogs. Creating dashboards using web intelligence solid ground. Navigate from xcelsius to a web intelligence document and pass parameters.
Sap ariba recommends a fivepart strategy to effectively and efficiently respond to global supply chain disruption, with special offers, software, and services for supplier discovery, supplier risk management, and supply chain collaboration. Crystal reports passing parameter values from xcelsius to webi. Embedding an xcelsius visualization in a web intelligence. The opendocument format is supported by free software applications such as, abiword and koffice. 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. While there are many parameters for this opendocument syntax, we will show you the.
According to the bio on the back of the book, loren is editorinchief of xcelsius journal, the online magazine for xcelsius users. Xcelsius tips and tricks for your enterprise slideshare. This is an overview of software support for the opendocument format, an open document file. The most popular versions among the software users are 12. Build your xcelsius dashboard to include the visualization of your choice gauge chart in this example 1 create the xcelsius dashboard as in the picture above. How to pass bex prompt variable using opendocument url in web intelligence. When you install an xcelsius 2008 service pack or an xcelsius 2008 fix pack run the installer as an administrator. The software is easy to handle and does not require any particular training. These dashboards receive data from sap bex queries. Absolute hyperlinks in web intelligence below is a list of some of the different types of hyperlinks that can be used to open web intelligence reports. Xcelsiusxcelsius portal communication portal connectors dashboard swf opendoc.
Sap software solutions business applications and technology. Business intelligence platform administrator guide crystal reports. About hexaware technologies introduction to xcelsius dashboards dashboard samples for various data sources. Crystal xcelsius is the a software for visual analytics and business intelligence dashboards, currently known as sap dashboard design crystal xcelsius. Before sending a file to someone else, you might want to close the file and open it again to see what it looks like in the opendocument spreadsheet. I recently starting moving my businessobjects enterprise xcelsius models from xir2 to xi 3. Intelligence, xcelsius, and other business objects products and services mentioned. Im able to pass on the flash variables via the dynamically generated html. How to bypass opendocument login screen david lais.
A book that i have found very helpful is loren abdulezers xcelsius 2008 dashboard best practices. The architecture in xi r2 had previously required a url similar to the following. Xcelsius consumes this session token using celogontoken. Opendocument is the native storage format of the latest versions of, staroffice, and kde koffice, and is supported by many other applications. It also works fine when i try to connect from one webi report to another so far so good. Filed under crystal reports, opendocument, xcelsius 4 comments i experienced some frustations when trying to open 2 different reports crystal reports and webi, however both were built on same universe and used same objects, from the same url button in xcelsius. Mar 29, 2010 download opendocument software by matt lee contributions published on mar 29, 2010 03. Quickly create desktop widgets from webi report parts and xcelsius files. May 11, 2012 information for xcelsius and liveoffice users. Refresh of data in xcelsius from web intelligence results. Download the latest version of xcelsius free in english on.
Xcelsius is suitable for 32bit versions of windows xpvista7. Use token code generated on software hardware token token code. How to integrate bo reports into crm web ui by using. Go to the properties of the excel document and copy the id of the sheet. We recommend to completely uninstall the current versions of xcelsius and liveoffice and to install the new versions using the installation packages available here. It has been renamed to sap dashboard design formerly crystal xcelsius engage and sap presentation design formerly known as crystal xcelsius present. Open latest instance of webi report using opendocument. Hard tokencode is the code displayed on the hard token physical device, whereas soft tokencode can be generated by entering the pin on the soft token application.
I chose another way for rendering xcelsius dashboards, where i managed to create a web application in. Sap businessobjects enterprise software inventory tool users guide. Drilling down from dashboard to web intelligence report sap. Handling session management and other issues in url reporting. Viewing documents using opendocument sap help portal. Jul 26, 2005 xcelsius is the perfect tool for quickly and easily creating executive dashboards and scorecards, dynamic charts and graphs, business reporting presentations, pro forma budget models, business and investment calculators, project management graphs, interactive powerpoint presentations, compelling web site tools, and much more. Sap businessobjects bi widgets user guide sap help portal. Page 1 crystal xcelsius best practices and workflows for building enterprise soluti. This allows you to drillthrough from a summary report to a detail report. The calling hyperlink, report or program has to set up the url and set the values for the prompts. Passing parameters between sap xcelsius dashboards may 2, 20 may 3, 20 kb business objects, sap business objects tutorials how to pass bex variable parameters values to an sap xcelsius dashboard. You can do similar things from xcelsius, the businessobjects sdk, or external software programs. Certain characters are not interpreted correctly in the url. Advanced opendocument parameters altek solutions blog.
The sdk offers a great deal of flexibility and essentially gives developers a blank canvas to start from. This toolset really takes the whole dashboarding process to another level. I have found that you may need to modify some of the elements after your model has been upgraded. All, i have open document that behaves correctly when i copy and paste it into address bar of a browser. When the webi report is opened, i want to pass a few parameters from the xcelsius excel model to the webi and have it run on those values. We want to call 2nd swf from the first swf and we are using excel as our source so i think i cant use opendocument and other stuff. Join the openoffice revolution, the free office productivity suite with over 290 million trusted downloads. When ever an xcelsius dashboard is invoked from boeinfoview the session token is passed to the dashboard from boe by default. Mar 23, 2015 xcelsius 2008 service pack 5 supports windows 7 and office 2010 32bit, see the supported platforms for more details. Xcelsius provides rich visualization graphics to create dashboards right from senior management to power users and regular business users in an organization. Customizing bi launch pad and opendocument logon entry points. Clicking on a sales order or invoice to launch an ecc transaction and view or change that order or invoice while viewing the report is an added value feature that you can impress your customers with relatively little effort. Crystal xcelsius professional free trial download tucows.
I repeatedly opend the swf from boe and made particular note in the system to the url that the system was using to call the swl. Opendocument syntax and its parameters allow you to construct urls that link to these documents. In this post luca spinelli and ivan aguilar from clearpeaks indroduce us to the new export to excel solution for xcelsius using the apache tomcat jsp server. The bi platform software installed, configured, and running on one or more machines installation. How to increase data democracy with sap businessobjects. Hi, i went through ryan goodmans blog and went through this thread but didnt find the solution that i am looking for.
The same jsp can be used to open a crystal report as well. The xcelsius sdk as it stands today is a set of core functionality that provides developers with the ability to inject virtually any type of flex application or component into the xcelsius designer. Ive spent a lot of time in 2008 and 2009 creating xcelsius dashboards for various clients. How to call bex web applications from sap businessobjects. Web service clients like analysisoffice, xcelsius etc that uses web services. Opendocument \web\opendoc to get the code to take, i had to stop the tomcat service, delete the boe folder under the.
We help our clients improve analysis, reporting and planning at all levels of the organization through consulting services, software and education. So regardless of which version of saps analytics software your organization uses, xcelsius also known as dashboards and explorer will stop. Xcelsius editions, xcelsius news, xcelsius present 2008 today, business objects, an sap company unveiled a new version of xcelsius, its called xcelsius present 2008. The opendocument syntax and its parameters allow you to construct urls that. Click more to access the full version on sap one support launchpad login required. Customize your xcelsius dashboard with export2excel solution. Accessing sap hierarchies in webi with opendocument and. Xcelsius is the component with all the bells and whistles for dashboarding in the bobj environment. The dashboards itself are saved in the bw system so they are not in the boe server. How to create hyperlinks from sap web intelligence to sap ecc. Business objects xcelsius enterprise interactive viewing is a license that permits end users to view refreshable xcelsius enterprise analytic models based on enterprise data. An ebook reader can be a software application for use on a.
Publishing sap xcelsius dashboard without login tutorialspoint. The opendocument format odf is a format for electronic office documents, such as spreadsheets, charts, presentations and wordprocessing documents. If this is a crystal report, for example, then the report is rendered to the user in a default sap crystal reports viewer. When you are opening your xcelsius from infoview and want to use jump functionality to a web intelligence document you can use the outofthebox jsp called opendocument. If you use the sap hana appliance software, you can analyze sap hana. Passing parameters between sap xcelsius dashboards may 2, 20 may 3, 20 kb business objects, sap business objects tutorials how to pass bex variable parameters values to an sap xcelsius. If you have been searching for an export to excel solution for xcelsius using the apache tomcat jsp server, look no further. Openopenoffice was developed by phasen, a free and open source software plugin to enable microsoft office to read and write opendocument files and any other formats supported by. This however has been contested as the isoiec 26300 specification states that the semantics and the syntax is dependant on the used.
In order to work with the latest versions of xcelsius and liveoffice, you will have to install new software on your local pcs. These hyperlinks can be incorporated into the actual web intelligence reports themselves linking between reports, inserted into infoview as a hyperlink object or used externally. These include field names, screen titles, pushbuttons labels, menu names, menu paths. Select the excel sheet and save it on the repository. We have dashboards xcelsius which are published in our companies portal. To compare the excel format of the file with the opendocument spreadsheet format of the file, first save the file in the excel format, then open both the excel version and the opendocument spreadsheet version and visually inspect. Sap business objects dashboards xcelsius crystal xcelsius is the a software for visual analytics and business intelligence dashboards. Office tools downloads xcelsius by sap and many more programs are available for instant and free download.
Apr 07, 2012 almost every project i go to, this feature becomes the most attractive feature of the web intelligence reports we create for our customers. Bi launch pad workspaces dashboard design objects formerly xcelsius some of the. Altek solutions is a leading provider of endtoend business intelligence and data management solutions. Typographic conventions type style description example text words or characters quoted from the screen.
671 622 492 328 865 963 403 260 748 722 1082 1089 145 1183 794 802 861 574 1489 1200 289 1596 1314 1035 163 1323 1113 703 550 1048 280 670 1398 213