Oracle Analytics Cloud and Server

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

Oracle Analytics Cloud and Server

Ask questions in the Oracle Analytics Cloud and Server forum to get immediate help from peers and experts. Collaborate on best practices and dive into discussions around Data, Analytics and AI.

Discussion List

  • deeps
    Obiee 12c - Deleting column in the RPD won't delete from alias
    I am trying to delete a column from one of the tables in physical layer. In 11g, when a column is deleted, it used to delete in the related aliases as well. I am on vers…
    Received Response
    deeps 52 views 2 comments Most recent by deeps
  • chillychin
    OBIEE 12c Server Ports - Which ones to open?
    I just (finally) got a clean install of my OBIEE 12c instance and I see everything is running, though I can not access any of the URL's (/analytics, /em etc) Im pretty s…
    Received Response
    chillychin 2K views 6 comments Most recent by 1921572
  • User_OIX2S
    Can I use sharepoint list as datasource in OBIEE ?
    I am trying to create a data source to connect to share point.
    Received Response
    User_OIX2S 51 views 4 comments Most recent by Gianni Ceresa
  • Ebin Cherian
    SUM BY Logic in OBIEE RPD
    Hi All, Oracle Business Intelligence 12.2.1.1.0 I am trying to implement a sum by using a level based hierarchy. I will try to explain the scenario in the best way I can…
    Received Response
    Ebin Cherian 421 views 1 comment Most recent by Ebin Cherian
  • User_ZZQJ0
    RPD Locked
    OBIEE 12c We are working in a MUD environment. Each time I have tried to publish the RPD to network I receive the error "Failure to acquire lock." The system then tells …
    Received Response
    User_ZZQJ0 43 views 1 comment Most recent by User_ZZQJ0
  • rbeet88
    OBIEE: Find the number of Working/Business Days between two dates and exclude Public Holidays
    Hi All, My client is an Oracle Fusion SaaS customer and are currently developing a number of reports in OTBI. They have a requirement to find the number of Working/Busin…
    Received Response
    rbeet88 186 views 4 comments Most recent by rbeet88
  • Rick Brobbel
    OBIEE BLOB
    Hi, I am trying to make show data from a field in a table, which is the type BLOB. It contains text attachments, that I want to show in Oracle BI. I can import the table…
    Received Response
    Rick Brobbel 1 view 1 comment Most recent by Thomas Dodds
  • user652652
    How to get previous quarter from Quarter End date
    Hi Experts, We do have quarter end date in table and we want to get previous quarter from there we have 31/03/2017 30/06/2017 30/07/2017 31/12/2017 We need to calculate …
    Received Response
    user652652 21 views 2 comments Most recent by asim cholas
  • Venkata Rachuri
    BI server Performance
    Hi Experts, My scenario : We have a report that is taking 1m and 24 seconds in OBIEE. I took the query and ran it on database ( exadata) , it took 45 seconds in database…
    Received Response
    Venkata Rachuri 11 views 1 comment Most recent by [Deleted User]
  • 980840
    Migrating Dashboard Saved Customization OBIEE 11g to 12c
    Hi there, Has anyone successfully migrated dashboard saved customization from OBIEE 11g to 12c? I am able to migrate the _selections folder from 11g to 12c without issue…
    980840 11 views 6 comments Most recent by 980840
  • Bhavya P
    OBIEE TimesTen Integration
    Hello, TimesTen is configured with OBIEE using BI Direct: OBIEE 11G and Oracle Times Ten 11.2.2 Integration configuration setup, in Windows machine for OBIEE 11.1.1.9. E…
    Received Response
    Bhavya P 23 views 4 comments Most recent by Sherry George
  • Sunny86
    SMTP service for BI12c issue
    Hello all, We have configured the smtp server details in em and restarted services multiple times. But those values not reflected in schedulerconfig.xml. Also the agent …
    Received Response
    Sunny86 1 view 3 comments Most recent by [Deleted User]
  • user10499938
    Performance issue
    Hi Guys, i'm not able to understand why the original report it takes few seconds to retrieve results, but when i add to it another dimension table composed by few record…
    Received Response
    user10499938 21 views 5 comments Most recent by [Deleted User]
  • Youssef_B_82
    Can I replace 0 with a hyphen -
    Hi, Is it possible to replace a value by a hyphen "-" when it's equal to 0? I want to display a hyphen instead of 0 on an analyses, so for example when sales = 0 I want …
    Received Response
    Youssef_B_82 319 views 8 comments Most recent by Gianni Ceresa
  • Jerry S.
    Having strange issue with SQL Server field that is "bit" data type
    OBIEE 11g I am working on a project that references a SQL Server data base. In some of the tables, there is a field named "Active indicator" that is of type "bit". The f…
    Received Response
    Jerry S. 1 view 2 comments Most recent by Sherry George
  • Jerry S.
    Question about top record in parent-child hierarchy
    In the examples of parent-child tables I have been able to find, they use an org chart as an example. It says in the table, the CEO record needs to have null in the pare…
    Received Response
    Jerry S. 11 views 1 comment Most recent by Jerry S.
  • BIAP
    Apply count() inside of measure
    Hi, Requirement: to display the number of taxis which travel time is less than or equal to 40 mins. One each taxi level, if travel time is null, display this measure as …
    Received Response
    BIAP 11 views 2 comments Most recent by BIAP
  • Chris Arnold
    Default NULL fields to NUMERIC datatype
    In Answers, I have a report that uses a UNION. For the first part of the union I select sum(z_weight) (z_weight is a numeric field that stretches out to about 8 decimal …
    Received Response
    Chris Arnold 43 views 1 comment Most recent by Thomas Dodds
  • Sunny86
    OBIEE 12c installation configuration fails
    Hello All, We couldnt complete BI12c installation configuration due to an error at Add default service instance started . what could be the issue. Any pointers and help …
    Received Response
    Sunny86 211 views 10 comments Most recent by Syedsalmancs110
  • DentsplySirona
    WebLogic SSL
    I would like to better understand WebLogic SSL configuration. I would like to use a certificate that has a different name than my server. Something like my server name i…
    Received Response
    DentsplySirona 1 view 1 comment Most recent by handat