Skip to Content
0
Former Member
Jan 10, 2008 at 12:02 PM

Export to Excel in VC

34 Views

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