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

  • mmajdana1
    Unable to view data on OAS
    Hi I installed OAS on Linux and also client Tools. i connected the admin tool with the server via ODBC and this is ok. I use ADW as data source and i set connection to i…
    Received Response
    mmajdana1 11 views 1 comment Most recent by Francesco Gregori
  • Eduardo Ferrari
    Configuring SSL in Oracle Business Intelligence, inconsistency on Cross Component Wiring instruction
    This is for Oracle OBIEE 12.2.1.4.0. I have followed the instructions to configure SSL from here https://docs.oracle.com/middleware/bi12214/biee/BIESC/GUID-B3F876BE-9344…
    Received Response
    Eduardo Ferrari 113 views 2 comments Most recent by Eduardo Ferrari
  • mmajdana1
    Narrative sort
    Hi, i am using OAC how can i make my narrative to follow sort from analysis, i have analysisi and i am shoving only one row, from it and when i make narrative it shows m…
    Received Response
    mmajdana1 1 view 1 comment Most recent by Gianni Ceresa
  • Sasha2020
    RPD - Conditional Join implementation due to null values
    Hi Experts, Issue: I already have current RPD build in the way the figure below illustrates (Arrow joins). Looking for an easier fix where RPD BMM layer do not need many…
    Received Response
    Sasha2020 32 views 2 comments Most recent by Sasha2020
  • Adam Wickes
    The cache entry has been corrupted
    Hi all, Has anybody seen this issue before? [nQSError: 52061] The cache entry /.../obis1/cache/NQS__XXXX.TBL, has been corrupted" There's an existing bug for it with a p…
    Received Response
    Adam Wickes 3 views 1 comment Most recent by Adam Wickes
  • Anirban1
    Is it possible to do nested aggregation in single calculation?
    Hi, I have a requirement as follows - In reporting layer we have used, Rsum(cost by Product)/Sum(cost by Product). Is it possible to do the same thing in RPD Layer ? I h…
    Received Response
    Anirban1 1 view 1 comment Most recent by [Deleted User]
  • 4205331
    Analysis based on random Query from table
    Dears I have table for example (Table 1) like below ID Name Select ---- ------- ---------- 1 A Select C1. C2 from x 2 B Select col4, Col6 from y I'll make analysis to sh…
    Received Response
    4205331 1 view 1 comment Most recent by [Deleted User]
  • Rai Qaiser Hussain
    Multiple Physical Schema under one database in RPD
    Dear All I am using Oracle database and created two physical schemas (DWH Staging and DWH), all the dimensions are created under DWH schema and all the Facts are created…
    Received Response
    Rai Qaiser Hussain 96 views 10 comments Most recent by [Deleted User]
  • mmajdana1
    RCU to ADW on OAS
    HI, I am currently instaling OAS on Linux and everything went fine, but now i have to create the database schemas required by OAS, using Repository Creation utility. I h…
    Received Response
    mmajdana1 41 views 2 comments Most recent by mmajdana1
  • Adam Wickes
    Seed cache for all users of dashboard
    Hi all, We have a dashboard with about 20 queries on it (bad design - I know right...) that is used by around 1000 of our users. The data however is quite static (only r…
    Received Response
    Adam Wickes 207 views 17 comments Most recent by Adam Wickes
  • User294199
    Add calculated columns in Pivot Table
    Hi, I have following Pivot Table : Now For each Month Column, selected dinamically from a prompt I want add a new column with the following formula: January % = row Cate…
    Received Response
    User294199 216 views 5 comments Most recent by User294199
  • Dravel
    OBIEE 11g - Showing percentages on a graph/line bar
    Hello, This is my first post here, so hopefully I am posting in the right place. I have an analysis with which I want to display a bar/line graph. I am trying to display…
    Received Response
    Dravel 234 views 4 comments Most recent by [Deleted User]
  • Anirban310
    Can OBIEE 11g connect with Oracle 12c DB?
    Hi, We have upgraded OBIEE from 11g to 12c. For testing purpose there is a requirement from client to connect OBIEE 11g RPD Connection pool to Oracle 12c. I am able to c…
    Received Response
    Anirban310 11 views 1 comment Most recent by Gianni Ceresa
  • chris.du
    Formatting custom groups
    Hi, I've created a custom group for my analysis and added a format for the font to be bold. The Result is, that only the label of the group is bold, but all the values n…
    Received Response
    chris.du 1 view 4 comments Most recent by chris.du
  • dirkt
    Kerberos based Single Sign-on in OAS
    We are currently using Kerberos based single sign-on for authentication with Active Directory in OBIEE 12c running on Windows. Everything I have seen on Oracle's web sit…
    Received Response
    dirkt 1 view 1 comment Most recent by [Deleted User]
  • Osama Fawzy
    oracle bi publisher add Global-Level Element by PL/SQL
    Hello all, How to call a procedure that return multiple parameters on oracle bi publisher data model. i see this link https://docs.oracle.com/middleware/12212/bip/BIPDM/…
    Received Response
    Osama Fawzy 31 views 3 comments Most recent by Gianni Ceresa
  • DeepaliG-Oracle
    Cache purge using DDR in OBIEE12c
    We recently upgraded our application from 11g to OBIEE12c. In 11g. We had implemented cache purge using DDR as shown in the screen shot below. Here "ODBC_pool" was a con…
    Received Response
    DeepaliG-Oracle 1 view 1 comment Most recent by [Deleted User]
  • Joe-ATT
    Migration from OBIEE 12c to OAS 5.5
    I cannot find documentation describing how to migrate an OBIEE 12c environment to OAS 5.5. There are instructions for migrating from OBIEE 11g to OAS 5.5, however, those…
    Received Response
    Joe-ATT 172 views 5 comments Most recent by [Deleted User]
  • 4209109
    When last year = X then Y for this year
    Hi all, i'm fairly new to BI and using the complex SQL within a column formula of OBIEE. So bear with me if i don't use the correct terms but i really hope you can help …
    Received Response
    4209109 1 view 2 comments Most recent by 4209109
  • Steelbird
    How to create a bucketlist based on Date ?
    Hi Team,@Jerry Casey How to create bucket list in report based on date column? Below is the sample date.Yellow one is bucket list weeks and blue color is date column and…
    Received Response
    Steelbird 146 views 7 comments Most recent by Jerry Casey