Tuesday, November 10, 2009

XM - Sample 16

This visualization shows how to control two components with one drop down box. There are many methods of doing this, however it again depends on your data.
In the below example, both the Consultant and the Manager's data is in one table.
Source file is also available for a scenario like how to dynamically display Pie chart if the Manager's data is in a different table.



To view the thread, visit: SCN - Xcelsius Forum
You can download source file here and XM Sample 16.1

Thursday, October 22, 2009

XM - Sample 15 (How to display previous years data with the current year selection)

This visualization display previous years data based on the current selected year, using a combo box with filtered rows option.
*Here combo box is hidden behind the chart



To view the thread, visit: SCN - Xcelsius Forum
You can download source file here

Thursday, September 10, 2009

XM - Sample 14 (How to display chart with fixed min value along with auto-scale)

Chart usually picks up Min and Max of the values (data) when it is set to auto scale, and if you define fixed values i.e. Min = zero and Max...you will not have the feature of auto scale. There is a simple workaround, to have both min value (zero) and auto scale option...



To view the thread, visit: SCN - Xcelsius Forum
You can download source file here

Tuesday, September 1, 2009

XM - Sample 12 (How to display legend in multiple rows in a chart)

There is no option to display legend in multiple rows in a chart, however there is a simple workaround to achieve this...



To view the thread, visit: SCN - Xcelsius Forum
You can download source file here

Monday, August 24, 2009

XM - Sample 11 (Drill Down in Stacked column chart)

This visualization shows the drill down feature in the Stacked column chart...



To view the thread, visit: SCN - Xcelsius Forum
You can download source file here

Monday, August 17, 2009

XM - Sample 10 (Show All option using Filtered Rows)

This dasboard gives users the ability to view the ENTIRE LIST ( much like the Filter property in Excel- "Show All") or a combination of various stages.



To view the thread, visit: SCN - Xcelsius Forum
You can download source file here

Wednesday, July 22, 2009

SAP Mentor Monday Webinar Ingo Hilgefort: Hands-On Xcelsius for SAP

You shouldn't miss this session!!
https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/15131

What functions will the integration provide?
  • A new Xcelsius direct connector to BEx queries and views
  • Support for SAP lifecycle transport mechanism
  • Support for text translation
  • Xcelsius Dashboards accessed via NW Portal BEx iView using standard SAP credentials
  • An solution independent from BusinessObjects Enterprise

Monday, July 20, 2009

XM - Sample 9 (Filtering multiple rows using Calendar component)

Filtering multiple row using a calendar component (it does not have a filtered rows option)...
Data:
Date Material StockExpiry
1-Jul-09 M001 1324
1-Jul-09 M002 892
2-Jul-09 M001 1562
2-Jul-09 M002 1893
2-Jul-09 M003 1387
3-Jul-09 M002 2333
3-Jul-09 M003 2721
4-Jul-09 M001 992

P.S. You can use the same logic for all the components that does not have a filtered rows option in insertion type...
To view the thread, visit: SCN - Xcelsius Forum
You can download source file here

Saturday, July 18, 2009

XM - Sample 8 (Change the sequence of legend in Stacked chart)

There is no option to change the sequence of the legend displayed in the Stacked chart, however there is a workaround for that... ;)
Sequence in bar is A (bottom), B (middle), C (top)
Legend ususally shows it the other way around A (top), B (middle), C (bottom)




To view the thread, visit: SCN - Xcelsius Forum
You can download source file here

Friday, July 17, 2009

XM - Sample 7 (Customizing mouse over values)

This simple visualization displays customized mouse over values in a bar chart.


To view the thread, visit: SCN - Xcelsius Forum
You can download source file here

Thursday, July 16, 2009

XM-Sample 6 - Dynamic visibility

This visualization displays Roles by Project using Combo box with filtered rows. It dynamically displays the Stacked chart with different colors for different roles.

To view the thread, visit: SCN-Xcelsius Forum (thread 1), SCN-Xcelsius Forum (thread 2)
You can download source file here

Wednesday, July 8, 2009

Filter multiple rows using Flitered rows property

This visalization shows how to filter multiple rows, here i want to filter data based on the Plant and Year, however if i use Filter component i can get only 1 row in the destination....so here i used 2 Combo Box components with filtered rows as insertion type...

Data:
Plant, Year, Matrerial ,Expiry Stock
Plant A, 2007, Mat 001, 1324
Plant B, 2007, Mat 001, 892
Plant A, 2007, Mat 002, 1562
Plant B, 2008, Mat 001, 1893
Plant A, 2008, Mat 001, 1387
Plant B, 2008,Mat 002, 2333
Plant A, 2008, Mat 002, 2721
Plant B, 2009, Mat 001, 992
Plant A, 2009, Mat 001, 1452
Plant C, 2009, Mat 001, 1734
Plant A, 2009, Mat 002, 2276
Plant C, 2009, Mat 002, 1888



To view the thread, visit: SCN -Xcelsius Forum
You can download the source file from here

Monday, July 6, 2009

Drill down using Pie Chart

This dashboard displays drill down features using pie charts.


To view the thread, visit: SCN-Xcelsius Forum
You can download the source from here

XM - Sample 2 - Pop up with a URL button

This dashboard gives user (click Report 1) an option, asking if they wish to continue to run the report with a message saying “This report will take at least 1 minute to run…”, user can then decide if they wish to run the report by clicking Run Report 1 (this opens a url…you can have your Webi report or link to other dashboard), or close it without running the report.


To view the thread, visit: SCN - Xcelsius Forum
You can download the source file here

SAP BusinessObjects User Conference 2009

The SAP BusinessObjects User Conference is the only face-to-face event in 2009 for members of the BusinessObjects ecosystem working in any data environment, SAP or non-SAP. With content chosen by fellow customers, the event features first-hand insights, networking opportunities, and the chance to influence the product roadmap.

You can register for the event here.

Thursday, July 2, 2009

Drill down in Xcelsius using charts

This visualization show drill down features using charts...
Select Revenue from the drop down list
Chart 1: National sales manager can view how zone's under him/her are doing in terms of sales volume for 2007 and 08...user can drill down by clicking the Zone A -2007 (drill down)
Chart 2: This shows how Regions under Zone A performed for the year 2007, user can further drill down by clicking Region 1 for Corn.
Chart 3: This shows sales of all the territories under Region 1.
You can click Back anytime you wish to return to the previous chart.



You can download source file here