Skip to Content
0
Former Member
Feb 17, 2011 at 03:05 PM

Data not coming in proper tabular format - BICS

38 Views

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!!