-
Report Links (Export, Analyze & Others) in Dashboard disappear
Hi I have enabled and selected specific report links ( Analyze, Refresh, Export etc) at the dashboard level, and page level and even analysis level but for some reason and only for one dashboard the links option appear for a quick second but then they disappear and look like this: highlighted in yellow, any idea what is…
-
Required Prompt Returns Data When No Value Chosen
We have a requirement where one of our dashboard prompts is required. When we first open the analysis, there is no default value specified for that prompt, so at the outset, there is no value selected there. However, the report still runs showing all records. How can I prevent that report from displaying any records until…
-
How to apply Wildcard Certificate to local OBIEE URL?
Hello, our OBIEE 11.1.1.9 and OBIEE 12.2.1.2 Wildcard Certificates have been expired, can you please let me know how to apply the replacement wildcard certificate? this is a paid cert. appreciated any help!!
-
12c Application Role changes taking a long to update
Hi all, We are finding that any changes to our 12c application roles are almost taking overnight before they are reflected in the presentation layer. We have tried the following: - Added user to existing application role - Refreshed biserver cache using "call sapurgeallcache();" - Refreshed browser cache - Reloaded…
-
OBIEE 12c - is there drill-up functionality using dimension hiararchies ?
Hi Gurus, Wondering if drill-up can be achieved in OBIEE 12c for the dimension hierarchies. For Ex: If the drill down is : Country --> state ---> city (USA ---> Texas ----> Houston ), can we roll back to Texas if we click on "Houston" ? Please share inputs. Thanks in advance.
-
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 import tables etc. When i click View data i can see data , but when i publish it on server and open RPD online i cant see data anymore when i ho on table-->…
-
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-4803-9B99-5A4C64F68D6C.htm#BIESC374 When I get to this part here: Configuring OWSM to Use t3s, on my setup it does not say "Out of Sync", it is "Wired".…
-
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 me some other date. Can you help. Kr, Matija
-
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 changes. Current RPD logic: PS and F are main tables where I expect to see all records of WRno from PS mandatorily that looks related information in F…
-
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 patch but when I try and apply the patch to 12.2.1.4, opatch says that it's not required anymore. Any thoughts?…
-
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 have tried with logical column formula, but it is giving error while doing consistency check. I am using OBIEE 12c. Thanks Anirban
-
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 show above table and insted to show the select text I need to make a link to run the query in deterrent analysis based on row id. Note each row has different…
-
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 under DWH Staging schemas, joined the tables as per requirement, created BMM and Presentation, it is working fine Fig.1 Tried with two connection pool…
-
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 have ADW as database, and i dont know how to connect to it. On my OAC i use this same database and this connection parameters to connect RPD to database and…
-
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 refreshed once a month). I have tried to seed the cache using an agent but it doesn't seem to be working. Is it possible to seed cache for all values of the…
-
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 Category value / Grand Total * 100 The same for other Months. The output should be like the following: I've tried calculated elements and other stuff, but it…
-
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 a line to show the change in yes/no rate, while the bars represent the volume of both. I am using two identical measures, one showing data as values and…
-
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 connect OBIEE 12c RPD to Oracle 12c DB but not able to connect to oracle 12c DB from OBIEE 11g RPD (OBIEE 11.1.1.7.0). Can you please let me know if Oracle…
-
Oracle analytics Desktop configuration limit
Content Hi all, I am working on Oracle analytics Desktop to build ML models. However, the system quits because of configuration limits. what is the right way to handle such an exception? and how to change the cash limit?
-
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 not. I've tried to manipulate the XML in the advanced tab, but I doesn't work. So I found only the code for the cell of the group, but no place where to…
-
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 site points to using SAML 2 for this in OAS. My question is does the Linux platform of OAS support support Kerberos based single sign-on?
-
BI publisher report not coming for huge records
Summary does BI publisher report not come for lot of records Content I created BI publisher report. The report got displayed when it had 1 row but when it had 2,668,926 rows the report didn't got displayed. It gave loading template from past 15 mins and after that got session inactive error. Is there any limitation on…
-
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/GUID-7AB19BAC-5506-4FBB-B9B1-03FF875EBC3C.htm#BIPDM296 demonstrated that to add a Global-Level Element by PL/SQL after specify Oracle DB Default Package in…
-
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 connection pool defined in RD, it was using default system DSN "AnalyticsWeb". The above setup was working fine in 11g, but when we migrated to 12, the above…
-
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 procedures result in errors when I attempt to perform them in the OBIEE 12c environment. There are instructions for migrating to OAC, but I need to…
-
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 with my query! I want to do the following. I work in Retail and for our stores we count visitor data (footfall) and eventually if someone buys something,…
-
Join two or more thematic areas in BI analysis for maintenance module.
Summary I need to know how to join two or more thematic areas in BI analysis for maintenance module or different modules Content Hi everybody The thematic areas that I want to join are Maintenance Management - Real Time Work Order Performance and Installed Base - Use of Assets Based on Real Time Meters, when joing the…
-
Presentation variables option in OAC DV Project
Summary My bad, I wanted to know if there is an option to create "Presentation Variables" within OAC DV. If the answer is NO then is there any other options/alternate solutions available. Content If the functionality is not available then I will raise it as enhancement request. Version 105.5.0-290
-
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 other one is measure column. To build Bucket list based on date column and display up-to 12 weeks and rest will go to the 13week. Thank you, Steel.
-
OBIEE 12C Query Limits
Hi all, Hopefully a fairly simple one. We have about 50-100 application roles and about 20-30 subject areas in the RPD. I want to apply a rule where EVERYONE except Administrators is limited to a query limit of <= 60 minutes. I know I can do this manually in the RPD identity management but this will take me an eternity. Is…
