-
How one Fact attributes will populate correct result with another fact measure
HI all, I have below requirement for a report to create in OBI, There is one dimension (Time dim) and 3 different fact table. the report requirement is to pull year and month column from time dim and quantity measure from other 3 fact table. Time dim is common dimension for all the fact. report: year Month factt1.Quantity1…
-
Distorted row-values with
Dear GURUS, I am facing some issues as per below details: Environment: OBIEE 12.2.1.4 Server: SQL Server 2012 R2 Issue Details: User is narrowing the column and getting irregular/unformatted values in the rows. This issue is very similar to Patch 23295502: IRREGULAR LINE UP WITH "FIXED HEADERS WITH SCROLLING CONTENT"…
-
Prompt is not restricting.
Hello, I am using the OBIEE - 11.1.1.7 I have to show the data for the past 2 years and 1 year in the future in the Month-Year Prompt. I have written query to restricted using the Query in the Prompt. I also have given the All Column Value option in the prompt. When I am filtering data in the dashboard with the Prompt with…
-
Invoke an HTTP request using action in OBIEE 11g Fails
Hi friends, Im in obiee 11.1.1.9.5, im trying to invoke an http request in OBI inorder to download the results according to the parameter that i pass in the URL. My URL is below http://remco.biapps.com:9704/Application11-ViewController-context-root/jersey/{year} Where i have deployed my above REST PUT webservice in WLS…
-
Conditional formating not works in waterfall reports
Dear Experts, We are trying to apply condition formatting in waterfall report 'when Amount is 0 then show all bars with yellow(any )color'. Report is created as Union report. First/Increase/decrease/total bars are working fine and we need the same color as screenshot. As soon,we apply conditional formatting, we get below…
-
Deploy BI reports from External Tool
Summary Deploy BI reports from External Tool Content Hi All, Can we deploy BI Reports in Oracle cloud from External Tool ? Is there any API that we can use to deploy the reports externally to BI Server?
-
Facing a strange issue with OBI URL
Hello Experts, I am facing an strange issue with OBI login. Whenever I am trying to login with generic URL of OBI ex:- http://obione.xxxxxx.com/analytics/ for some user its showing showing signing in, for some user its working. As this a production clustered environment when we are trying to test with single node login…
-
Ability to use AD Groups in Traditional BICS Environment?
Summary Using SSO to get users and groups Content Has anyone successfully been able to setup the SSO in BICS and also grab the groups from AD in a Traditional BICS? Is this possible?
-
After Report Trigger in BI Publisher
Summary After Report Trigger in BI Publisher Content Hi Oracle Business Intelligence 12.2.1.2.0 I want to capture the 'Report Output Generation' status and perhaps log an error/success in a custom table. To make sure if the final output file is generated successfully I don't want to depend on the 'After Data' Trigger as it…
-
Subpage functionality logic
In 12c OBIEE we can create subpages for dashboard page. I try to understand the logic of this solution: when we create a subpage, OBIEE by default is also creating additional subpage with same name as main page, where you can add content. You can't hide it, you can't rename it because whole subpage setup will be ruined.…
-
Sending Admin a CC of email sent to users
Hi All, Am using OBIEE 11g. I have an Agent which sends out custom reports to a dynamic list of users. Department Admin wants to know who all received this email. Is there a way I send a CC of each email to the admin email? Thanks, Sai
-
BI Publisher - Missing Data Source in Data Models even after Creating Data Sources.
Summary Data Sources can only be accessed and found in Data Models for user SYSADM.The system cannot find the Data source when individual Users login and try to run the report. Content We are in the process of Migrating BI Publisher reports from Test to Production.Here is what we did. 1.Created the JDBC Connection and…
-
Essbase Export/Import from Remote Server other than the Essbase Server
Summary Is it possible to export import from a remote Server in Maxl Syntax Content Hi All, Is it possible to export /import data from/to a remote server other than the essbase server? I have gone through the tech reference and see the the "from server" syntax but I think that is just the Essbase Server. Please correct me…
-
Shrunken dimension in repository
Hello all, What would be the best way to handle shrunken dimensions in repository(OBIEE 11g) we have 1. Dim_product 2. Dim_product_code(this is shrunken dimension of Dim_product) Dim_product is joined to fact_sales on product_key, shrunken dimension is joined to fact_stockout on product_code(for clear reference I have…
-
OBIEE 12c Euro Symbol in PDF problem
Hi all, we face a problem with the PDF Export in OBIEE 12c. All Euro Symbols (€) are exported as a question mark (?). The export works fine in 11g and into Excel. The only problem is the PDF export. Has anyone a solution for this problem? I hope, that it isn’t only a German problem :-). Best regards Gerd
-
Sending custom reports as email
Hi All, I have an OBIEE report, on which we have implemented row-level security and hence when a user accesses this report, he can only view data which is related to his department. I want to automate this on my end, such that a periodic job will execute and send this report to users, which contains data corresponding to…
-
Oracle DVD keeps loading at start
Summary Oracle DVD keeps loading at start Content i am working on a project and suddenly the DVD was not responding. I closed and opened it again and it loading but doesn’t actually load. i looked at the logs and it looks like the bi server is not starting i uninstalled and reinstalled but I still get the same issue. When…
-
Getting error in configuring SSO in OBIEE
Dear GURUS, I am trying to configure SSO in OBIEE using Kerberos. I am referring the Oracle white-paper and https://blogs.oracle.com/cealteam/obiee-12c%3a-configuring-kerberos-sso-for-obiee-12c I have completed the steps till creation of KEYTAB File. I am firing the command to create Tickets, but this command is failing:…
-
Webservice executeXMLQuery with executeXMLQuery
Hi, I managed to execute web service executeXMLQuery, but I do not know how to apply a filter expression. Has anyone managed to execute executeXMLQuery web service with <v7:filterExpressions></v7:filterExpressions> Can you please provide the syntax with an example? Thanks, Ark <soapenv:Envelope…
-
Location of Time Entry Level Comments in OBIEE Project Costing subject area
Summary Want to find time entry level comments in OBIEE PPM Project Costing Subject Area Content I understand that OTL time card comments associated with the line level details are imported into Project Costing. In which Oracle BI Answers PPM subject area/folder can the time entry level comments be found?
-
db changes for obiee12c
Hi All..my database has been moved to another host .May I know where all I need to change the db hostname for obiee 12c .. i have done the changes in all datasources through weblogic done the changes in odbc.ini In Nqserver log I see lot of these messages: [nQSError: 12035] Client did not provide a handshake. . [[file:…
-
Ranked comparison reporting in OBIEE
Hi all - I'm facing a challenge building a particular style of report in OBIEE 12c, and hoping to get some insight into whether this can be done. The customer requirement is to compare two lists of ranked items side-by-side, and calculate variances across them. The items in each list are not the same, so the rank is what…
-
Restore Favorites in OBIEECatalog
Hi, Oracle Business Intelligence 12.2.1.1.0 I am looking for a way to restore favorites data from catalog backup. Issue is one of the user added few analysis to favorites and now its missing. Found a bug on this on oracle support site. (Doc ID 2113640.1). We have daily catalog backup. Is it possible to restore the…
-
Constant backup for user catalogs OBIEE 11g
What would be the best way to backup for user catalogs in OBIEE 11g? thanks, Abu
-
Migrate Catalog share folder only OBIEE 11g
what would be the best way to backup and restore the shared folder of web catalog? thanks, Abu
-
BI Publisher - Interactive report timeout
Summary how to increase interactive report timeout in bi publisher Content We have a customer with an interactive report that sometimes runs longer than 5 mins. However, we see BI publisher always returns "ERROR OCCURRED ON RETRIEVING DATA XML" after exactly 5 mins. how do we bump this timeout value to a higher number?
-
Differences between 'Stacked Vertical' & '100% Stacked Vertical' Bar Charts
Hi All, I posted a few things a while back regarding some values (data markers) not fitting into some bar charts, specifically stacked vertical bar charts. BTW -Thanks for the replies Now, I have found that there may be a decent workaround using the 100% stacked vertical bar chart. By using that style, and changing the…
-
Oracle Data Visualization Desktop(DVD) to DVCS Standalone
Summary Oracle Data Visualization Desktop(DVD) to DVCS Standalone Content Hi, I am trying to import project from Data Visualization Desktop to DVCS standalone version. It show that import was successful but when I opened the project It shows error. Can anyone help me on this. Regards, Dinesh
-
Custom Export Link for Exporting All the rows in Report
Hi friends, Im in obiee 11.1.1.9.6. For each and every report i have enabled report links which gives the options like Export etc. When i tried to Export the rows to Excel it is exporting 2500 rows, according to the default value set in EM>CapacityMgmt and that is fine. My requirement is to have a custom Export to Excel…
-
Remove Add Email Recipient button from OBIEE Agent
Hi, Oracle Business Intelligence 12.2.1.1.0 We are looking for a way to hide/remove Add Email recipient button while creating Agent. This is to prevent users from sending reports to non OBIEE users. I tried the option "Deliver Agents to Specific or Dynamically Determined Users". After setting, button is removed, but users…
