Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE 11g Only One Apply/Go Button

user9525825Sep 26 2013

Hi All,

Currently Ii´m involved in
a migration process of OBIEE 10g to 11g and I need to maintain the same functionalities
works in 11g.

In 10g I have one dashboard
with 3 dashboard prompts, and the apply/go button is only one for all dashboard
prompts.

This feature in 10g was implements
by javascript however in 11g don´t work.

After some research I try code
that was mention on link http://bidirect.blogspot.pt/2013/06/single-apply-and-clear-button-for.html but this don´t work like i need,
because only works for the 2 dashboard prompt.

After some changes i have
this code:

<script>

function apply()

{

alert ('ola');

var x = 0;

var aElm=PromptManager.getPromptManager().getAllPromptCollectionJSON();

alert ( aElm.length);

var promptExpr = []

for(var i = 0; i < aElm.length;i++)

{

alert ( 'Dashboard Prompt --> ' + i);

for(var j = 0; j < aElm[i].promptSteps[0].prompts.length;j ++ )

{

var promptid = aElm[i].promptSteps[0].prompts[j].promptStreamID;

var g = null;

var h =
PromptManager.getPromptManager().getPromptCollectionInfoWithViewID(aElm[i].viewStatePath);

//alert ( 'Dashboard Prompt --> ' + i + '\n' + ' Prompt ' + j);

if(h)

{

//alert ( 'Dashboard Prompt --> ' + i + '\n' + ' Prompt ' + j);

try

{

//alert ( 'Dashboard Prompt --> ' + i + '\n' + ' Prompt ' + j);

var b = h.getAllPromptExprsArray();

//alert ('2')

if( ! h.verifyPromptValuesAndDisplayError(b))

{

return;

}

//alert ('3');

g = PromptManager.buildPromptExprGivenExpr("", b);

//alert ('4')

}

catch(f)

{

alert(f);

return;

}

}

}

x++;

promptExpr[i] = g;

//alert ('incrementar x');

//PromptManager.submitPrompt(aElm[i].viewStatePath,
true,"PromptFinish", g)

var t = i + 1;

//alert ('Run prompt')

}

x--;

//PromptManager.submitPrompt(aElm[x].viewStatePath,
true,"PromptFinish", g)

//alert ('PromptAgain');

//PromptManager.submitPrompt(aElm[0].viewStatePath,
false,"PromptAgain", g)

alert ('PromptAgain');

alert
(aElm[0].viewStatePath);

alert (aElm[1].viewStatePath);

//PromptManager.submitPrompt(aElm[0].viewStatePath,
false,"PromptAgain", promptExpr[0])

//alert ('PromptFinish 2');

//PromptManager.submitPrompt(aElm[1].viewStatePath,
true,"PromptFinish", promptExpr[1])

  1. PromptManager.submitPrompt(aElm[0].viewStatePath,
    false,"ApplyFilter", promptExpr[0])

    PromptManager.submitPrompt(aElm[1].viewStatePath,
    false,"ApplyFilter", promptExpr[1])

    PromptManager.submitPrompt(aElm[2].viewStatePath,
    false,"PromptFinish", promptExpr[2])

alert ('FIM');

}

</script>

<td class='GFPSubmitN'>

<table cellspacing=”0?>

<tbody><tr>

<td class="XUIPromptEntry">

<span class="minibuttonOn" align="left">

<div align="left"><a href="#"
onclick="javascript:apply();">Run</a></div>

</span></td>

<td></td>

<td class="XUIPromptEntry">

<span class="minibuttonOn" align="left">

<div align="left"><a href="#" onclick="return
PersonalizationEditor.removeDefaultSelection(false)
">Clear</a></div>

</span></td></tr><tr><td/></tr>

</tbody></table></td>

The code works but don´t
have the right functionality because when i submit first dashboard prompt they
apply the filters but refresh the dashboard and clear all other prompts values.

Can someone help me please?

Best Regards,

Pedro Madureira

Comments
Locked Post
New comments cannot be posted to this locked post.