Skip to Content

Unable to create visual composer table view from the Bex Query

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2010 at 02:49 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 20, 2010 at 01:10 PM

    Thank you.

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

    Regards

    Sajith

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.