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