Tuesday, 27 March 2012

OBIEE10g Auto Suggest Prompt

Since this isn’t a standard 10g functionality I wrote some JavaScript to make it happen. But I didn’t reinvent the wheel Knipogende emoticon ! The people at jQuery already did the bases, I simple adapted it for usage in OBIEE 10g.
1. Download the jQuery UI package here. Install it in your b_mozilla directory’s (or other webserver dirs you use).
2. Download the jQuerySetup from here.
3. Add the setup script to a textbox on your dashboard page:
Alter files locations if needed, don’t forget the Contains HTML Markup checkbox.
4. Add a dropdown prompt to your dashboard page.
5. Create a javascript file in your b_mozilla directory’s called: autocomplete.js
function SetAutoComplete(PromptColumn){
    var domNode = document;
    var tagName = '*';
    var tags = domNode.getElementsByTagName(tagName);
    var y ="";          
    for(i=0; i<tags.length; i++){
    if (tags[i].className  == 'GFPFilter') {
        if (tags[i].getAttribute('gfpbuilder').indexOf(PromptColumn) != -1)
            y = tags[i].getAttribute('sid')          
                $( "#"+y ).combobox();          
6. After the dropdown prompt add a textbox with:
<script src="res/b_mozilla/autocomplete.js" language="javascript"> </script>
<script language="javascript">
    SetAutoComplete('C1  Cust Name');
7. Add your report and run the dashboard:

No comments:

Post a Comment

Thanks to Comment