Creating xcelsius directly on ECC

[former_member200330]

Hi,

Is it possible to create an Xcelsius Dashboard directly on SAP ECC? I figured out that one way to do so is to use Crystal reports and from there using Live Office get the data into Xcelsius and create a Dashboard. Is there any other way or is that the only we can create a Dashboard on ECC or any other ways.Please help.

Also is it possible to drill down in Xcelsius Dashboard into further levels as we do in Web Intelligence? ( In Webi we can drill down from year -> Quarter -> Month) is it possible to do so in Xcelsius?

thanks in advance,

Raja.N

[Former Member · Accepted solution]

Hi Raja,

Yes we can create Dashboard on top of SAP ECC tables :

1)crystal reports

2)BI

BI flow is usual flow ie cube /Query ->universe>xcelsius

cube /Query ->universe>Webi ->live office->xcelsius

Crystal flow:

If u have 2 or more tables create a infoset and use this as a sourse for your Crystal report.

implement all you consolidation logic in infoset so that Crystal reprort can be used as a staging layer with less computations.we can create all the computations at crystal reprorts also but infosets are much efficient.

do all ur grouping and other formatings here in crystal report.

pull data from crystal reports using liveoffice into excel sheet which inturn acts as ur source for Xcelsius.

Yes it is possible to drill down in xcelsius

we can drill through charts and others..we have turnaround process also to achieve this.

WEDI drill can happen up to any level but as performence is considered it is better if we take xcelsius drill up to 1 or 2 levels.coz more drills means more data needs to be imported into sheet and that can be a performence issue again.

@Sri

[former_member200330 · Accepted solution]

Hi Sri,

Thanks for the reply.Please tell me how to drill down to further levels in Xcelsius. Thanks in advance.

[Former Member · Accepted solution]

Hi Raja,

Following link gives you how to enble drill down in xcelsius

http://www.youtube.com/watch?v=jzc2JD3P1ZA&feature=related

Workaround:

suppose ur data is like this:

DATA SET 1:

Plnt Budget for 2011 Planned Revenue Actual Revenue

1000 12097635 13549351 8129611

1011 10097635 11309351 6785611

1012 11097635 12318375 7391025

1013 12057635 13504551 6752276

1014 22007635 24648551 14789131

1015 87649087 98166977 68716884

1016 45673879 51154744 30692847

DATA SET 2:

Plnt Budget for 2011 Total Purchase Unused Budget Consumption Inventory

1000 12097635 6048818 6048818 4839054 1209764

1011 10097635 8976798 1120837 6014454 2962343

1012 11097635 10797999 299636 9718199 1079800

1013 12057635 9019111 3038524 7215289 1803822

1014 22007635 16941477 5066158 14569671 2371807

1015 87649087 41975148 45673939 20567822 21407325

1016 45673879 30807031 14866848 27418258 3388773

Take a chart and show the values budget,planned rev ,actual revenue for inividual plants

X-axis --->plants

Series1:budget 2011

series2:planned Revenue

Series3: Actual Revenue

when we select a plant from the above chart it should drill to the details like total purchase, unused budget,Consumption ,inventory

Enble drill down

select the insertion type as row

select any series out of the three available ( Budget for 2011 Planned Revenue Actual Revenue),

Source data: map the plants column from data set 1

Destination :Map that to a blank cell Sheet1!$K$1 (mark that with some color for easy identification),

Taka a combo box

Lables :map that with plant column form Dataset 2

Insertion type :filtered row

Source data : Data set 2

Destination : Take a row of six cells and map to destimation(Sheet1!$P$6:$U$7) (mark that with some color for easy identification),

goto BEHAVIOUR tab of Combobox:

Selected Type: Label

Selected Item : mapp that with Sheet2!$K$1.

Take a Score card / list view / Spread sheet table

Goto GENERAL tab:

Display data :map with (Sheet1!$P$6:$U$7)

Click preview..

@Sri

[Former Member]

Hi Raja,

You may use the SAP tab in Xcelsius SP3+ to connect and fetch data from SAP queries with a limitation that your dashboard then can be exported only to SAP EP.

The drill down functionality is available with all the chart components of Xcelsius though not exactly same for that in Webi. You can create the logic in Excel and try using it. You may also open a Webi Document for details using OpenDoc when you drill in.

Regards,

Ameet

[former_member200330]

Hi Ameet,

Thanks for the reply. How exactly can we set a formula for drilling down in excel sheets??Please help.

[Former Member]

Hi Raja,

By building the logic I mean setting the Dynamic visibility for components or other ways. Basically by using the Drill Down option in Charts you can use it as a Selector component, thereby insert a row/value or column in the destination and based on that develop your logic.

Its like using a lable menu to display the selected data.

Regards,

Ameet