tag:blogger.com,1999:blog-4322942733345823065.post2448309143857788967..comments2024-03-12T10:59:42.736+02:00Comments on OBIEE in IL: OBIEE Prompts - 2 prompts on same column - Part 2OBIEE in ILhttp://www.blogger.com/profile/05334337345060191164noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-4322942733345823065.post-3320714578832923252018-12-04T14:04:29.596+02:002018-12-04T14:04:29.596+02:00Amazing job. fantastic.
I need help, I am trying...Amazing job. fantastic. <br /><br />I need help, I am trying to make 2 Variable prompts that will give between 2 dates (could be using 1 column or not necessary, there is start and end dates on my columns), problem is, this Variable prompt has to give results for 2 different repositories. I managed to do it for other prompts, but Date specifically, or the 'in between' I don't know how.<br />Any ideas?<br />emirabushalahttps://www.blogger.com/profile/13919710130089184167noreply@blogger.comtag:blogger.com,1999:blog-4322942733345823065.post-6663449179479157992018-05-17T20:02:16.011+03:002018-05-17T20:02:16.011+03:00This works like a charm, however, one thing that I...This works like a charm, however, one thing that I don't see addressed here. I'm using format MM/DD/YYYY HH:MM:SS and each time I change any filter value, the hours move forward in this field (?) In other words, the default value does not stay fixed, but shifts. Any idea how to prevent that from happening?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4322942733345823065.post-80103014838249100602017-12-02T14:32:54.299+02:002017-12-02T14:32:54.299+02:00In this case I would create 2 date variables / exp...In this case I would create 2 date variables / expressions: <br />1. till_date: the date minus day_of_month<br />2. from date: till_date - 3 month + 1 dayOBIEE in ILhttps://www.blogger.com/profile/05334337345060191164noreply@blogger.comtag:blogger.com,1999:blog-4322942733345823065.post-29221876984947648782017-12-01T09:26:51.892+02:002017-12-01T09:26:51.892+02:00Hi Boris. I have a date presentation variable (&qu...Hi Boris. I have a date presentation variable ("Date"."Month Description" IN (@{cust_date})). How can I get the last 3months based on the date picked e.g if the date passed is 11-Nov-2017, I display data for Aug, Sept and Oct? How do I customize the variable to give me previous 3 months?KenyanNerdhttps://www.blogger.com/profile/08505235394268421716noreply@blogger.comtag:blogger.com,1999:blog-4322942733345823065.post-48215251035300072792017-03-11T07:19:46.059+02:002017-03-11T07:19:46.059+02:00Wow, you awesome ... with this voodoo trick you sa...Wow, you awesome ... with this voodoo trick you save my day.<br />KUDOS!!!!Osymadhttps://www.blogger.com/profile/17193464045926541520noreply@blogger.comtag:blogger.com,1999:blog-4322942733345823065.post-51040213619842720452016-08-26T10:06:56.020+03:002016-08-26T10:06:56.020+03:00Hey, I'm trying to create a condition where Fr...Hey, I'm trying to create a condition where From Date is <= To Date and To Date<=Current Date. Though I've put the filters as above, I'm getting an error. <br /><br /> <br />Error getting drill information: SELECT date'2016-08-24' saw_0 FROM "Workforce Management - Processed Time Cards Real Time" WHERE ( date '@{To_Date}' >= date'@{From_Date}' ) AND (date'@{To_Date}' <= (SELECT VALUEOF("CURRENT_DATE_REP_OTBI") FROM "Workforce Management - Processed Time Cards Real Time" FETCH FIRST 1 ROWS ONLY))<br /><br />Loving your blog so far! Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4322942733345823065.post-89842930217486620262015-10-19T18:22:53.823+03:002015-10-19T18:22:53.823+03:00Great help! Kudos to you!Great help! Kudos to you!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4322942733345823065.post-69221703290055899162014-07-22T17:06:19.064+03:002014-07-22T17:06:19.064+03:00Thank you!Thank you!Сенцейhttps://www.blogger.com/profile/04977682270607505478noreply@blogger.com