{"id":424,"date":"2010-10-28T10:38:45","date_gmt":"2010-10-28T08:38:45","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=424"},"modified":"2010-10-28T10:40:10","modified_gmt":"2010-10-28T08:40:10","slug":"zmienne-prezentacyjne-dla-between","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=424","title":{"rendered":"Zmienne prezentacyjne dla between"},"content":{"rendered":"<p><a href=\"http:\/\/obiee101.blogspot.com\/2009\/03\/obiee-between-dates-prompt.html\">Link<\/a><\/p>\n<p><!--more--><br \/>\nOne the questions you see regularly on the forums is how to create a 'between dates&#8217; dashboard prompt if the date column is not a part of a date dimension. If more important with the use of the calendar control.<\/p>\n<p>Step 1 create a new prompt based on a date dimension:`<\/p>\n<p>select 'Calendar&#8217; from the control dropdown box, if you do it  later on it won&#8217;t be available (undocumented feature \ud83d\ude09 ).<\/p>\n<p>Step 2: Alter the column function:<\/p>\n<p>    CASE WHEN 1=0 THEN CALENDAR.D_DATE ELSE TIMESTAMP '1900-01-01 00:00:00&#8242; END<\/p>\n<p>The CASE WHEN part guarantees validation of the column.<\/p>\n<p>Step 3: Set the presentation variable and label<\/p>\n<p>image<\/p>\n<p>Step 4: repeat step1<\/p>\n<p>Step 5:  Alter the column function:<\/p>\n<p>    CASE WHEN 1=0 THEN CALENDAR.D_DATE ELSE TIMESTAMP '2999-12-31 00:00:00&#8242; END<\/p>\n<p>This has to be different from the one used in step 2 since OBIEE uses the default outcome of the formula as internal name for the column.<\/p>\n<p>Step 6: Set the presentation variable and label<\/p>\n<p>image<\/p>\n<p>Step 7: reference the variable in your report:<\/p>\n<p>image<\/p>\n<p>Step 8 : Create the dashboard:<\/p>\n<p>image<\/p>\n<p>Till Next Time<br \/>\nPosted by John Minkjan at 3\/02\/2009 11:11:00 AM<br \/>\nLabels: ALL POSTS, DATE\/TIME, OBIEE, PROMPT <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Link<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[47,55],"tags":[],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/424"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=424"}],"version-history":[{"count":4,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/424\/revisions"}],"predecessor-version":[{"id":428,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/424\/revisions\/428"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}