Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

11g ... Javascript Parse to Prompt

Question
1
Views
0
Comments

Is it possible, with javascript, to create a very basic parsing mechanism which takes user text input and feeds into prompt fields for 11g OBIEE Dashboard.

For example, user inputs "VX7482QC|Japan|FY16" (EventCode|Region|FY), javascript parses creating variables which are passed to prompt, then results are rendered (inquiries from event in Japan during FY16).

Another example.  Instead of having 3 column variable (Event Code, Campaign Code or Program Code) choice list prompts for various marketing activities, user inputs a single marketing code into a text field.  [Assuming Codes follow a recognizable pattern , like Event Code always "XX####YY"; Program Code always "XX####"; Campaign Code always "XX####YY####"].  Once the user enters code, javascipt parses creating variables which are passed to prompt.