Hide/show dashboard section obiee 11g

[Shruti]

Hello,

   

    I have a requirement wherein i need to hide/show a dashboard section based on the value selected in the prompt. The functionality works fine when there is only a single column/variable prompt. But if there are other column filters it fails.

For eg: 

I have created a Dashboard prompt with following columns   (Scope : Page)

Execution Date:   < column prompt>

Execution Id:       <column prompt>

Currency Type:      <variable prompt > /*Prompt values : Reporting, Contractual  . present variable name:pCurrType */

Currency:        <column prompt>

If user selects Currency Type : Reporting  i want to hide Section 1 , and show Section 2  

If user selects Currency Type: Contractual , i want to hide Section 2 and show Section 1.

Have added condition accordingly to Dashboard section. But it fails

If i just place a single variable prompt, Currency Type (remove the rest of the column prompts) , it works.

Has any one come across such scenario?

Shruti

[Nilley Gómez]

Hi Shruti,

The last year I solved a similar case with the following development: I created a simple answer that returned a dummy column  with filter based in presentation variable, in your case "Currency Type," and in the dashboard  I put the section condition based in results of the created answer.

Nilley

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Antonio Rivas]

Hi Shruti,

Your set up looks good to me. I usually do this kind of things to play with the dashboard´s sections visibility. 

I don't see any reason why having multiple column prompts might have an impact. However, if that's the case you might try to isolate the prompt that controls the presentation variable in a separate prompt and keep the rest of the prompts in a different one. 

Anyway, you mention that your approach fails, can you please elaborate in the error?

Thanks,

Antonio.-

[Joan]

Hi,

I guess you could set up several prompts, one of them "specialized" in currency type, is it acceptable to you?

As  you're not describing the wrong behaviour, nor specifying obiee release, I'm affraid it might not working as expected due to cache.

I faced a similar issue, with a single variable prompt selection.

In our case, after changing the selection (2nd. time back to previously selected value) the prompt didn't trigger the selection to refresh results.

We "solved" it by disabling cache ... with severe impact on performance.

I know I'm not answering to your question ... but I hope to help on diagnosing the cause to the undesired behaviour.

         Joan.

 

El dijous 21 d’agost de 2014 9:41:32 UTC+2, Shruti va escriure:

[Shruti]

Hi Nilley,

   I had tried the option, which you have mentioned. It works perfect, when there is only one dashboard prompt, i.e. currency type. But when i place it with other prompts for eg: Exec Date, Exec Id etc (because they are cascading prompts), the section condition fails to work.

   I checked the log, to confirm if the value is getting passed to the report used in the section condition. And the report is giving desired output.

But not sure why it fails to hide/show the section on dashboard end.

Regards,

Shruti 

obiee-enterprise-methodology+unsub...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsub...@googlegroups.com.

[Nilley Gómez]

Hi Shruti,

In some versions OBIEE exists bugs related wrong behavior in prompts.  

what is your version OBIEE? 

maybe, have you a java scrip code in your dashboard?   

please send me the detail of your development in a file doc, including screenshots of prompt, answer and dashboard, all in mode edition and with this information I could reproduce your issue and maybe I could find some workaround about it.

Regards.

El 25/08/2014, a las 07:57, Shruti <shru...@gmail.com> escribió:

Hi Shruti,

[Shruti]

Hi Joan,

  I am using obiee ver 11.1.1.6.2. The cache is disabled. The problem is,  the functionality of dashboard section is  not working. 

For eg: If ReportA (which is used in dashboard section), 

            rowcount=0 then hide Section A and show Section B

            rowcount>0 then show Section A and hide Section B

What is happening currently is that, both the sections are hidden, on selection of either Currency Type: reporting/contractual

 Rgds,

shruti

[Shruti]

Hi Antonio,

    No error is generated. But not sure, why it hides both the sections, on selecting either of the currency type. I will take screenshots , of the dashboard and log, that may give better understanding on the issue.

Isolating the currency type prompt, solves the issue. But the requirement is to have it along with the other related prompts.

Rgds,

Shruti

[Shruti]

Hi Nilley,

   I am using OBIEE version 11.1.1.6.2. There is not jscript on the dashboard. I will mail you the screenshots. Thanks for your help :)

Rgds,

Shruti

[Richard Chan]

Are you only using the currency colimn not the other ptompted columns in your analysis that you are basing your condition on

Richard

Sent from my Samsung GALAXY SIII 

--

--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to

obiee-enterprise-met...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.

[Gómez Rodríguez Nilley]

Hi Shruti,

It is a old version, for example the following bugs are related with wrong behavior prompts and exists more.

bug 11780223 - DASHBOARD PROMPT and  bug 13529303 - OBIEE 11G PROMPT.

--

--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to

obiee-enterprise-met...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.

[pavan@eAlliance]

Shruti,

Have taken the similar scenario(variable prompts and  column prompts) ,it worked in the version 11.1.1.7.

Please have a look into the below link.

http://total-bi.com/2011/01/obiee-hide-show-sections/

Regards,

Pavan

[Nilley Gómez]

Hi Shruti,

Look into this link about OBIEE 11.1.1.6.x: Error Correction Support has Ended blogs.oracle.com/proactivesupportEPM/entry/obiee_11116_x_eoecs_2 

Maybe you should think about possible upgrade. 

Regards.

Nilley

--

--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to

obiee-enterprise-met...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.

[Adrian Ward]

For this type of issue I would normally break the problem down to identify where the problem is.
So, every analysis, prompt, variable, and request used for navigation should be placed on a clean dashboard page, but do not set any conditional display, and then you run the page and set the prompts, watching what the results are, i.e. Make sure you are getting rows in your 'Condition' analysis that you expect

If all work as expected then, set the section conditions one by one.  Testing each time.
If you still have not found an issue in your logic and the sections still don't display properly then it must be a bug :)

Adrian

Sent from my Windows Phone

---

From: Nilley Gómez
Sent: ‎27/‎08/‎2014 17:37
To: obiee-enterpri...@googlegroups.com
Subject: Re: [OBIEE EMG] Hide/show dashboard section obiee 11g

[Christian Berg]

+1 Adrian! :-)