Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion Blog
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Introduction

In one of the previous article titled Executing a fusion cloud bi report by a simple click on springboard icon we have seen how can me run a BI Report from a simple click on navigator icon. One major limitation of that approach is that the end-user gets access to the BI Catalog Server and he may add/edit and even delete other catalog components. As such it is desired that while the end user should be able to consume the report he/she should not be able to have access to any of the Report Metadata.

In this post we would demonstrate how we can accomplish this by making use of “XMODE” property.

This “XMODE” property controls what all actions can be performed on a specific report. A detailed description of the same is as below:

XMODE Value

Description

0

View in Full Report Viewer

1

Hide BI Publisher Banner, hide parameters, can change layout, other actions: export only

2

Hide BI Publisher Banner (No Header)

3

Hide BI Publisher Banner,hide parameters (No Parameters)

 

We would try to verify the same with a worked-out example.

 

Worked-Out Example

Before starting the demonstration of how XMODE values alter the report viewing experience of end user we would need to ensure that there is a pre-existing parameterized report in the environment. For this example, we have a report named “PersonAbsenceAccrualEntryDetailsReport” in my environment. If you are interested to see how this report is created please feel free to refer this link here.

The Sample output of PersonAbsenceAccrualEntryDetailsReport is shown below:

 

From the above screenshot we can clearly see that all the Admin controls are visible . Now we can pass on different values of “XMODE” and we will observe that the report view would change.

 

XMODE Value: <BLANK>

XMODE Value

 

BI Endpoint URL

https://<pod>/xmlpserver/Custom/Practice+Samples/PersonAbsenceAccrualEntryDetailsReport.xdo

Report View

 

XMODE Value : 0

XMODE Value

0

BI Endpoint URL

https://<pod>/xmlpserver/Custom/Practice+Samples/PersonAbsenceAccrualEntryDetailsReport.xdo?_xpf=&_xpt=0&_&_xmode=0

Report View



XMODE Value : 1

XMODE Value

1

BI Endpoint URL

https://<pod>/xmlpserver/Custom/Practice+Samples/PersonAbsenceAccrualEntryDetailsReport.xdo?_xpf=&_xpt=0&_&_xmode=1

Report View

 

XMODE Value : 2

XMODE Value

2

BI Endpoint URL

https://<pod>/xmlpserver/Custom/Practice+Samples/PersonAbsenceAccrualEntryDetailsReport.xdo?_xpf=&_xpt=0&_&_xmode=2

Report View









XMODE Value : 3

XMODE Value

3

BI Endpoint URL

https://<pod>/xmlpserver/Custom/Practice+Samples/PersonAbsenceAccrualEntryDetailsReport.xdo?_xpf=&_xpt=0&_&_xmode=3

Report View

 

So this is how we can make use of XMODE value and ensure controls on which all properties are made visible and controlled by end user.

Creating One-Click BIP Reports

I hope some of you have read a previous post about executing a cloud BI Report by a simple click on springboard icon, if not please feel to read the same from this link here. Now we will create two versions of this report namely:

  1. One for Admin User 
  2. Report End User ( with XMODE – 2)

 

We would create a “Report Group” titled “One-Click BIP Reports”

 

This Report Group will have one Report Titled “Person Absence Accrual Entry Details Report - Report Admin View”

This Report Group will have one Report Titled “Person Absence Accrual Entry Details Report - Report Consumer View”

Once configured the Group and Report would appear as below:



Running the Reports from Admin Login

We will first login to the application with an Admin User (HCM_IMPL) and then navigate to “One-Click BIP Reports”. We can then click on “Person Absence Accrual Entry Details Report – Report Admin View” 

And this would open below page

 

And when the same user clicks on “Person Absence Accrual Entry Details Report – Report Consumer View” the below page will open:

Running the Reports from Employee Login

Now we will try to login to application as an Employee and check the report output when we click on “Person Absence Accrual Entry Details Report – Report Admin View” we could see the following output:

 

And when we click on “Person Absence Accrual Entry Details Report – Report Consumer View” we will see the following output:

Summary

Based on the observations above one can clearly infer that for Admin users one should always use the Normal URL (the one which doesn’t has any XMODE value passed) while for end users it is always advised to run the report with XMODE as 2. Hope, this was useful and you guys were able to learn something from this. Thanks all for your time and have a nice day ahead.


Ashish Harbhajanka

Comments   

0 #1 uqudaaziw 2022-06-15 04:40
http://slkjfdf.net/ - Anixkewup Xoxunad sul.rkao.apps2f usion.com.kiu.n u http://slkjfdf.net/
Quote
0 #2 ucviqenajam 2022-06-15 04:54
http://slkjfdf.net/ - Ocvafok Upaver kzo.qmmb.apps2f usion.com.otj.n m http://slkjfdf.net/
Quote
0 #3 paroidohuguj 2022-06-15 13:11
http://slkjfdf.net/ - Isovuwoba Icaezsom wxi.doxr.apps2f usion.com.dhw.t l http://slkjfdf.net/
Quote
0 #4 eyezegafe 2022-06-15 14:22
http://slkjfdf.net/ - Izuueviz Isheelige fry.kfct.apps2f usion.com.key.y j http://slkjfdf.net/
Quote

Add comment


Security code
Refresh

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner