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

  • 4049330
    OBIEE BIPLATFORM and MDS schemas were deleted
    Hello Experts, We have installed OBIEE in the LINUX box. Due to some reason, OBIEE schemas were deleted in the database. No rollback concept in the database. If I create…
    Received Response
    4049330 1 view 1 comment Most recent by [Deleted User]
  • ToolTimeTabor
    Newie needs help understanding differences between OBIEE vs NOETIX
    Greetings, I have recently been working on a NOETIX BI upgrade that was very problematic. Since then, I have moved jobs and been asked to help with establishing a BI sys…
    Received Response
    ToolTimeTabor 118 views 6 comments Most recent by ToolTimeTabor
  • User_15J6I
    OBIEE LOG
    Hello, can someone guide me in reading the obiee log? I have the following error [nQSError: 59001] Join operation is not permitted on Binary Join operand (s). When look…
    Received Response
    User_15J6I 6 views 1 comment Most recent by Joel Acha
  • Adam Wickes
    OBIEE 12c User Impersonation
    Hi all, Has anybody been able to get user impersonation working on 12c? I have followed the doco in the following ticket and just end up with a blank screen when enterin…
    Received Response
    Adam Wickes 2 views 1 comment Most recent by Adam Wickes
  • user13001889
    obi server service issue
    Recently my windows 7 machine installed some updates which after that my obiee 12c obis1 services status changed to "UNKNOWN".I tried rebooting the machine and services …
    Received Response
    user13001889 81 views 4 comments Most recent by user13001889
  • 3601907
    ROW COUNT ISSUE WHEN USING CASE STATEMENT IN A COLUMN
    Hi, I have a report which has a case statement in one of the columns. When I use a formula to get row count I am getting an incorrect row count. When I remove this colum…
    Received Response
    3601907 72 views 2 comments Most recent by Robert Angel
  • Jaspal D
    12c Migration - Aggregation issues
    Hi, Recently my original files were migrated from 10G to 12C. I have noticed that especially on Pivot Table view there are issues aggregating data, e.g. issues relating …
    Received Response
    Jaspal D 1 view 2 comments Most recent by SonPat99
  • user12863665
    variabilize DSN in connection pool
    i am using 12_3 version of obiee. i would like to variabilize DSN info in connection pool. basically i don't want to change any connection details as part of migrations.…
    Received Response
    user12863665 1 view 2 comments Most recent by SonPat99
  • 4104637
    Moving Folders under shared Folders to Parent folder
    Hello Everyone, I have Folders F1, F2, F3 under shared folders and I would like to move them under different folder (Z1) under shared without breaking existing dashboard…
    Received Response
    4104637 1 view 9 comments Most recent by Gianni Ceresa
  • Jerry Casey
    Gauge View injects strange columns in SQL
    We recently upgraded from OBIEE 12.2.1.3.0 to 12.2.1.4.0. We had some very simple Gauge displays that are now throwing errors: The highlighted SQL doesn't appear until a…
    Received Response
    Jerry Casey 11 views 2 comments Most recent by Jerry Casey
  • User_B7ZTH
    Need actual path/location
    Hello Experts, I have to move the list of reports from one environment to version control tool. Path provided by enduser are like: ex: Report path: /shared folders/Logis…
    Received Response
    User_B7ZTH 23 views 4 comments Most recent by Gianni Ceresa
  • 3713479
    Dashboard downloads share single worksheet
    One dashboard page contains multiple analyses. When downloaded to Excel, all analyses share the same worksheet. The goal is to have each analysis have a separate workshe…
    Received Response
    3713479 2 views 3 comments Most recent by [Deleted User]
  • User_E9OMM
    Need assistance for the logic to create one column in OBIEE
    Hi All, I have a report. It looks like this : I have to add one more new flag column in the report. Logic is - If for a given year (2016) - employee has two different Ma…
    User_E9OMM 1 view 1 comment Most recent by Joel Acha
  • Kari_100683-Oracle
    Finding Physical tables/columns used in OBIEE catalogs
    Hello, I am new to OBIEE. I'm trying to document physical tables and columns used in a obiee catalog without running the catalog. Also need to document which text column…
    Received Response
    Kari_100683-Oracle 1 view 2 comments Most recent by Gianni Ceresa
  • User_E7LPO
    Can we display empty table view?
    Hi, I have a analysis which is tabular view, I have selected some criteria. When there are no results for selected criteria, can we display empty tabular view with just …
    Received Response
    User_E7LPO 1 view 1 comment Most recent by Joel Acha
  • Community DW Integration
    LEFT & SUBSTRING functions not working in RPD
    Hi, OBI 11.1.1.9.0 Using OBI Admin Tool, I created 2 Logical Columns in BMM which is derived from an existing column using the below formula. However OBI is still displa…
    Received Response
    Community DW Integration 384 views 4 comments Most recent by Community DW Integration
  • User_E7LPO
    Changing the Grand total label of a Pivot table to Column value
    Hi I have a pivot table analysis which is sectioned based on name and Class. I want to change Grand Total label with a Name and Class. Is it possible to achieve this? Th…
    Received Response
    User_E7LPO 213 views 6 comments Most recent by Jerry Casey
  • User_MSQS7
    install OBIA 7964 on obiee 12c
    Dear Experts, Is it possible to install OBIA 7964 on top of OBIEE 12.2.1.4.0 Operating system: windows server 2016 DWH: SQL Server 2016 Planning to install below setup =…
    Received Response
    User_MSQS7 1 view 1 comment Most recent by [Deleted User]
  • Deepak_R-Oracle
    OBIEE is forming two queries
    In OBIEE 12.2.1.3.0 Whenever any fact table is queried, two queries are issued(one to get distinct dimensions value and another to get fact data). Ideally only one query…
    Received Response
    Deepak_R-Oracle 370 views 19 comments Most recent by Deepak_R-Oracle
  • mmajdana1
    Path not found
    Hi i am using OBIEE 12.2.1.2.0 When i try to save dashboar on location Shared-->Components--> Dashboard it gives me the messeage path not found. Has anyone encountered t…
    Received Response
    mmajdana1 11 views 2 comments Most recent by mmajdana1