Skip to content
  • Register

    • Welcome to the Oracle Analytics Community

    Home› Rick Brobbel› Comments
    Default Avatar

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Log In
    Register

    Badges

    • First Comment
    Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

    Rick Brobbel Rank 3 - Community Apprentice

    Overview

    Overview
    Roles
    Member
    Badges1

    About Me

    About Me

    Analytics

    10
    1
    102

    Reactions

    No reactions yet.

    Comments

    • Or you can simply say: MONTH("Header Details"."Journal Creation Date") = MONTH(CURRENT_DATE) - 1 Which won't work for January, so in that case you need: CASE WHEN MONTH(CURRENT_DATE) = 1 THEN MONTH("Header Details"."Journal Creation Date") = 12 AND YEAR("Header Details"."Journal Creation Date") = YEAR(CURRENT_DATE) - 1…
      in Prefix - set effective date using SQL Expresssion Comment by May 2018
    • This will happen for each new user that logs on into OBIEE. This user creates then its own folders for which the user has access rights but no one else, including Admininistrators. The only way to solve this is to go to the higher folder User Folders. Then choose Permissions. Then grant BI Administrator role access to that…
      in Access Denied for user to path.. Comment by September 2017
    • 1. Add an additional view with a graph showing the total and place that next to the detailed graph 2. The Waterfall shows an automatic total, but it can't stack
      in Adding Totals to Stacked Bar Graphs Comment by August 2017
    • Hi, You may try the function UPPER. Use this on the first character only and the concatenate with the rest of the string. Something like: UPPER(LEFT(Name,1) || SUBSTRING(Name,2,99) 99 is the rest of the string. You can use LENGTH or something like that instead. Good luck
      in InitCap without Evaluate Comment by August 2017
    • Hi, I have had a similar request some time ago, but I haven't found an answer in any formula. You would need a table in the database with those dates. They can vary per country or continent. I had even a bigger challenge when workshops had varying opening hours (such as closed on Mondays). I had to use the Work Day…
      in OTBI: Find the number of Working/Business Days between two dates and exclude Public Holidays Comment by July 2017
    • I don't know this, but don't hesitate to inquire with Oracle Support. That's how I got this insight some time ago as well.
      in Report that shows Agents and BI Schedules Comment by June 2017
    • Hi, Everything the BI server does (including the scheduling of agents) is a web service. You can access these services using for instance SOAP-UI. Please review the documentation about the web services available. I know that one of them lists the currently running agents. You can also easily review them using the client…
      in Report that shows Agents and BI Schedules Comment by June 2017
    • Hi Visual Analyser is available in OBIEE on premise from version 12c. This requires additional licenses, but I don't have the details about that. It is also available in Oracle BI Cloud Service. You can also play around with Oracle DVD (Data Visualization Desktop), which is a local client tool that can connect to a data…
      in OBIEE Visual Analyzer Comment by May 2017
    • Hi I am experiencing problems in using variable dates as well. In my case the variable is not a presentation variable, but a repository variable. I have an SR open still with Oracle Support about this. Apparently it's not so obvious. I would suggest you do the same: open an SR. Kind regards Rick
      in Presentation Variable Prompt causes Error on Results tab, but not in Open link Comment by April 2017