Create Report using Webservices

Vikram Srinivasan-26555

Summary

Create Report using Webservices

Content

Dear Team,

Apologies for my ignorance.

I am an ADF developer working with fusion integration's.I have used Bi Report webservices(ExternalReportWSSService) to Run Report through webservices in ADF and able to view the Output!

Now I have an requirement to Create Report in Oracle BI publisher where the same ExternalReportWSSService Provides me a method CreateReport with below parameters

<v2:createReport>

<v2:reportName>?</v2:reportName>

<v2:folderAbsolutePathURL>?</v2:folderAbsolutePathURL>

<v2:dataModelURL>?</v2:dataModelURL>

<v2:templateFileName>?</v2:templateFileName>

<v2:templateData>cid:249928210822</v2:templateData>

<v2:XLIFFFileName>?</v2:XLIFFFileName>

<v2:XLIFFData>cid:1421942907369</v2:XLIFFData>

</v2:createReport>

I just need to Know how data model can be created in Bi Report to achieve my Requirement. (if Possible Steps to create Data model where it accepts Data from Webserice XliffData)

and any XLIFFDATA Template/samples

for Ex:I just want to Create a Bi Report of showing a Empno and Empname

1)is it possible to create report through webservice(hopefully yes from above Webservies)

2)how data model can be created to achieve my requirement?

3)how Xliffdata should be framed?

Thanks in Advance

Vikram

Dir_Pal

is the same webservice data ur using or different

Carlos Carvalho

Hello,

1 - Are you saying you want an XLIFF file (to have a sample) ?

I attach one, but you can download one yourself from BIP - edit a report from catalog, click properties and there will be a button option to download the XLIFF for that particular report:

2 - not sure if understand you're question: XLIFF does not provide data to show in report, it provides translation to your report tags.

Regards,

Carlos

Carlos Carvalho

Hello,

1-Its possible to create 'Report' with BIP api.

2-DataModel is not created in thirdParty app. It has to exist in Oracle BIP.

The value you pass in that parameter is the DataModelURL (link) as per documentation:https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/reportservice.htm#BIPDV335

3-xliffData is a byteArray which you should encode in Base64.

Regards,

Carlos

Vikram Srinivasan-26555

Tx for Response

1)Can you just put a sample of Xliff data before converting it into bytearray

I know Xliff should be converted to byte array but i am not able to sense how the xliff data file should be.

2)And also I know data model should be created in Oracle BI but what kind of data model and data sets it should be created so it doesnt refer to fusion tables and instead it refers to my xliff data that will be passed from webservices

Thanks

Vikram

Carlos Carvalho

Hello Vikram,

Sorry but now it is i who totally misunderstood you (it´s Monday morning ).

Is there a question/doubt there?

Can you be more detailed, pls.

Regards,

Carlos

Vikram Srinivasan-26555

Dear ​,

Thanks, I Totally misunderstood as I Lack the knowledge of BI and Found the functionality of XLIFF by above pt 2 You referred

So I want to Map the Data source/Set to my Database/ADF page thats the Functionality I Required

Thanks

Vikram

Carlos Carvalho

Hello,

Does any of these documents:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=263370508665188&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id…

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=263270906513225&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id…

answer your question?

Regards,

Carlos

Vikram Srinivasan-26555

Hi I want to Create a Report in ADF where the Source data will be from dbcs .Is there anyway i can map dbcs tables in Oracle BI publisher ??

Thanks

Vikram