Extra Pages

▼

Friday, February 13, 2009

OBIEE Switching between filters

Found this one on the OTN forum http://forums.oracle.com/forums/thread.jspa?threadID=859458&tstart=0 

First create a Yes/No Prompt

image

Put the result in a presentation variable called YesNo

On your report create a filter like:

image

Pay close attention to the position of the singel quotes!

Put both the prompt and the report on a dashboard page:

image

image

Till Next Time

at

12 comments:

  1. Christian BergFebruary 13, 2009 at 3:36 PM

    Sweet! ;-)

    ReplyDelete
  2. AnonymousFebruary 20, 2009 at 1:09 PM

    Hello John, i've been visiting your blog (I discovered it last week and its being a real nice help for me, im beginning with OBIEE 10.1)

    Well, my question is i was checking this: link (its from last summer)
    where u talk about what "Preferred dirll path" is for. Well, could u explain what u discovered please? or just guide me to the link where u explained it, 'cos i coudltn find it.

    (Btw.. does preferred drill path has anything to do with drilling up?)

    Thanks and gratz for the nice blog

    ReplyDelete
  3. John MinkjanFebruary 27, 2009 at 11:46 AM

    Hi Javi,

    Have a look here:

    http://obiee101.blogspot.com/2009/02/obiee-simulating-drill-up.html

    Regards

    John

    ReplyDelete
  4. AnonymousMarch 21, 2009 at 8:41 PM

    Hi John,

    On the filters, I did exactly as you have posted. So I have 3 options, Top 10, Top 20 or All on Dollars. Now I need to add one more prompt where user can also specify an amt say X - the report will show all Dollars > $X.

    It looks like I can do only one at a time. So either I have a prompt for Top or prompt on > $X. If I have both and I select Top 10 and X=100, OBI uses the X=100 as a check in the filter and the report does not work as expected.

    I am still experimenting to make it work. Any suggestions I could try ?

    Thanks,
    Sheela

    ReplyDelete
  5. John MinkjanApril 1, 2009 at 5:11 PM

    Hi Sheela,

    MAybe this will help:
    http://obiee101.blogspot.com/2009/04/obiee-dynamic-prompt-content.html

    regards

    ReplyDelete
  6. UnknownDecember 16, 2009 at 1:23 AM

    Hi John,

    I have been following your blog. I am new to OBIEE. I tried to implement above functionality. But I am not able to create a OR filter. Could you please tell me the steps to implement OR filter

    Thank you,
    Ashu

    ReplyDelete
  7. John MinkjanDecember 17, 2009 at 9:48 AM

    @Ashwini

    Have a look here:
    http://obiee101.blogspot.com/2009/12/obiee-making-or-filter.html

    Regards John

    ReplyDelete
  8. AshMay 11, 2010 at 11:16 AM

    Hi John,

    The prompt you created is based on 'YesNo' column which is actually not part of the subject area. How to create a prompt on a DUMMY column.

    Ash

    ReplyDelete
  9. John MinkjanMay 11, 2010 at 11:28 AM

    @Ash

    Just edit the columnname in the prompt, give it any name between single quotes.

    regards

    John

    ReplyDelete
  10. AshMay 11, 2010 at 12:38 PM

    This comment has been removed by the author.

    ReplyDelete
  11. AshMay 11, 2010 at 1:40 PM

    This comment has been removed by the author.

    ReplyDelete
  12. John MinkjanMay 11, 2010 at 3:29 PM

    @Ash

    In the filter part goto ADD > Variable > Presentation. Then type the exact name of the presentation variable you are using.

    Regards

    John

    ReplyDelete

Note: Only a member of this blog may post a comment.