-
OBIEE 12.2.1.0 Catalog Manager doesn't remember URLs
Back in OBIEE 11g, when you typed in a URL into the catalog manager, that URL remained cached in some kind of MRU list so, for subsequent sessions, you just needed to find it in the URL pull-down menu. When we upgraded to 12.2.1.3 (and later to 12.2.1.4), that functionality was lost. Also, we are not using SSL so I get…
-
DATA-SYNC Filters
Summary Need information about the Load Strategy Filters Content I need information in regards to the Data Sync / Load Strategy/ Filters. How do the filters work. What function do they serve? Are there any details that can be altered in regards to these filters? Also, is there anyway to see what is taking place when the…
-
OAC Catalog Manager - Proxy Settings?
Content Does anyone know where I can set Proxy server settings so that Catalog Manager can connect to OAC through Proxy Server? Version 19.1.x
-
Import Column and Table name descriptions to OBIEE RPD
Is there a way to import your Column and Table name descriptions to the RPD Presentation Layer instead of having to to defining one by one? Here is the screenshot: OBIEE Version: 12.1.3.0
-
OTM FTI Access Rights for a user
Summary OTM FTI Access Rights for a user Content Hello, I'm currently working on implementing OTM and trying to figure why for one user I have this : and for the other I have this (the user can't see folders from "Ad-hoc queries"): Is there a specific setting (in FTI...) for accessing this section? Thanks in advance.…
-
obiee12c services are getting shutdown after user logoff
My Installation details 1.Oracle 12c database enterprise edition (12.1.0.2.0) 2.JDK 8 Update 51 3.Fusion Middleware 12.2.1 4.Oracle Business Intelligence 12c (12.2.1.4.0) 5. Windows 2016 R2 64 bit Problem - I'm logging to windows server from Admin login and starting bi services from START.CMD file and everything works…
-
Copying from shared to personal folder best practices?
Hi All, Some of the user base is seeking to become more involved in light development ... possibly even creating some of their own dashboards. Currently, all of the dashboards are owned by IT, and as such are read/execute only. One of the suggestions was to copy a dashboard over to the personal folder (from the shared…
-
Filter using in expression and go to detail analyzes
Hi all I have some detail table ex. <MyAction> There is some ActionType - is attr of <MyAction> When i create AgregatedAnaliz i do: <month> <count of ActionType 2 and 3> <count of ActionType 3 and 4> Just using filter i do: someMeasure1: filter(<some measure> using ActionType in (2,3)) someMeasure2: filter(<some measure>…
-
CSV Export in BI Publisher Report.
In BI Publisher report, when we export it into excel it gives proper data. But when we export same report in csv format then it gives repeated rows.We are facing this issue in almost all our excel report, is there different layout structure needed for csv format?Please help.Thanks in advance.
-
How to calculate LTIFR using Analytics Cloud?
Summary Having issues combining 2 rolling totals calculations into an LTIFR Calculation Content I'm trying to calculate LTIFR using Analytics cloud (Total Lost time events from the last 12 months x 1,000,000 / Total hours worked from the last 12 months) So far I have been able to calculate the correct rolling 12month total…
-
OBIEE - Create Pie chart
Hiii dears, Every time I create the pie chart using 2 measure (Male and Female) the graph showing only one color for the slices, All i need to do is to create Pie chart showing percentage for male and female in each department (HR). Thanks
-
Return "Correct" Rank Values with Row-Level Security
Situation: The organization has three regions. The East Region has sales of $100, the West has sales of $200, and the South has sales of $300. If I create an analysis containing all three regions, include a rank of their sales, and run the analysis as a user with access to all regions, I see South ranked #1, West #2, and…
-
Date arithmetic in a Data Flow
Summary The functions available in the Data Flow tool do not provide arithmetic capabilities on dates. Content Hello, I uploaded a data set to the OAC, which includes a date field. I want to add a new date field which is 1 month later then the existing date column, resulting in a date range for each row. The Data Flow tool…
-
NULL Filter Values
Summary Hor do I validate, deal with, a NULL filter value? Content I placed in my filter box. (FieldValue = 'R') Yet sometimes there is no 'R' and my report blows up. How do we deal with that? Version 18
-
Analysis measure keeps automatically rounding percentages
Summary .4768594% on the database is displayed as 4.80%. How do I change it? Content ".4764594%" on the database side is displayed as 4.80% in an OAC Analysis. How do I change it to show 4.76%? On the application side, I tried modifying the Column Properties > Data Format > Override Default Data Format. Then I chose Treat…
-
Emulate the PLSQL (partition) in DV?
Summary Is there a way within the DV tool to emulate the PLSQL (partition)? Content Is there a way within the DV tool to emulate the PLSQL (partition)? row_number() over (partition by v_BUSINESS_UNIT, v_VOUCHER_ID order by v_BUSINESS_UNIT, v_VOUCHER_ID) rn Data Flow? Version 18 , Cloud Code Snippet select…
-
TLS 1.1 desupport test options
Summary Partner is looking for test environment to investigate TLS 1.1 issues Content Partner APRO in NL (EMEA) has issues connecting their application to Oracle BI. Apparently we have changed (on domain level) the TLS restrictions to desupport anything lower than TLS 1.2. This had a major impact on the partners…
-
Is current version of DVD compatible with MacOS 10.14 Mojave?
Summary Is current version of DVD compatible with MacOS 10.14 Mojave? Content Does anyone know?
-
Data-Sync Are double quotes required? Joins
Summary Are the double quotes required when writing joins in DS Content Team, when writing a JOIN in Data-Sync are the double quotes required? Version 2.5
-
BICS Data Sync
Summary Is a new version of Data Sync going to be available? If so, is there an ETA? Content Currently using BICS 2.3.2 and would like to know when a newer version will be available for download from OTN? Version BICS 2.3.2
-
Data Sync Date Variable
Summary Data Sync Date Variable Content Hi, I created a Variable "$$INITIAL_EXTRACT_DATE" with Below details While trying to use this variable in date comparison or insert the value in a Date field getting below Error. "ORA-01858: a non-numeric character was found where a numeric was expected". When i check the log file…
-
Create Muliple Jobs in Data Sync
Summary Create Muliple Jobs in Data Sync Content Hi, Can we able to create multiple jobs in Data Sync as below Job 1 -- Will move data from Source System to Cloud Stage Schema Job 2 -- Cloud Stage Schema to Final Cloud Schema (DW Schema) I created Connection As below And Created 2 Jobs: In Job1 - Mentioned Source as "Src"…
-
Method to modify property for all graph?
Hi (again) Not sure about this one ... but, worth probing the collective wisdom of the board. Users want to make some adjustments to some dashboard features/layouts. In one such case, they'd like to change all the graphs from 3D to 2D (all graphs are currently displayed as 3D). I know that I can do this by going into each…
-
Cross-subject area prompts on dashboard
Hi All, We created a dashboard which is based on a cross-subject area analysis. The data looks good, but we have to use two dashboard prompts to get it that way (both on the column used for the cross-subject area analysis - one on each subject area, respectively). Is there a way to have only one prompt on the dashboard,…
-
OBIEE services not up
Hi Experts, One of our OBIEE server services not up specially analytics after power failure. <Error> <oracle.webservices.service> <OWS-04115> <An error occurred for port: {http://oracle/bi/security/}SecurityWebServicePort: oracle.fabric.common.PolicyEnforcementException: PolicySet Invalid: WSM-02302 o…
-
Design Consideration for Very Wide and Very Deep Table
We are a eCommerce retail business and are debating how to handle the addition of 25 new columns to an already wide (125 columns) and deep (21 million) table (email/customer). The new fields won't be used by as many people as some of the existing. We are debating between adding the 25 to the email table, or creating a new…
-
Unable to save dashboard
Hi , I am using OBIEE 12.2.1.2.0 When i try to save dashboard, it says 'path not found'. Does anyone knows why is this happening. I tried to save it on different location, restarted services, cleared cache etc.. but nothing helps. Did I miss something??
-
Date prompt in OBIEE analysis
Hello, I need to create a date prompt as From Date: and To Date: for the date column with default values as blank. how to create the variable prompt with default blank value but when the user wants to select, they should be able to select using the calendar. Thank you in advance.
-
BI Admin Tool connection to Oracle Db
Summary BI Admin Tool cannot connect with tnsnames Content I'm trying to use the latest BI Developer Tools version (12.2.1.5.0). The Admin Tool can't connect to an on-prem Oracle DB with a tnsnames alias. I have to enter the entire connection string that's in tnsnames.ora. Is that normal? I used to be able to connect with…
-
How to prevent a valid LDAP user with no authorization from accessing OBIEE 12.2.1.4.0
Hello Experts, We have OBIEE 12.2.1.4.0 on Linux. we are using Sun Directory Server as our LDAP server for storing Users & Groups. we have mapped the LDAP Groups to corresponding Application Roles and granted access to catalog objects to these application roles accordingly. We have a situation where we need to deny access…
