Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi, After you develop the datamodel and the report on top of it you just create an OTBI Dashboard and select the report to be added to dashboard the same way you select an OTBI report to the OTBI dashboard Regarding parameter passing (in case you use in BIP you can use presentation variables in Dashboard prompt but please…
-
Hi, You can also try a logic similar to below one ================================================ CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END
-
Hi, You can also try a logic similar to below one ================================================ CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END
-
Hi, You can also try a logic similar to below one ================================================ CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END
-
Hi, You can also try a logic similar to below one CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END
-
Hi, You can also try a logic similar to below one CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END
-
Hi, You can also try a logic similar to below one CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END
-
CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END
-
Yes, MOD can be used but it can become tricky ( as you see "+2+5" in a MOD7 is just a "full Cycle in MOD7" Such things might become tricky to control over time) so you can also try a conditional as below which has 2 branches depending if CURRENT_DATE is in the reporting week (days 5,6,7) or you report for previous week (…
-
Hi, You can also try a conditional like: ============================== CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END ================================ Regards, Alex
-
Hi, You can also try a logic similar to below one ================================================ CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END Regards, Alex.
-
Hi, You can also try a logic similar to below one =============================================== CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END Regards, Alex.
-
Hi, You can also try a logic similar to below one CASE WHEN DAYOFWEEK(CURRENT_DATE)>=5 THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE) END
-
Hi Brian, What formula are you using now, could you please share ? Also is it in OTBI or BI Publisher ? Regards, Alex.