-
Unable to scroll longer lists in OBIEE 12c - Linux Env
Hi All, We have OBIEE 12.2.1.4.0 installed on our linux server. We have observed that longer menus like dashboards in analytics or the weblogic domain list in the EM are not scroll-able. We have to reduce the browser font size to view the full list. We have tried on different browsers and still see the issue. Can you…
-
Getting error while trying to run config.cmd in OBIEE 12.2.1.4.0
Hi All, We are trying to install OBIEE 12.2.2.1.4.0 in windows 7 machine. While trying to run the config.cmd command we are getting the following error: Please let me know if there are any solution to this as we have tried one of the solution suggested by oracle support which is to check spaces while setting environment…
-
OBIEE11.1.1.9 Installation stops at " Setting up BI Publisher",windows 10
Hi All, I'm trying to install OBIEE11.1.1.9 in my local machine (Windows 10). The Installation (Simple) stops at " Setting up BI Publisher". Checked in log file , it shows : 'export' is not recognized as an internal or external command, operable program or batch file. Please help me how can i resolve this issue. Thanks in…
-
How to calculate Business Hours in a Report
Hello All, I have a create_date column which is in date format. I need to calculate the SLA timings based on create_date column. I must exclude saturday and sunday and consider business hours like 8 am to 6 pm. I dont have time dimension and dont have rpd access to . I should do it report only. please help
-
Legend Width
Summary Legend Width Content I notice my legend stacks on top of each other when there is ALOT of room to the left and right, i'd like it to all be on one line instead of on top of each other. is there a setting i can change to do this? thank you.
-
OBIEE 12.2.1.4 - Tabs still visible in a dashboard page after drilling
Hi all, I have a problem in OBIEE 12.2.1.4 with Drill Down. I have 1 dashboard with 3 tabs (2 visible and 1 hidden). By clicking on one value from a report on Tab1 to drill to a detail report in the hidden tab, OBIEE is opening a new dashboard page with the entire tabs (all the 3 tabs). In the previous version of obiee…
-
Fact is not showing data Against the Dimension..
Hi All, I am creating an Analysis in 11.1.1.7. I am creating the analysis using the 2 different Subject areas. In the analysis I am using the 3 columns, like, Subject_AREA_1.Date | Subject_AREA_2.Fact_1 | Subject_AREA_2.Fact_2 Jan-15 | 12548 | Mar-16 | 12548 | Aug-15 | 12548 | Jan-15 | 12548 | Jan-15 | 12548 | In…
-
Export data type in OBIEE
I have a problem when exporting a data type date in OBIEE12c the export in excel brings time (datetime) someone knows why this happens and how can I correct it? Thank you
-
Pivot table showing NULL row in OBIEE12c
We have a report with multiple pivot tables , each showing the measure based on a different dimension value. But even after setting properties in "Pivot Table Properties" for (Null Values - Include rows with only Null Values is unchecked) we are still getting a NULL row in the pivot table. we are trying to find an…
-
BIAPPS - HR - Headcount figures showing incorrect data
I have BIAPPS implementation project. We have installed and configured all the system but we are facing issues with HR data extraction as not all employees are extracted from the EBS 12.2 so the headcount and other numbers are incorrect.
-
OracleBIJavaHostComponent Stuck at 'Stop' Status with Same PID - OBIEE 11.1.1.9
Hi, This issue is with my OBIEE 11.1.1.9 The OracleBIJavaHostComponent is not starting. It seems, somehow, opmn thinks it's running. Below is the output of the current status. The OracleBIJavaHostComponent has remained the same after several restarts After stopping all and starting only opmn, the status remains the same I…
-
Lock OBIEE/access during data load
Hi, We are loading data weekly (on Sundays) and on 1st day of the month (possible that will be on week day). Are there any mechanisms which will give possibility to lock access to OBIEE during data load process? We have information when data load is planned on welcome page, but users are often trying to open reports before…
-
SSL Configuration issue on 12.2.1.4.0 with nodemanager
I am upgrading from 12.2.1.2 to 12.2.1.4 and I have configured SSL the same on .4 as I did on .2 however when I try to start the Severs the nodemanger is failing to start. I am on a windows server. I get the following error: D: \OBIEE12c\user_projects\domains\bi\bitools\bin>start.cmd -i AdminServer BI_PRODUCT_HOME set as…
-
Parameters Failed to Load on BIP Using List of Value
Content Please help , Parameters are not loading whenever the rows exceeds more than 200 in List of values.
-
login to data visualization in OBIEE 12.2.1.4
I want to login data visualization directly as analytics(http://host:port/analytics/saw.dll?bieehome&NQUser=USER&NQPassword=PASSWORD) in OBIEE 12.2.1.4. If I don't disable lightweight sso, login using Go URL is not working in analytics. If I disable lightweight sso, login using Go URL is working in analytics but for data…
-
RPD. CAST in BMM
Hi, What is wrong with this formula: CASE WHEN "WORKFORCE".""."HRDWH"."DimRating_MD"."EP_RATING" = 999 THEN 'Not Rated' ELSE CAST("WORKFORCE".""."HRDWH"."DimRating_MD"."EP_RATING" AS CHAR(1)) END that it do not work when placed in RPD BMM as derived from physical mappings? In OBIEE still 999 is displayed instead of 'Not…
-
Warnings while Starting OBIEE after upgrade to OBIEE 12.2.1.4.0.
Hi All, We upgraded to OBIEE 12.2.1.4.0 from 12.2.1.1.0. After upgrade, services are getting started and users are able to access OBIEE. But we notice few warnings while starting BI server. Full text is attached. Let me know if any else see the same warnings in this version. OBIEE Version : 12.2.1.4.0 OS Version : Windows…
-
How do I calculate the pYTD (previous year to date) value?
Hi, I'm using Oracle Business Intelligence 12.2.1.0.0 and I'm struggling to calculate the pYTD. I've managed to get the YTD value using ToDate("Measures"."Revenue", "Time Dimension"."Year"). I tried pairing this with AGO("Measures"."YTD", "Time Dimension"."Year", 1) to get the pYTD. However, it's giving me the previous…
-
How to rotate the obis1-query log
We are troubleshooting some queries in OBIEE and our obis1-query.log is reaching 100MB. Is there a way to archive/rotate this log manually? thanks Dan University of Pittsburgh
-
Obiee 12c Repository Variable Refresh Problem
Hi, We use following obiee version in our company. Our problem: repository variables is not updated automatically. This is not for all days but some days. For example, today this problem occurred. Our repository variables = rv_yesterday (which includes yesterday value, including select statement from dual), it returns two…
-
Changing column with GMT time to EST accounting for daylight time savings
I have a column that stores last runtime of an OBIEE agent in GMT. I am in EST (New York time). I would like to change the times stored in the last runtime column to EST taking into account daylight savings time. I used this formula to change the time from GMT to EST TIMESTAMPADD(SQL_TSI_HOUR, -5, "Jobs"."Last Runtime Ts")…
-
Unknown User Principal found: authenticated-role
OBIEE: 12.2.1.3.0 (Build BIPS-20170820114118 64-bit) OS: Linux 3.10.0-862.11.6.el7.x86_64 #1 SMP x86_64 x86_64 x86_64 GNU/Linux (i.e. RHEL 7) Out-of-place upgrade from 11.1.1.7.180417 I can log in directly to OBIEE at http://server.com:9502/analytics However, as I'm now behind an F5 and all the attendant VIPs and Pools, I…
-
OBIEE 12c: DB Repository migration from 11g to 12c
Hi guys, fist of all I want to state my versions I am using for the upcoming scenario / question: OBIEE: Version 12.2.1.1.0 Oracle Essbase: Version 11.1.2.4.008.28 In the next two months our Oracle database administrator is on planning to migrate all our Oracle databases (EE) from version 11g to 12c (on a new server) and…
-
OBIEE 12C Copy option Report Links
Hi Guys, We have upgraded from 11g to 12C version in OBIEE, In one of my dashboard I can still see the copy option at the bottom of the dashboard page which I haven't enable it I have gone and check the options in Dashboard properties with Report Links: changed to Customize and left Copy option unchecked, still appearing…
-
SmartView VBA Hitting Center on Cascade
Summary SmartView VBA coding Content Greetings, doing some development to add vba to automate cascading and zooming. The two functions on there own are easy enough however, with the Cascade vba function, HypMenuVCascadeSameWorkbook. However, this function just brings up the menu so, the enter needs to be click on to run…
-
Accesing Data from OAAC (Oracle Autonomous Analytics Cloud) Object Storage
Summary Accesing Data from OAAC (Oracle Autonomous Analytics Cloud) Object Storage
-
OBIEE 12c: Substring Dashboard prompt
Hi guys, fist of all I want to state my versions I am using for the upcoming scenario / question: OBIEE: Version 12.2.1.1.0 OBI Administration Tool: Version 12.2.1.1.0 Oracle Essbase: Version 11.1.2.4.008.28 We are trying to implement a dashboard prompt which is directed to an analysis within Oracle BI Anwsers. The data…
-
Obfuscation in DV 5
Summary Data Preparation query re obfuscation Content Experts, I'm playing around with the data preparation features in DV 5. I like the obfuscation feature. Is there any way to apply a similar style of masking over any custom field, such as masking all character with another character or providing a pattern (such as mask…
-
Privileges Dashboard
Content Dear All, how to implement privileges in DV ? i have dashboard and how to implement privileges,i need some dashboards should be visible for employees only and some dashboards should be visible for hr departments only and some dashboards should be visible for CEO only. Best Regards, Abdelrahman
-
Uploading Data(Excel File) to OAAC (Oracle Autonomous Analytics Cloud)
Summary How to Upload Data to OAAC (Oracle Autonomous Analytics Cloud)
