How to drilldown from summary analysis to detailed analysis using deeplink

User_RDRYF

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 "<table.name>"."<column.name>" format	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 ?

Gianni Ceresa

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?