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

  • User_CEU9I
    How to convert date to hours range
    Hi all, How to convert date time to hours range. Please see the below screen shot for the requirement. I have 3 hour ranges shift: 1. 12AM - 8AM 2. 8 AM - 4 PM 3. 4 PM -…
    Received Response
    User_CEU9I 181 views 7 comments Most recent by User_CEU9I
  • 3283263
    Report - Chart Stacked with %
    Hi All, Is it possible to get a chart stacked with %? When I create my pivot table and show my data as percentage and then draw the chart table, I cannot get a chart wit…
    Received Response
    3283263 1 view 1 comment Most recent by Thomas Dodds
  • Wolfrm
    Custom column with a filter that selects a single row
    Usually what one receives from OBIEE is this: NameAddressJohnaddress1address2address3 Would it be possible to create three custom columns that each return a single one o…
    Received Response
    Wolfrm 72 views 19 comments Most recent by Wolfrm
  • 3283263
    Duplicate Pivot table
    Hi there, Is there any way on the report view to duplicate pivot table in order to keep the format and like that we just need to change the data? Can we set up a default…
    Received Response
    3283263 1 view 5 comments Most recent by [Deleted User]
  • 327788734
    Doubts about BIEE 12 compatible SAP BW
    Dear Experts I not found documentation to resolve doubts: 1 - What operating systems are compatible to install BIEE 12.2.1.1 and configure it to access SAP BW? 2 - The B…
    Received Response
    327788734 11 views 3 comments Most recent by [Deleted User]
  • SYedurur
    XML Output using BIPublisher
    Hi Experts, My client needs XML output in oracle table.Can you help me which option is best to achieve this XML output.
    Received Response
    SYedurur 1 view 5 comments Most recent by Thomas Dodds
  • mlov83
    The actual Executed SQL or SQL steps.
    Hey Guys, So I have now been playing with OBIEE for over a month and things are starting to make more sense. Question that I still seemed to be fuzzy about is, where can…
    Received Response
    mlov83 2 views 2 comments Most recent by [Deleted User]
  • ksbabu
    BI Server
    Hi Experts, I am new to obiee installed in my local system,all the server's are in up mode but bi server in down mode,i started bi server in enterprise manager even it f…
    Received Response
    ksbabu 33 views 5 comments Most recent by Shams Abbasi
  • deahayes
    copy/paste mulitple values for a parameter
    Hello all, Is it possible for a user to copy and paste his choices for a parameter that allows multiple selections, instead of selecting them from the parameter search w…
    Received Response
    deahayes 94 views 11 comments Most recent by deahayes
  • dilek
    OBIEE Content Level Question
    Hello everybody, I try to create a business model in obiee 12c. Here is my scenario; I have 2 fact tables (Fact A, Fact B) , 3 dimensions (Dim Time, Dim A, Dim B) Fact A…
    Received Response
    dilek 18 views 3 comments Most recent by Thomas Dodds
  • Venkat Thota - BIP
    Unable to Login Analytics
    Hi everyone , I am trying to login to analytics but unable to logic ,can anyone help me with issue , sawlog: State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSE…
    Received Response
    Venkat Thota - BIP 22 views 5 comments Most recent by Joel
  • user13816768
    OBIEE EBS Integration Security not working
    The EBS to OBIEE Integration is working fine by proper navigation i.e., when clicking on the responsibility name, it is taking in to OBIEE. But one of the user reported …
    Received Response
    user13816768 31 views 6 comments Most recent by Rampradeep Pakalapati
  • 3317172
    Good Visualisation help
    Hi Team, I'm new to OBIEE. Could you please help me in showing good visualisation charts and reports in Obiee 11g. If there is any document can you please help me on thi…
    Received Response
    3317172 1 view 2 comments Most recent by rmoff
  • 3061821
    How to Caluculate the current year revenue and previous year revenue
    Hi, Can anyone help me with the below criteria: For a product I have to show the revenue for current year(i.e. 01-01-2016 to 31-08-2016) and for previous year(i.e. 01-01…
    Received Response
    3061821 4 views 4 comments Most recent by 3061821
  • jepva
    How to hide catalog objects/analysis from dashboard users?
    Is there a way to configure the catalog security so that users still have access to their dashboard, but cannot see the individual objects & analysis in the folders that…
    Received Response
    jepva 112 views 7 comments Most recent by jepva
  • 35e30d56-c405-410d-bd98-fffeb55cc7bf
    Pivot Table -Calculating %s
    I have the following pivot table created in my report. The column MM represents base sales, and the 'S&T' and 'EDS' columns represent additional software sales to go wit…
    Received Response
    35e30d56-c405-410d-bd98-fffeb55cc7bf 26 views 8 comments Most recent by [Deleted User]
  • ORA-00666
    Difference between dates
    Hi. I need to calculate difference between colum BIRTH_DATE (type is datetime) and parameter @{p_date_till}. This is what I've tried: 1. TIMESTAMPDIFF(SQL_TSI_YEAR , BIR…
    Received Response
    ORA-00666 3 views 9 comments Most recent by Alok Surana
  • Rahul Huilgol
    Run-time computation in an OBIEE report
    Hi everyone, I have a situation that requires me to capture two values from the report parameters viz, months.. say MonthID1 and MonthID2. I have employee data in a data…
    Received Response
    Rahul Huilgol 1 view 1 comment Most recent by Gianni Ceresa
  • bjbreitling
    Make a date dimension for dashboarding
    Hi, How would I make a date dimension for showing something. For example I want to show head count. I have the termination date and hire date and I know the count of the…
    Received Response
    bjbreitling 264 views 15 comments Most recent by Thomas Dodds
  • Alex1
    Issue when there is new data in cube
    Hi experts, I have a issue when after data is loaded in my cube. I'm using obiee 11.1.1.5.0 and my database is GreenPlum, (other databases in my rpd works fine when new …
    Received Response
    Alex1 39 views 6 comments Most recent by Thomas Dodds