Creating xcelsius directly on ECC
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,
Yes we can create Dashboard on top of SAP ECC tables :
BI flow is usual flow ie cube /Query
->universe>Webi ->live office->xcelsius
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.