-
Code with the largest total value for Invoice Num, Supplier
I am on a site where we have no access to the rpd and are not aloud to use the evaluate function, so I am hoping this is possible with just answers standard OBIEE functionality. my data is like this: code amount Invoice Num Line Num Supplier 122 200 12345 1 John Dee 133 10 12345 2 John Dee 133 1 12346 1 Jane Doe 134 1…
-
OBIEE Agent sent repetition mails to user these days.
the agent was not changed. since this monday. agent will send multipul same mails to user. any one can advise? I can not any usefuly log. [2019-03-21T04:19:07.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 005X9CA3ZNVATO0LRyXBid0005NX000043,0:1] [tid: 4283b940] Re-running Agent from a previous instance.…
-
OBIEE presentation server is down
Hi experts, Could you please let me know if any one has faced below issue in OBIEE 11.1.1.9.0 <Mar 22, 2019 12:28:21 PM ICT> <Error> <oracle.webservices.service> <OWS-04115> <An error occurred for port: {http://oracle/bi/security/}SecurityWebSe rvicePort: oracle.webservices.provider.ProviderException:…
-
DVD canvas table columns
Summary format canvas table columns Content The column names are showing up twice at the top of my report. see image. How can I remove/stop that? Version 18 , Cloud
-
OBB OTBI Reports/Dashboards
Hi, Is there a list of OOB OTBI reports? I know there are catalogues for the OOB OBIA reports, is there one available for the OTBI reports. I want to see the reports visually.
-
Impact of data modification in s_nq_job table
Hello Experts, I want to know that what will happen if someone modify the table.column "s_nq_job.user_id" related to agents. Table Name:- s_nq_job Column data modified:- user_id (example if user1 name is present as data and someone run the script and update the information of user1 to Test1). Will the agent will have any…
-
E-mail Agent using analysis with unions
Hi all, how are? When running an agent to send an analysis (with unions) to each respective user in the analysis, I get the following error message as shown below: I would like to know if they have already been able to circumvent this OBIEE limitation. Thank you!
-
DATASYNC LOAD TABLE (DIM) NOT USING SQL
Summary How do I add a new dim table, full table, Dim Content I know how to add a table using SQL. but I understand that I should be able to reference a single table and pull it into DataSync. From PSOFT to the Cloud Version 18 , Cloud
-
Best way to deliver PDF download link in dashboard
Hi, I've got a requirement to be able to download a file from a dashboard, this is OBIEE 12c. Explored a few options 1 ) The 'analyticRes' approach. This is successful and I am able to get a link to a file directly to display in the browser/download. The problem is that there's no security in this (or at least the doc…
-
Credentials supplied in SOAP Message header failed authentication
We use an LDAP authentication provider, and recently had to reset the password for security compliance reasons. We also had to change the USER BASE DN setting. We made the appropriate change in the security providers config. Since then, we have been getting this error frequently:…
-
Serbian localization
Hi all, please does anybody have serbian localization for BI or is the any general info how to add missing localization to BI? Many thanks Petr
-
OBIEE 12c Usage tracking
Hi, OBIEE 12C version - 12.2.1.4.0 There is a column TOTAL_TEMP_KB in usage tracking table(S_NQ_ACCT) showing in negative ! not sure what does that mean? the number is quite high! Can someone help me to understand this? TOTAL_TEMP_KB -739411654 -740259871 Regards Hesh
-
Filter view on union report in OBIEE 11g
Hi All, We have union report which contains filter on same columns in both criteria's but when use filter view no data showing in filter . I did few workaround like 1.static/narrative view using presentation variables but hardcoded text is visible in report without selecting the any prompt criteria and what as similiar as…
-
RTF Template Page Numbering with last page excluded
Summary Last page should not be included in the page numbering of the report Content I have a report that uses an RTF template with Page X of Y as the page numbering format and I need the last page not to be included in the page numbering. E.g. if the report has 4 pages the page numbering will be Page 1 of 3, Page 2 of 3,…
-
Oracle Data Visualization Post Description
Summary My supervisor wants a report description Content Is there a way to add a report description within the Canvas Visualize report? Not Narrate Version 18 , Cloud
-
Data is mismatching when compared the current qtr vs next qtr ABR data in financial report in OBIEE
Hi Team, When i select the year as 2018 and Quarter Q4 then current Qtr and Current Qtr Vs Next Qtr (ABR) values are not matching in below report but it is matching for all the Quarters but in case of quarters across years like 2018 Q4 and 2019 Q1 it is not giving the results as expected. Could anyone provide me the…
-
DVD / Data Sync WID linking column Treat AS Question
Summary The WID linking columns for the FACT and DIM "Treat As" Content Should the WID linking columns for the FACT and DIM tables be Treat As (Measure or Attribute)? Version 18
-
Build bip template when xml have nested levels
Summary Build bip template when xml have nested levels Content Hi All I am trying to build an age analysis template from the Aging from the Aging - 7 Buckets - By Account Report. The xml is attached and the template thus far built. The results of the template as it stands now is correct however I only want data extracted…
-
Grand Totals bip template
Summary Grand Totals bip template Content Hi All Need a little help please. I am sure this should be straight forward, but I just cant get this to work correctly. I Am building a template that will deliver customer aging report in excel. The columns of data are customer number, customer name, amount, and then all the 7…
-
Problem with model - how to use max() keep (dense_rank last order) in OBIEE
Hi, I have some problem with creating model. My table has for example for one product 3 record with STATUS and DATA_STATUS: product1 || open || 2018.10.23 15:23:00 product1 || prepared || 2018.10.23 18:00:00 product1 || issued || 2018.10.23 23:00:00 product1 || close || 2018.10.26 00:00:00 And now I want use in bi…
-
Data Security setup using Session Variable Initialization Block fails with nQSError:23006 OBIEE 12.2
Hello Experts, We have OBIEE 12.2.1.4.0 on Linux server. Trying to implement data security using session variable Initialization Block. Performed these steps - 1. Created Inti Block - "Authorization" 2. Non-System session variable 3. Defined a Data Filter for BIConsumer Application Role using the session variable. 4. Also,…
-
How to clear Oracle BI home page
Hi everyone , How to clear Oracle BI 12c home page in Recent and other section ? Thx
-
How to create dimension from two tables
Hi, I have one fact table and two different dimension table: FACT1 and DIM1 and DIM2 Dim1 and Dim2 has data called MANUALLY_PRODUCT and SYSTEM_PRODUCT In physical layer I have join like: FACT1.MP_ID = DIM1.MANUALLY_PRODUCT_ID FACT1.SP_ID = DIM2.SYSTEM_PRODUCT_ID I have requirement to create one table for PRODUCT with…
-
Two users view with mask
Hi everyone , I have 2 users to connect to the BI report and one data model. One user will see the columns in the report with mask the other user without the mask for same report. How can i do it ? Is it possible? Thx,
-
Creating Report from Catalog Manger -- Getting Access Denied
Hi, I have a requirement to create from Catalog manger (Create report option from Catalog Manager), I am getting ACCESS DENIED while creating report for user folder. Is it possible to get that details. Our Requirement is to check if any user created same report which is already there in the shared dashboard or with any…
-
Invoke Webservice with multiple parameters from OBIEE 11g.
Hello, I have a Webservice that require 7 parameters. I want to call this webservice from an OBIEE Action. Steps to reproduce the bug : In OBIEE, I open an Analysis => Criteria Tab => Drag a drop a column => Column property => Interaction => Action Link I add an action "Invoke a Webservice" I put the WSDL file Location, I…
-
OBIEE
Hello, someone can help me with this error: Estado: HY000. Código: 17001. [nQSError: 17001] Código de error de Oracle: 1445, mensaje: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table at OCI call OCIStmtExecute. (HY000), the answer that I found indicates that it is solved by removing…
-
Hiding "Most Popular" and "Download" options in Oracle Managed OAC OBIEE Home Page
Summary Is it possible to hide various Home Page options on Oracle Managed OAC "classic"? Our on-premise OBIEE has removed the Download and Most Popular.. options Content I'm guessing the answer is no because it involves modifying OBIEE message files... but we'd like to remove the Most Popular and Download options from OAC…
-
Detail level report column header name showing wrong months.
Hi All, We have used action link on dashboard navigated to detail level report (Top 4 Month report), When user is select month:- AUGP11F-18 on dashboard prompts the detail level report will show 4 month forward like below screen column header expected one. Issue:- when user is selected month:- AUGP11F-18 on dashboard…
-
Dashboard Prompt selections are not staying highlighted when using SQL to develop the list of prompt
I am working with OAC 12.2.4.0.0, and I may have discovered a bug. Situation: I have created a dashboard prompt with two prompt entries, both of which use SQL to generate their lists of values. Problem: The 2nd prompt entry does not maintain the highlight on its selected value. Scenario: The first prompt entry, generated…
