Export to Excel in VC

[Former Member]

Hi,

As given in the "How to export data from VC" pdf guide, we have options like, Copying to clip board, Export to csv, Export to excel. etcs..

My requirement is Export to excel. I followed the steps given in the pdf, created a data store and replaced the name of the data store in the formula,

"pcd!3aportal_content!2fcom.sap.pct!2fplatform_a

dd_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.b

ex?QUERY=" & STORE@REPTNAME &

"&BI_COMMAND_1-

BI_COMMAND_TYPE=EXPORT&BI_COMMAND

1-EXPORTFORMAT=XLS&BI_COMMAND_1-

null="

But, on deploying i'm getting the error. "Deployment failed. stopped due to errors. Consult Log file for details"..

Also, in the pdf, below the formula i see a note "This URL is for the Web Analyzer PCD Location if Visual Composer is on the same server as BI-JAVA. If it is not, see the section on Mapping External BI locations."

In my case VC and BI-JAVA are in the different server. Should i use a different url in this formula? If so, then,from where can i get?

How to map remote url iView of BI-JAVA system(Mapping External BI Locations)?

Thanks & Regards,

Hemalatha

[Former Member]

Hi,

Please go through these threads:

/thread/394674 [original link is broken]

Hope this helps....

Regards,

Mona