-
OBIEE 12.2.1 - How can I stop a new Analysis from running automatically?
Hi I have created a new analysis and added it to a Dashboard together with a Dashboard prompt. Is there an easy way to stop the new analysis from running as soon as the dashboard is opened before you have had a chance to enter in the filters required? Thanks
-
How to Publish a generic message for users to see when they log into OAC
Summary How to Publish a generic message for users to see when they log into OAC Content Hello, We want a way to notify/publish a generic message to users who have logged into OAC and are in system. The message can be shown on the home screen etc. The generic message can show-up during any of the below example scenarios.…
-
BIP API - schedule and email report
Summary BIP API - schedule and email report Content Hello, I am following: Oracle BI Publisher Consulting: How to Schedule a Report with BI Publisher Web Service? , but the part of : Example: DeliveryRequest dr = new DeliveryRequest(); dr.setEmailOption(em); is giving error. Opening the class(DeliveryRequest) i found it…
-
BICS: Missing services from user home dashboard
Summary BICS: Missing services from user home dashboard Content Hi All, Any idea why user can't see services in his home dashboard (first screen just after login)? Services are only available in user menu (right top icon). How to add missing services to user dashboard during user account creation? Many thanks in advance.…
-
Failed to add view to a compound layout
Hi , I am using OBIEE 12.2.1.2.0 i got this error Assertion failure: false at line 18 of handle.cpp Message: PN3saw20ViewComponentContextE when i try to add view (table) to compound layout. Does anyone know why is this happening?
-
Order by value the measures in a pivot table or in a graph view
Hi! I'm an user of OBIEE 11g I have some measures divided by months, and a total of the year (rolling) of the same measure. Take the following table as an example MonthMeasure1Measure 2 Measure 3Gen 5.38%2.09%1.28%Feb5.42%2.23%1.51%Mar5.71%2.26%1.60%Apr5.71%1.99%1.4%TOTAL5.52%2.19%1.46% I want to order in a automatic way…
-
Using Oracle Flashback Data Archive (FDA) Tables data for reporting in OBIEE
Hi, We need your help in implementing one solution. We are trying to use Oracle Flashback Data Archive (FDA) Tables data for reporting in OBIEE. We need to use "AS OF <TIMESTAMP>" while querying the FDA table as we might have to show the data in table as of a particular Timestamp. In RPD, we tried using Opaque view to…
-
Rank function before filter obiee 12c
Dears, Customer Dashboard Trying to develop a customer dashboard. Need to filter report by customer ID. But we need to display rank of customer by overall customers. As we are filtering the report for specific customer ID unable to use rank(income by None). can somebody help to resolve the issue. Precalculating the rank…
-
BICS - How to create a drill down hierarchy
Hiiii all, I need to create a drill down hierarchy for example in AR aging report : the amount showing in each bucket when I press it it should break down into customer details with amount then when I press on this account under the customer it should get the invoice for the selected customer with it's details. Thanks
-
Data Visualization for Desktop Mac connection to SQL server
Content Stating the obvious, I am sorely new at this and am only posting my question as I couldn't find anything related to what I am needing to do. Which is, how do I establish a connection from DVD for Mac to a SQL server? The only connection types available are Oracle and don't see where/how to add one for SQL.…
-
Connect multiple OAC instance to Single RDC
Summary Connect multiple OAC instance to Single RDC Content Can we connect Multiple OAC instance via Single Remote Desktop Connector (installed on on premise weblogic) to multiple on premise databases .We have load balancer or http server or reverse proxy server. installed between RDC & DMZ. How can such connectivity be…
-
QR Code tag in BI Publisher latest version 12.2.1.4
Summary QR Code tag in BI Publisher latest version 12.2.1.4 Content Hi All, I have installed BI Publisher 12.2.1.4 and trying to implement below qr code in RTF template https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/2d-barcode-functions.html#GUID-E0D697B1-0B13-46A3-8578-1FE933F1A86D but every time exception is…
-
Multiple If Conditions in One Row RTF Template
Summary Multiple If Conditions in One Row RTF Template Content Hi Guru's, I have a quick question on creating a RTF template and was wondering if anyone has had the experience of the similar issue in the past. I have a RTF Template with 6 columns , Where I want to put a condition that If Category is Payment show me the…
-
DAC - stopping Runnable or Queued Execeution Plans
I want to stop an Execution Plan that hasn't started, but is already in the Current Runs, in either the "queued" or "runnable" status. 1. Abort - can't abort before a plan is running 2. Tasks - can't change status of tasks because until the plan starts to run, the tasks do not display 2. Scheduler - scheduler sees these…
-
Install OBIEE 11g on Solaris 11
My question is, do we need to create project in Solaris 11 for OBIEE 11g installation?
-
#OBIEE
Hi! Somebody can help with this error? Estado: HY000. Código: 59161. [nQSError: 59161] Los valores generados durante la ejecución de la función SumUInt32 han excedido el tamaño máximo permitido, cambie la función para asegurarse de que los valores son mayores que 4294967295 no se han generado. (HY000) Thanks ESM
-
OBIEE web catalogue migration from 12c to 11g
Hello, Due to certain reasons, we are having to downgrade OBIEE 12c to 11g. There are around 5 dashboards and 40 reports and many more front end objects are present in OBIEE 12c. We have to migrate the code to OBIEE 11.1.1.9 Can you please suggest the best approach to execute this task? Thank you. AB
-
OBIEE 12c Version 12.2.1.4, error for 5 numeric columns where 1 column is appearing as 0 in analytic
Hi Team, I am using OBIEE 12c Version 12.2.1.4 with Vertica 9.2 database. I have a table in Vertica database details of which are as quoted herewith : create table TEST_OBIEE_FACT ( dim_fk numeric, c1 numeric, c2 numeric, c3 numeric, c4 numeric, c5 numeric); grant select on TEST_OBIEE_FACT to OBIEE; insert into…
-
Can somebody send rpd from SampleApp for 12c
Hi all There is samples obiee of oracle , thank a lot @Christian Berg for his comment's https://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html But i cant now install VM due to security reason. Can somebody mail me rpd from SampleApp at sharkoff76*gmail.com Thanks' a lot!
-
Rename column in project
Summary I need to rename (project specific) columns Content Hi I need to rename columns at the project / canvas leveal. Whats the best/easy way to do it? Version 18 , Cloud
-
How to Connect OBIEE 12c to Microsoft SQL Server ?
I am working on connecting OBIEE 12c to Microsoft SQL Server but i am confused with what i found on the oracle support site. Here is what i found: https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-C03C12DB-50AA-4ED5-B5B0-A32EA0E73D92.htm#datadirect_sql_srvr which is a bit confusing to me. Could someone dummy it down…
-
Admin server not coming up in obiee12c
Hi All, We tried making a change in config.xml for export to excel purpose in OBIEE12.2.1.4.0 and the change is as below: <XMLP> <InputStreamLimitInKB>0</InputStreamLimitInKB> <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing> </XMLP> And <MessageProcessor> <SocketTimeout>5000</SocketTimeout>…
-
Create new user - OAC Standard Edition (105.2)
Summary Cannot find create user button - OAC Standard Edition (105.2) Content Dears, For a demo purpose and following the creation of a recently released OAC Std 105.2 version, I would like to create a new user but I cannot find the create button (Console \ Service administration \ Administer users and roles)... Thank you…
-
Smart view supported styles from OBIEE
While using Smart view in Powerpoint and connected to OBIEE. There are problem with the style of some components created in OBIEE when we insert them in PowerPoint with SmartView, one does not respect the margins defined for the columns of a table, and the other does not maintain the colors that we have indicated in OBIEE.…
-
OBIEE 12.2.1.4.0 Catalog Manager - Creating an analysis Report shows a SOAP error
Hello Experts, We have OBIEE 12.2.1.4.0 on Linux. I am getting error - 'Client received SOAP Fault from server' when I try to generate an Analysis Report using the Catalog Manager UI. Can you please suggest what could be causing this error. Thank You Rakesh
-
Bulk Fetch Failed in OBIEE 12c
Hi All, I have OBIEE 12.2.1.4. installed and my DB version is also 12c. But for few of the reports which fetched huge data (65000 or more) I am getting the following error : State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1652, message: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP at…
-
Level based dimension measure doesn't work when adding most detailed atribute
Hi all, I'm using OBIEE 11g. Please kindly advise me how to overcome the problem I've encountered (even using some work around solution etc.). I'm in control of metadata so the proposed solution could be done through some changes in Admin Tool or on report level as well. The report I'm building contains records of…
-
Replacing 0 and nulls with hyphen (-) in obiee 12c
How can i replace 0 and nulls in a report in tabular format to hyphen ( - ) . I can get it done by converting the number to character . But i need it to be in the number format.
-
12c many to many relationship inside dimension hierarchy?
I have tried to solve this with bridge tables, with snowflakes and I don't know how many different versions, but I still can't get it work. When fact has multiple rows for the lowest dimension level values (as it always will), OBIEE multiplies the data. My data model looks like this: How should I model that N:N between…
-
Previous Month MTD and Previous Year same Month MTD in rpd
Hi All, We are trying to create MTD, Previous Month MTD and Previous Year same month MTD for adhoc reporting in OBIEE12c. we can somehow achieve this in analytics.but for us we need them to create in rpd for adhoc reporting. we have built time series hierarchy and rolling months rolling weeks everything works out even MTD…
