Unable to create visual composer table view from the Bex Query

[sajith_p]

Hi

I am trying to create the visual composer lay out from a Bex query. The Bex query contains a set of Key figures and a structure.

These key figure and structure combination is forming a table in the query output. Key figure parameters are coming as rows and Structure parameters are coming as columns.

example query out put:

Total, HPC, FDS excel ICe etc are as Structure elements and coming as columns in query out put and

Invoice value, Gross sale value, Efficient operations etc are as Key figure elements in query and coming as rows in query out put.

But if I map this query to visual composer table view all these are coming as columns as given below.

Total Invoice value , Total Gross sale value, Total Efficient operations, HPC Invoice vale,.........

And if execute the query will giving the out put in single row.

Can anybody help me out to map this in the row column format?

Is it really possible to do in VC?

I am using CE 7.2. The VC model I need to be embedding in BPM.

Please help me to solve this issue. I completely stuck up this issue.

Regards

Sajith P

Edited by: Sajith P on Aug 17, 2010 3:07 PM

Edited by: Sajith P on Aug 17, 2010 3:15 PM

[sajith_p]

Thank you.

This will work but this metthod cannot use in my scenario.

Regards

Sajith

[Former Member]

Hi,

Try to use some function module which will convert query data into flat tables. (eg., RS_VC_GET_QUERY_VIEW_DATA_FLAT).

Hope this solves your issue.

Regards,

Vinay