cancel
Showing results for 
Search instead for 
Did you mean: 

How to link reports in web intelligence

Former Member
0 Kudos

I have a requirement of linking web intelligence reports, when i click a column of a report it should automatically go to detail report related to the column.

Regards

Aflal

Accepted Solutions (1)

Accepted Solutions (1)

amrsalem1983
Active Contributor
0 Kudos

[http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_opendocument_en.pdf]

open document api

good luck

Former Member
0 Kudos

Dear salem,

How can i see a detail view of catagorization report when i click the report, how can i link it.

Now the categorization report of a element is static.

Regards

aflal

amrsalem1983
Active Contributor
0 Kudos

i couldnt understand your question

what do you want to do exactly?

Former Member
0 Kudos

Hi,

My requirement is i have created a report, it contains summary data, when the user clicks the particular report column or link ( Province) it should go to a detail report that is relevant the particular link i clicked , its not a drill down but its kind of a report linking. how can i achieve that. please help.

Regards

Aflal

amrsalem1983
Active Contributor
0 Kudos

this is doable using the open document api i've sent you the link before

you will need to build a nother report (details report) and you will have the open document api applied for one column

and make this column be red as Hyperlink

so when you click the hyperlink the opendoc api will open the details report for you.

good luck

Amr

Former Member
0 Kudos

Dear Amr,

As per the user guide it says for deployment of open document to refer "business objects enterprise web application deployment guide" i cant find this document please help, futhermore if you tel me the steps involve in open document deployment it will help me

Regards

aflal

amrsalem1983
Active Contributor
0 Kudos

ok

i will tell you the most simple way to link webi reports

lets assume you have report A and report B

and report A is the master report and Report B is the details report

go to infoview, click prefrences , go to web intelligence section

and select

Select a default view format : Interactive

click ok

go to your report A, and open it in the view mode dont edit it.

right click the column you want to put a link on it

and select Hyperlink->new

select "browse" and find the details report B

if you will follow the procedure , you will be able to do it correctly.

good luck

Amr

Former Member
0 Kudos

Dear amr,

Its working I linked the report, but when i linked the report i should be able to filter the data according to the row or column i select rather then linking the entire report.

is it possible if i can do that it will be great.

Regards

Aflal

amrsalem1983
Active Contributor
0 Kudos

for sure you can do it,

in the detail report B, try to put a query filter as

lets say

CountryID = prompt the user to enter the country id

and try to do the same thing again, when you select the details report B, it will show you all the prompts and you can select which field or object to pass it to this prompt,

good luck

Amr

Former Member
0 Kudos

Dear amr,

Thank you so much for your help, is there is any document regarding report linking, when i use query filter it actually filters my report b , so i cant see any data there, i should maintain the report B as it is and link both report as you mentioned.

Regards

aflal

amrsalem1983
Active Contributor
0 Kudos

have a look here

[;

Former Member
0 Kudos

Thanks i am checking if this will serve my purpose,

Regards

Aflal

Former Member
0 Kudos

Hi,

When i put a query filter on report b as you said it doesnt show the particular querry, when i am selecting a report part to add a hyperlink . why is that please help.

Regards

aflal

Former Member
0 Kudos

Thanks..

Answers (0)