-
Oracle Analytical Could - Language Support
Summary OAC - Visualizations to show in local language Content Hi Experts, Need to show the visualization heading and all texts displaying on visualization should be in local language instead of English. This functionality is supported by OAC?
-
OBIEE Analysis to PDF download formatting issue
Dear Gurus, I'm using OBIEE 12.2.1.4 I have created a sample report using Sample Sales Subject Area. When downloading the same in PDF Format, I'm seeing formatting issue for the 1st column only. This Analysis is in PIVOT Format. Actual Analysis: PDF View: What I have observed is that if I increase the width of result, it…
-
When trying to use uploadrpd command, the following error occurs:
When trying to use uploadrpd command, the following error occurs: uploadRpd Failed: Failure in trying to acquire lock. Check bi-lcm-logs or diagnostics. Error Desc Code: DESC_CODE_SERVER_EXCEPTION. ++++++++++++++++++++++++++++++++++++++++++++++++++ service.xml is not empty and checkbox for RPD Update No Allowable is…
-
OBIEE 12c : Any place in RPD where we can assign/mark a physical data source as OLTP ?
Hi Gurus, I would like to know if there is any place in OBIEE RPD where we can mention (assign/designate) a physical data source as OLTP ? Please share inputs. Thanks.
-
OAS DV Auto Reload Data from Excel
Hello, Please let me know if i made this post in the wrong group. I tried searching for OAS Group but didn't find any. We are currently testing OAS 5.5.0. One of our requirements is to directly import data from BI Publisher into DV and create visualizations on op of it. I tried searching on ways to do that but didnt find…
-
Can OBIEE version 11.1.1.9 run on Oracle 18c database?
I upgraded the application's database from Oracle 11.2.0.4 to Oracle 18c. Now the app team says that the OBIEE module is not running. The version of OBIEE is 11.1.1.9. Will the app team need to upgrade the OBIEE?
-
Hierarchy Expands All Similar Keys
Using OBIEE 12.2.1.4 I have created a hierarchy with 4 levels. When I expand Level 1, all of the values for Level 2 are displayed. When I expand one of the Level 2 values, all matching level 2 values are displayed as well. An example looks like this (everything expanded): Total --Region 1 ----Sales Dept ------John Doe…
-
Obiee 11g report issue with load balancing
Hi folks, We are using Radware to balancing 2 obiee cluster application servers . Let's suppose balance ip address is A two application ip address are B and C. We have a customized new font added to all obiee reports. Customization has been made on both two obiee servers. When we deploy reports to http//:A:9704/analytics…
-
How to change to the decimal column display unit on union report.
Dear guys We have a display unit issue here. There is a report with two union requests. Our request is to display the fact measure column in graph in tens of thousands unit. So we got this measure column calculated "/10000" for each union request, then the result comes out wrong number. If we remove the calculated…
-
After SSO Config in OBIEE11g we are facing - [nQSError: 13052] The authentication has exceeded the a
We are facing the below issues after configuring SSO 1. [nQSError: 13052] The authentication has exceeded the allowed amount of time 2. EM,Console page not showing up
-
Reporting through query API
Hi All, I have query related to data access through query API. Do we supply query via HTTPS request and query API returns a JASON response? is there other ways for querying and viewing results? If I write a sql query (example select * from Table), how it will be converted to query rest api format? QUERY REST API is QUERY…
-
Problem joining tables
I am trying to join a new dimension to some fact tables that already exist. The Fact tables are all from the same physical table but have different aliases in the RPD. The join is a complex join using two columns. When I select columns from the Fact and dimension in an analysis it produces the "No fact table exists at the…
-
calculating employee salary in a given date range
let us know how we can achieve this at the rpd. Example: we want to get total salary of a person in mutliple departments in a specific date range.
-
DEV_MDS, DEV_BIPLATFORM password expired
Hey Guys, Usually we restart our BI servers once every week, When i tried to restart this week strange thing happened after successful shutdown, The server didn't come up only node manager was coming up both admin and managed servers were down. When i checked the logs got to know the DEV_MDS and DEV_BIPLATFORM passwords…
-
Sort columns with Links in OBIEE and case-insensitive
Dear Experts, We are on OBIEE 12c (Version: 12.2.1.4.19087) Problem Statement: I have created a report where one of the columns is having HTML link enabled and the display column is different as below: "'<a target="__blank" name="'|| "COLUMN_TO_BE_DISPLAYED" || '"…
-
AD Integration - any User can Authenticate with any Password.
Team, I have done AD integration and i am able to see all the users in weblogic console. But challenge is any User can Authenticate with any Password. for example username- kjdnkjandkja Password = dnsadnaj also able to login to obiee. Version =11.1.1.9.160119 (Build 151227.0323.02 64-bit) followed similar steps:…
-
OAC to onprem MySQL using RDG
Summary OAC to onprem MySQL using RDG Content Hi All, we are trying to establish a connection from OAC to on-prem MySQL (version 5.6) database. As per OAC documentation, connection to on-prem MySQL is possible only through Remote connectivity Datamodels. We have successfully configured the RDG and we're getting the XML…
-
How to do transpose in OBIEE and also eliminate null values
Hi I have a OBIEE report which displays report in below format Employee NumberQ01A01Q02A02Q03A03Q04A04Q05A05Q06A06Q07A07Q08A08Q09A09Q10A10Q11A11Q22A22Q13A13Q14A14Q15A15Q16A16Q17A17Q18A18Q19A19Q20A20A21Q21Q22A22Q23A23Q24A24Q25A25Q26A26Q27A27Q28A28Q29A29Q30A30FunctionAsset…
-
How to create Header in Measure Label Column in Pivot Table ?
Hi Team, I want Create - Measure Label Header -in Pivot Table How to create this part? Like this Thanks Nagarajan K
-
OAS 5.5 Data Flow Error
Summary OAS 5.5 Running Data Flow Error Content I have performed an out of place upgrade and imported a BAR file into the new OAS instance and all looks great. I am trying to get a data flow to work but I get an error with not much clues as to what may be the root cause when I attempt to run the data flow. Firstly, could…
-
REGEXP_REPLACE Credit Card Number with 'X' in obiee report
Hi @Team, I had a requirement where I need to replace the Credit Card number with 4567123789762344 to XXXXXXXXXXXX2344. I am using this query in Back end data base where I Can accomplish the task but how can we implement it in reporting. Sql Query: Select REGEXP_REPLACE(SUBSTR('1234567891234440',1,'1234567891234440'-4),…
-
Viewing BLOB attributes in OBIEE
Hi, I have a table in an Oracle database with documents saved in BLOB format. I want to show this through OBIEE in a browser. Column is already added with LOOKUP function tot eh BI Server so that is OK, but I need the last bit where I can view the (mainly PDF's) in browsers. Any help would be highly appreciated. Regards…
-
Why OTBI can be preferred choice for operational reporting
Hello All, I am wondering that why OTBI can be preferred choice for operational reporting over OAS, OAC, OBIEE-Visual Analyzer and DVD/OAD. What features make it unique for operational reporting needs. Does it offer advantage over other and above mentioned tools with respect to cost, size (RAM/Cores/platform), ease of use,…
-
Difference between query tools and reporting tools
Hello All, I often hear term query tools and reporting tools in Analytics. However need to know what is difference between query tool and reporting tool? Can you please give examples of query tools and reporting tools offered by Oracle and some other non oracle popular query tools and reporting tools? How query tools and…
-
OTBI related queries
Hello All, Let me seek your view on below queries: 1) Is OTBI (Operational Transactional BI) part of OBIEE or different tool all together? 2) Is OTBI is supported/compatible and widely used in OCI (On cloud infrastructure environment)? 3) Is OTBI also available with OAC (Oracle Analytics Cloud) stack? 4) Is Cloud version…
-
Documenting all Rpd logical and Physical Joins to csv file
Hi Experts, I have a requirement to list all the obiee rpd joins into csv or excel file.can anyone of you help me to gather all the information in the efficient way to csv file as it takes lot of time to do manually and in thr utilities-> repository documentation is not giving this kind of information. Thanks & Regards,…
-
Comparative Analysis: DVD Vs Visual Analyzer Vs OACS
Hello All, Please help with comparative analysis for DVD Vs Visual Analyzer Vs OACS for operational reporting? Pros and Cons with respect to cloud environment will be helpful. Thanks, Rajneesh
-
Filter using presentation variable All values
Hi All I have a date prompt which am using it on a measure column with "Filter Using" function. The syntax am using is The date prompt has "All Column Values" by default with multi select option. With this syntax Filter( sales using order date=@{date_variable}) when I select multiple values, the columns works as expected…
-
Natural Account Description limited to 80 characters
In OTBI the natural account description is limited to 80 characters, even less in practice as the description field is a concatenation of the flexfield segment value and the description. The description in General Ledger (table FND_FLEX_VALUES_TL) is 240 characters. So I can't get the whole description on an OTBI report.…
-
What are the Limitations of OAC DataSync for incremental data load
Content Hi, Please share the limitations of OAC DataSync(version 2.6) while considering incremental data load. Thank you, Sowmiya R Version 2.6
