Categories
- All Categories
- Oracle Analytics Learning Hub
- 26 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 234 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to drilldown from summary analysis to detailed analysis using deeplink
Hello everyone,
I hope I find answer of my question here.
I have this case:
I'm using Oracle OTBI tool to build two related Analysis
of AR Receipts Status
First Anaylsis is just a small table viewing the status of receipts:
Applied
Reversal user error
Stopped payment
Unapplied

my target is, once the end-user click on any status of the above, the system should derive him to the second Analysis which contain all details about the chosen status
for example: if end-user clicks on 'Unapplied' receipt status in the 1st analysis, then the system open new page (2nd analysis) displays only the 'Unapplied' receipts Number, Date, Amount, Maturity Date, Comment, Customer Name, etc...
same example if the end user clicks on 'Applied' status, the system shoud derive him to detailed analysis and displays only the 'Applied' receipts in details, and so on.

I searched, and I found this topic talking about deeplink: Click Here.
as per my understanding I can use deeplink to hyperlink the receipt status in 1st analysis and passing the prompt (Unapplied, Applied, or whatever) to the 2nd analysis to show only the prompt ones.
My question is: Is it possible?, is this the proper method to do this requirement or we have another method than deeplink?
I have failed to create a correct deeplink because i have no idea about syntax.
Deeplink example:
For shared analyses://<hostname>/fscmUI/faces/deeplink?objType=@{1}&objKey=<object ID>=@{2}&action=@{3}&returnApp=AnalyticsApp&returnAppParams=PortalGo%26path=</shared/Custom/<folder>/@{6}
| Name | Prompt | Type of Value | Value | Fixed | Hidden | Notes |
|---|---|---|---|---|---|---|
1 | Object Type | Value | <Object Type> | Selected | Selected | Used for shared and personal analyses. |
2 | <Prompt Name> | Column Value | Column Name in | Selected | Selected | Used for shared and personal analyses. |
3 | Action | Value | edit | Selected | Selected | Used for shared and personal analyses. |
4 | returnApp | Value | AnalyticsApp | Selected | Selected | Used for shared and personal analyses. |
5 | Logged in User | Session Variable | USER | Selected | Selected | Session variable parameter used for personal analysis permissions. |
6 | Report Name | Value | Analysis Name | Selected | Selected | Used for shared and personal analyses. The name of the analysis to return to after working in the transactional page. |
1- what should I type in Prompt Object Type ?
I want to link with the 2nd analysis, so should I write 'Analysis' or <the 2nd analysis name> or what?
2- In deeplink (&objKey=<object ID>)
What Object ID should I write here? from where I get the Object ID ?
3- Action (edit)
what are other actions available ?
Answers
-
Hi,
"deeplink" don't exist in OBIEE and therefore no answer for 1-, 2- and 3-.
Maybe it's worth asking that in a OTBI forum?
0
