Hi All,

This document help while linking webi report to OLAP Analysis.User can use these report for detail analysis purpose. Ex. Add new fields and apply filter on the report etc. and export the same report in different format. ex. Xls,pdf,csv.

Step 1 :Create a Webi report and Olap analysis

/wp-content/uploads/2015/05/1_707818.jpg

/wp-content/uploads/2015/05/1_707818.jpg

/wp-content/uploads/2015/05/1_707818.jpg


Step 2 : Document linking of Olap Analysis from Webi report.



/wp-content/uploads/2015/05/1_707818.jpg

/wp-content/uploads/2015/05/1_707837.png

Linking has been created for Cal month object.


/wp-content/uploads/2015/05/1_707818.jpg


Step 3: Passing Value from parent report to child

Edit the hyperlink formula and add the technical name of the Bex variable as highlighted below to pass the value of the prompt through userresponse.


/wp-content/uploads/2015/05/1_707818.jpg

/wp-content/uploads/2015/05/1_707818.jpg

Step 4: Save the report and close.

Linking of Webi to Olap Analysis is completed by passing month value.

/wp-content/uploads/2015/05/1_707818.jpg

Step 5: Run the report.

Select the required prompt value.


/wp-content/uploads/2015/05/1_707818.jpg

/wp-content/uploads/2015/05/1_707818.jpg

Step 6: To open the hyperlink report, click on the calmonth column.


/wp-content/uploads/2015/05/1_707818.jpg

Olap Analysis report get open after click on the hyperlink with parameter value JAN 2015 of parent report. 

/wp-content/uploads/2015/05/1_707818.jpg

Regards,

Anish

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply