Introduction
I hope and assume that most of you by now are already well versed with creating a BIP Report based on SQL Data Source. In this post we would try to explain how to use Deep-Link in the “URL” properties to ensure when one clicks on data value he gets redirected to person management screen
So without further ado let’s get started.
Pre-Requisite
We have already created a BI Data Model and BI Report which we will utilise for this purpose.
The BI Data Model can be downloaded from here
The BI Report can be downloaded from here
The Report when ran will have data as shown below
One important point to note here is that for the Employee# data column we need to add a endpoint-url value for URL property which would appear as:
Here you would notice that there are 3 parameters used as breadcrumbs in the URL namely:
pEffectiveDate gets data from {/DATA_DS/G_1/CURRENT_DATE}
pAssignmentId gets data from {/DATA_DS/G_1/ASSIGNMENT_ID}
pPersonId gets data from {/DATA/G_1/PERSON_ID}
all these three attributes are part of data model and the Group Name is G_1
Also, one important point to note here is that the URL Link should be as below:
Where you would need to replace yourpod with the application login link of your pod.
With this we have completed the setup steps and should now proceed to verifying results.
Verification
We will run the report which will download an excel output as shown below:
Now if we click on any of the data-column value for Employee# it will take us to the person management screen (for this example we will click on Emp# 1014)