-
PeriodRolling Function is not working
Summary PeriodRolling Function is not working Content There is another thread about this without an answer. Trying to use PERIODROLLING to calculate the total number of terminations over the past 12 months. The documentation does not make sense and is very limited. I noticed that whatever I do to the X and Y parameters,…
-
How to create a treemap in OBIEE without applying aggregation on measure column?
Hi Guys, I am stuck in a requirement. I need to create a tree map representing unit test coverage where Coverage column is present in Sonar Data (Fact Table). Coverage is a measure column but no aggregation is applied to it as applying any aggregation, it yields wrong results. I am able to get correct results by doing so…
-
Invalid command-line arguments: Expected argument: export bundle (argument 4)
Hi , I'm facing migration issue.Please check below error. Invalid command-line arguments: Expected argument: export bundle (argument 4) oracle.bi.migration.tool.commandline.CommandLineArgumentParseException: Expected argument: export bundle (argument 4) at…
-
Users not able to access Direct Database tables on OBIEE dashboard.
Hi, I have created a dashboard with 6 tables where 4 tables are created using Criteria tab, and another 2 tables are created using direct database request. Some particular users are not able to view the tables on dashboard that are created using Direct Database request. I think that's an access issue. Can someone please…
-
OBIEE - Visual Analyzer : Ho to display Stacked Bar Graph totals on top of the each stacked bar.
I am using Oracle Business Intelligence Product Version 12.2.1.2.0 (Build BIPS-20160923092103 64-bit) Issue is with the Visual Analyzer Stacked Bar Graph Totals. I have created a Stacked Bar graph visualization with the 3 columns such as Month (X Axis), Sales (Y Axis) and Product (Color - Group by). There are 2 products…
-
Filter the reports on OBIEE 12c dashboard based on user selection
Hi Guys, I have 9 reports on my dashboard that appear by default. My requirement is: Suppose a user wants to view only 2 or 3 reports out of those 9, how can I create a filter based on user selection for the same? As an example, I have reports: Release, Incidents, Defects, Test Coverage etc. Now, I need to create…
-
RPD dissapears
Hi , my rpd dissapears from OBI. I succesufully upload my rpd and it shows in subject area and then after a day sometimes even after an hour it just dissapears from subject area when i click on New --> Analysis. When i go through BI Admin tool and go File-->Open-->Online I can see my rpd but OBI doesnt show it in Subject…
-
Unable to login into analytics using weblogic user
Hi all, I have OBIEE 12c installed and configured. I was able to login and work initially. Recently I have merged sampleapplite rpd with my existing RPD to have both reports work. After that I am unable to login into my analytics using weblogic user. Screenshot of error message I have attached for your reference. I have…
-
Problems with login
Hi, I am having problem when I try to login into OBI , sometimes I need to enter my credentials 10 or 20 times to login, or I have to restart the browser. but that is not always a solution sometimes even after restarting the browser same problem occurs. Please help...
-
OBIEE Session variable in homepage/GO URL
Hello, We have PORTALPATH variable configured for individual Roles and which works fine. Now we are tying to make that as default URL for "Home" button as well. I did try several approaches like below.. but no luck. ../analytics/saw.dll?dashboard&PortalPath=@{biServer.variables['NQ_SESSION.PORTALPATH']}…
-
Reports sent to users without logging in
Hello community, I've come across a requirement where i need to send a report to 10 users who will never log into obiee. They are in 10 different market centers. I cannot set a session variable since they will not be logging in to run reports. The deliverable is an email report via agents to these 10 users. Is there a way…
-
limiting prompt values on variable prompts
Hi, i have 2 variable Prompts with below names Variable Prompt Names: 1) Prompt 1 2) Prompt 2 'Prompt 1' has static values like A,B,C,D. 'Prompt 2' has static Values Like W,X,Y,Z. My Requirement is if i select value 'A' in 'Prompt 1' it should display only 'W' and 'X' in 'Prompt 2'. But When i select value 'B' in 'Prompt…
-
How to migrate and upgrade 1221 RPD to 12212 Release?
I've two environments, one is on OBIEE 12.2.1.0 Release and the second one is on OBIEE 12.2.1.2. What is recommended process to upgrade RPD from 12.2.1 to 12.2.1.2 Release? Please advice.
-
Sorting & Limit Value by Dashboard Prompts
Hi All, I have a dashboard prompt whose selection is limited to its previous prompt and it should also sort in descending order. Prompt1: Region Name (Can, Ind, UK,..) Prompt2: Can 2003 Ind 2017 UK 2012 Can 2007 Prompt 2 should sort by Year in descending order. However when I try using SQL Results I don't get Limit Value…
-
Presentation Variable in Evaluate Function in obiee 12c
Hi All I am trying to use presentation variable in evaluate function.getting below error. Cannot function ship the following expression evaluate If I use date column it is working fine. Please suggest Regards, Subhakar
-
Upgrade from BICS to OAC
Summary Upgrade from BICS to OAC Content Hi , We have started using BICS ,now there is a requirement to upgrade from BICS to OAC, we searched the oracle documents but did not find any information related to upgradation from BICS to OAC. Could any one please let me know is upgradation from BICS to OAC possible,if yes let me…
-
Reg: Table Details used by the dashboard reports
Hi Team, How to get complete Physical table details which are used for OBIEE dashboard reports. Can anyone suggest on this. Thanks in Advance,
-
Issue with Complex joins while merging RPD back to MUD
Hello All, We are facing issue when merging a project to MUD. The merge throws a error with a Complex join name cannot be resolved and reverts back to the earlier version. If we resolve this particular join to a equi-join, then we get error on another Complex join. Has anyone encountered similar error while merging RPD?…
-
error while running a report using nqcmd
I'm trying to run a report using nqcmd utility in Linux. I keep getting below error and no results are returned. I can run the report using the same logica SQL by logging into the BI application. none of hte logs are showing any informaiton on the attempted run. Any idea how I can start troubleshooting this? the command…
-
Using dataguard with OBIEE?
Has anyone used OBIEE 12c with dataguard? Our issue is that if we install OBIEE on the second machine (where dataguard replicates the data) we have an issue with the OBIEE (install) database because it says that the db is already in use. Any ideas?
-
OBIEE - average of 5 years & year over year growth/decline
I apologize in advance if this question has already been answered but could not find relevant information pertaining to my specific question. I have a facts table that contain revenues for years 2000-2017. I am working on a treemap/heatmap to show revenues over all states and would like to also throw in another measure to…
-
Gantt Chart Plugin
Summary Gantt Chart Plugin Content Hi All, I am trying to use sample Gantt Chart plugin. I have selected a start date, end date and an attribute. I get an error saying invalid data. Not sure what I am missing. Can anybody point any pointers. Thanks Deep
-
Missing expression in SQL
Summary Missing expression in SQL Content Hello, I have this SQL and it says there is a missing expression but I can't find it : select itm.SHIPMENT_GID , itm.STOP_NUM , itm.STOP_ACTIVITY , itm.ORDER_RELEASE_GID , itm.ORDER_RELEASE_XID , itm.OR_LINE_GID ,LTRIM(itm.OR_LINE_GID,itm.DOMAIN_NAME||'.') OR_LINE_XID ,…
-
can't align bottom border of RTF template (BI Publisher 11.1.1.9 and Word 2013)
Summary can't align bottom border of RTF template (BI Publisher 11.1.1.9 and Word 2013) Content Hi All, I can't align bottom border of RTF template for some reason, despite "Allow row to break accross page" in Word Table Properties is un-checked. all other Word Table properties set by default. (just added more explanable…
-
Linking OBIEE report to BI Publisher while passing more than one parameter
Summary Linking OBIEE report to BI Publisher while passing more than one parameter Content I have a report where I am trying to link an OBIEE report to a BI Publisher report while passing 3 or 4 parameters to the BI Publisher report. I am using OBIEE 11.1.1.9.0 (Build: 170915.0500 64-bit) and BI Publisher 11.1.1.9.0…
-
nQSError: 77006
Eventually succeeded, but encountered and resolved errors... Number of skipped deliveries: 1 of 2 AgentID: /company_shared/Agent/OVI ADDENDUM1 Device (pcemail) is not set in (ORCL_Bopanna.Nanaiah) delivery profile. AgentID: /company_shared/Agent/OVI ADDENDUM1 Device (pcemail) is not set in (ORCL_Thirumani.Selvam) delivery…
-
OAM and OIM reports in BI
Hello, Can anyone help me on creating and publishing reports for OAM and OIM in BI publisher. Actually i want to capture all users logged in last 24 hours and in a month view along with the user details. But i am not able to get the user details from the schemas. There is one schema "oam_session" from where i can get the…
-
Apostrophe in Email address - Schedule Report Job
Summary Apostrophe in Email address - Schedule Report Job Content Good afternoon, I am trying to run a report on a schedule and one of the recipients has an apostrophe in his email address. For example: Jim.O'Hoolihan@email.net. Unfortunately, BI returns an error that reads: "Missing or Invalid Domain Name…
-
how to find custom script detailed error logs from DVD?
Summary how to find custom script detailed error logs from DVD? Content Hi experts, I installed a DVD in my windows laptop, I want to try custom script with python codes,and I got some sample codes to test this, it works good, but if I modify the codes as per my requirements, it always show me very basic error message, I…
-
Export to CSV issue after invoking EJB using ActionFrameWork
I have followed a similar documentation as outlined below, in OBIEE 12.2.1.2.0 OBIEE 11g: How To Create and Invoke Enterpise Java Beans (EJB) Using The Action Framework (Doc ID 1610118.1) Everything seems to be working fine, except for the csv files. While I'm trying to save the analysis in CSV format via EJB using…
