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:
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 : 0
XMODE Value : 1
XMODE Value : 2
XMODE Value : 3
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:
- One for Admin User
- 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.
Comments
RSS feed for comments to this post