How to write plan data into Transactional Cube from Visual Composer ?

[Former Member]

Dear experts,

Visual Composer is very powerfull to build a 'nice-looking' web-report (I think is much better than Web Application Designer in term of freely position the chart/graph/table/selection parameter in anywhere we like. We can't have this flexibility in WAD) plus it also has strong integration to R/3 for posting the transactions via RFC-Enabled Function Module (such as changing customer credit limit, approve PO, approve Sales Order, etc), so that the R/3 user won't even have to know the TrxCode.

In addition to this, I just wondering if VC also capable to write plan data into transactional cube via Write-Enable Query. We can simply insert a BW Query into VC as planning layout (set the edit-mode to "editable") plus having some Wizards to make it more user-friendly and self-explanatory for the users.

But I am not sure how to save the changes back to transactional cube from VC.

Could anyone please kindly advise how to achieve this.

"Seeing is believing" is always my learning method, so I would appreciate some "actioanable" explanation or hints.

Many thanks,

Sen

[Former Member · Accepted solution]

Hi Sen,

As far as I know, it's not possible to write data into transactional cubes directly from a table in Visual Composer through standar method, but it's possible to integrate a WAD with your input ready query into a URL element in VC (You can fill entry variables in VC and call WAD dinamically), so it's possible to create a planning application in VC calling dinamically WAD's.

Another way to interact through VC is creating button objects that calls planning sequences (with BAPI calling RSPLS_PLSEQ_EXECUTE). Also can fill variables in VC and pass them to sequence.

Regards,

Enrique

[Former Member · Accepted solution]

Hi Enrique,

Thank you very much for your great answer. I found a HowTo paper regarding integration VC <=> Web Application Designer (BEx Web template). Will give a try to prove that it is really works.

Full point is rewarded for you

Cheers,

Sen