tag:blogger.com,1999:blog-7751447442026377325.post1776234681101599334..comments2023-10-23T22:25:46.368+02:00Comments on Oracle Business Intelligence OBIEE 101: OBIEE Dynamic prompt contentJohn Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-7751447442026377325.post-62100621940023017262011-07-15T06:50:13.696+02:002011-07-15T06:50:13.696+02:00Hi ,
Do you have any recommendation to achieve th...Hi ,<br /><br />Do you have any recommendation to achieve this in multi select prompt ? I have multiple flags in my fact table. I want them to be listed in multi select prompt and when user selects one or more flags it should dynamically add filter flag(selected from multi select prompt) = 1.<br /><br />Thanks !!!Sridhar Subramanianhttps://www.blogger.com/profile/14351398694597224432noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-59758302482465054382011-05-06T21:30:58.001+02:002011-05-06T21:30:58.001+02:00Hi John,
thanx for this good post, i have a requir...Hi John,<br />thanx for this good post, i have a requirement where i have a report on the dashboard where i created this dynamic prompts and the report has a column from time hierarchy using this prompt and used as column selector in same report to flip from year thru week.<br /><br />Requirement is to default the report with different values for different levels in hierarchy i.e. year = rolling 4 yrs, quarter =rolling 6 qrtrs etc; so if i select the LOV in 1st prompt ex:year then i can see values of column-year in 2nd prompt. <br /><br />Now i'm not able to pass this value to report(Pivot view) which has to change dynamically my column selector.<br /><br />Is there any possibility to achieve this requirement.<br /><br />Also at creating the filters in report in your example i see '@{FilterName}' is equal to/is is Market, i'm confused a little over here, is it a presentation column in the report or a new pres.variable ?? because i'm not seeing this variable refered in other place on dashboard. <br /><br />please help me over here with your reply.<br /><br />thanks in advance.taurushttps://www.blogger.com/profile/01526406834784374166noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-57069954933382967362009-10-21T19:44:43.925+02:002009-10-21T19:44:43.925+02:00@sankar,
I'm not sure what you are trying to ...@sankar,<br /><br />I'm not sure what you are trying to achieve, can you eloborate?<br /><br />regards<br /><br />JohnJohn Minkjanhttps://www.blogger.com/profile/08228393663535024706noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-2216502206673959582009-10-07T00:13:40.203+02:002009-10-07T00:13:40.203+02:00Hello John:
This article is very helpful on what I...Hello John:<br />This article is very helpful on what I am trying to do. <br /><br />I now have a dynamic filter which is constructed based on the prompt value derived using the presentation variable. <br />I have the following question? <br /><br />1/ Is it possible to make this dynamic filter prompted to one presentation variable from the prompt? <br /><br />Thanks<br />SankarAnonymoushttps://www.blogger.com/profile/17155726808852806119noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-13372530793259081592009-04-03T13:46:00.000+02:002009-04-03T13:46:00.000+02:00I know that we can not populate presentation varia...I know that we can not populate presentation variable just with changing value from a list, for now. The only way is with 'GO' button. To bad.<BR/><BR/>Regards,<BR/><BR/>http://108obiee.blogspot.com/Goran Ockohttps://www.blogger.com/profile/16571461599213456839noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-12575529473630511432009-04-03T13:37:00.000+02:002009-04-03T13:37:00.000+02:00Hi John.Are these two fields on two separeted dash...Hi John.<BR/><BR/>Are these two fields on two separeted dashboard prompts, each with its own 'GO' button?<BR/><BR/>So you need to activate (to fill presentation variable) from the first 'GO' and then use this filled variable on a second dashboard prompt and then after second 'GO' report is filtered.<BR/><BR/>If yes, is there some way to have only one dashboard prompt with these two fields so that second field see a presentation variable from the first field when we change it from a drop-down list.<BR/><BR/>This would be great to have in the future.<BR/><BR/>Regards,<BR/>Goran<BR/><BR/>http://108obiee.blogspot.com/Goran Ockohttps://www.blogger.com/profile/16571461599213456839noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-18487943398463507002009-04-03T13:33:00.000+02:002009-04-03T13:33:00.000+02:00This comment has been removed by the author.Goran Ockohttps://www.blogger.com/profile/16571461599213456839noreply@blogger.com