Hi friends,
I tried connecting Xcelsius with BW(BEX query) where I succeeded to connect both system and was able to see objects coming through BEX query into Xcelsius connection defination TAB. When I go to its output values, it contains "cross-tab Data". I clicked on it and map it in excel. My BEX query has only two things one is Material (Char) and other is Amount(Key Figure). So I mapped it with two colums of excel of Xelsius and finally mapped those two colums with Spreadsheet component of Xcelsius to view the things precisely as it is coming.
But the problem is when I see the output, though it is showing the data but the header of the spreadsheet is bit scattered.As in,
it should display like:
Material.....|...Amount..|
-
Mat1..........| 5000........|
-
Mat2..........| 2000........|
But it is showing something like
Key Figures...|...Amount....|
-
Material.........................|...........................
-
Mat1..............................| 5000........|
-
Mat2..............................| 2000........|
-
Overall Result...............|..7000.......|
-
You can see the second table contains data which is really different from the format I am looking for. What could be the reason for this? Anybody can guide me..
Thanks alot!!