Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Copying a clicked cell value to the clipboard
Short version: Is there a way to set up an action link that will copy a clicked value to the Windows clipboard?
Long version: The subject area of interest in this question is related to Accounts Receivable. I have created a very simple analysis (just a table view) that displays all of our past-due accounts. One of the columns in that analysis is a 12-digit Customer ID. Each day, the AR team "works the list", line-by-line. They work their way down the rows on the analysis, find the Customer ID on each row, and then manually type that 12-digit Customer ID into our AR (Billing) system. [Side note: It would be fantastic if our AR system was smart enough to let us pass in a Customer ID via the URL, because then we could just use some HTML in the Customer ID column and click to go directly to that customer in the AR system. Alas, our AR system is NOT smart enough to do that.]
We would like to be able to set up an action link on the Customer ID column so that clicking on a value of Customer ID in the table would copy that clicked value to the Windows clipboard. That way, the AR team would not have to manually type 12-digit numbers into the search field in the AR system - they could just do a simple ctrl+v to paste from the clipboard.
And now for the final degrees of difficulty: The BI version is OAC. When I go to create a new Action Link, the only two options I see are Navigate to BI Content and Navigate to a Web Page. I don't see the other options that are present in on-premise OBIEE such as executing JavaScript. This may mean that I am asking for the impossible, because it seems to me that, without those other options, the solution must be coded in the column formula itself.
Thoughts?
Answers
-
Long version or short one?
For the time being: forget it You mentioned all key points and it won't work within the limitations you listed.
0 -
I can suggest a workaround in the form of a client tool called data loader, or you could drop them out into excel and work some VB magic on the column in question.
But Christian as ever is 100% correct, there is nothing without interceding middleware in your scenario.
0 -
I HATE it when Christian says "no way", because that really does mean "no way". Alas, if Christian doesn't have a solution, then there just isn't one.
Thanks for the assistance, guys. Now I can stop looking.
I was just thinking: Wouldn't it be nice if a simple ctrl+c on the cell would do the trick? Although that doesn't work directly in OBI, it occurs to me that I could have them export the analysis to Excel, where they can use a simple copy from a cell and then a paste into the AR system. They don't have to go down the list from the OAC screen - they can just as easily go down an Excel file. No more typing 12-digit Customer IDs. It's a tiny once-per-day extra step, and if accomplishes the goal of ease of entry. Added advantage: They can delete or highlight rows in the Excel file as they process each one.
0 -
Sure - middleware again!
0 -
Mark.Thompson wrote:I HATE it when Christian says "no way", because that really does mean "no way". Alas, if Christian doesn't have a solution, then there just isn't one..
Welcome to the ever growing club of "People Who Hate Christian" (R).
While I get why this was removed from OAC it's always rubbish when a "new" product contains less functionality.
0