Skip to Content
0
Former Member
Jun 22, 2009 at 12:59 PM

bex output format

77 Views

hi all,

i have got liquidity item char.(in a structure) for which i need to find the amount k.f. related to 3 different cubes. All the cubes are having the same kf amount. the user wants to find out what is the amnt for each cubes. so, i have 3 restricted kf each restrcited with each infoprov.when i excute the query in BEX analyzer, the values are displayed in this fashion. i am using a multiprovider over 3 cubes.

cube 1 cube 2 cube 3

fiscyr/period 002/ 09 003/09

cash 1000 2000

2000 3000

the k.f for the same liquidity item for the same period are getting displayed in two different rows. Whereas they want in the same row like this:

cube 1 cube 2

cash 1000 2000 2000 30000.

so how do it in bex analyzer? give me in details how to go about?

Edited by: jumboash on Jun 22, 2009 3:06 PM