-
Filter UTC timestamp by local user current date
I have a timestamp, let's call it DATE_TC. This timestamp is in UTC. I want to filter this timestamp by the current date in the local user's timezone. For example if its 10pm on 2/28 in the local user's timezone, I want to show all the records with a DATE_TC within the date 2/28 of the local user's timezone. How can I…
-
DVD on macOS Mojave
When will DVD be available for macOS Mojave?
-
Getting Authentication error while navigating to OBIEE .
Hi, I'm facing "Authentication error" while navigating to OBIEE from obigateway. Here is the url that throws the error: obigateway/argus/authenticationError.jsf?errorReason=6&lang=en Can anyone please help me on this. Thanks, Vineetha
-
Does some Data Source can serve as parameter value for another Data Source
Summary is if there a way to populate a parameter for data set X by result of data Set Y (not join) Content Hi, I would like to build a data model with several data sets when one of them is OTBI analysis result from some cloud system. OBIEE provides great WSDL to define the Webservice data source. The issue is that I had…
-
DV not loading
Summary DV would not load so I downloaded and installed new version and now nothing is working. Content I am having the following issues with DV: * Initially DV would not load all the way (would give me a blank white screen) * I then uninstalled and downloaded, installed the latest Version 12.2.5.1.0-20190125221045 * DV…
-
Set Storage space for OBIEE user folder
Hi, We have a requirement that, adhoc users will create their own report in OBIEE but the total size of the user folder should not exceed 20 GB. Can we set that from OBIEE, so that user can create their own report but it will not exceed the SLA of storage. Thanks Anirban
-
BI Publisher conditional grouping one group only
Summary Break one business unit by department depending on certain account ranges Content Pleaee help, I'm a novice BI creator. I need to split group in report depending on range value. The report already has 5 groups, I need the top level group to split when a certain business unit and department value range of values.…
-
View Selector Export
Hello Guys, OBIEE version: 11.1.1.9.0. I have created analysis which contains view selector (View Selector contains 10 views). View selector is placed on dashboard without any dashboard filter. I am trying to export them in different tab of Excel. Anyone please help on this? How to export the all 10 views in 10 different…
-
OBIEE 11g Connection with HIVE DB
Hi, I am trying to connect OBIEE 11g with HIVE 1.2 DB and I am getting below error message. I am able to telnet from obiee server to hive. Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from…
-
Using system session variable NQ_SESSION.ROLES in initblock
Hi How to use system session variable NQ_SESSION.ROLES inside a initblock with some case condition and store the result into a variable. This variable will be further used to hide presentation columns The initblock query would be, case when NQ_SESSION.ROLES like '%Admin%' then 0 end --> The output of the statement will be…
-
cache issue
Hello All, I have a doubt regarding the cache. There is an Dim_employee table in my physical layer of .rpd. In the general properties of the employee table we have a setting called "Cache Persistence time" = 8 hrs Whenever we have created a report out of that Dim_employee we can see rpd cache against it (by opening the rpd…
-
Files are not transferred over bursting ftp
Summary Bursting Feature (FTP) is not working in PROD (hosted on data center) but working in DEV instance (on-premise) Content We have a strange issue. XML Bursting FTP feature is working on all on-premise instances but not working on all instances (hosted on third party data center). We are EBS R12.1.2 version XML…
-
Doubt related to OBI Agent
Hello Experts, I have a question related to OBI Agent. In General Tab (while creating an Agent), we have an option called "Run as" Correct me if my understanding is correct:- * Specified user :- If we mention any user_name over here in this filed then the respective agent will run with his credentials and will deliver the…
-
OBIEE 12c Error in BI Answers
Hi, Might be a long shot but worth a try, anyone seen the following error before in analysis with OBIEE 12.2.1.2.0. We've encounter this issue in a test environment but is fine in our dev environment which is running the same OBIEE version and database. The two tables are unrelated so theres no need for a physical join.…
-
Setting Graph Scale Axis Limits dyamically ?
Hi, Has anyone tried to set the Axis Limits of a Graph Scale Dynamically ? I have a requirement to be able to do this based on the Measures this Graph is using ? See below : Graph Properties -> Scale -> Axis Limits - Specify -> Min and Max to be able to get them dynamically. Regards ShaSha
-
Obiee 12c. Clone_bi_machine.Error:problem finding singleton data directory
OS Win 2012 R2 I'm trying to scale out my BI EE. I created shared folder, Copy bidata into it, changed bi-environment.xml (" <bi:singleton-data-directory>W:\bidata</bi:singleton-data-directory>") and set some other parameters. But when I try to make jar-file "clone_bi_machine.cmd -m BINODE02 192.168.10.77 binode2.jar" I…
-
How to modify this complex join in OBIEE Answers?
How do I achieve below join condition for one specific report in OBIEE 12c Answers? Select * from A right outer join B on (a.id = b.id and a.entity is not null) I have defined everything in rpd except 'a.entity is not null'. When I add this condition 'a.entity is not null' in rpd or in Answers to table A, it adds it to the…
-
If we configure the External Subject Area (XSA) Cache prior xls files are moved to DB ?
Hi, We have OBIEE 12.2.1.4 and we already released the "Data Visualization" tool to the end-user. Now we are considering the option to enable External Subject Area (XSA) Cache, but we don't know if the files that were previously uploaded by end-users will be moved to the new defined schema for XSA or not. If it is not, we…
-
Parameter value pass
Summary Pass a value to sql script read parameter value Content Team, I am new to DV. I need to pass a value from Report1 to Report2 and have Report2 use the passed value in a SQL Script Example: "Select * from Dataset/table where (vale1 - Val2) = parameterValue" Example help please? Version 18
-
Oracle Data Visualization directly connected to PBCS with a native adaptor
Summary Oracle Data Visualization direct connect to PBCS Content When will the native adaptor for PBCS be available in OAC - DV? NOT using the RPD method, creating a subject area, etc.
-
Dashboard prompt should refresh only particular in obiee 12c dashboard
Hi All I have created dashboard prompt with custom values like DTD, MTD, YTD. In the report level I have handled presentation variable with case statement like case when '@{DMYTD}{DTD}'= 'DTD' then Fact details.DTD_Actuals end. After adding dashboard prompt and report in dashboard, if I change to DTD in prompt the enter…
-
How to customize OBIEE Error Message
Hi, We have a requirement to customize one of the Error message in OBIEE 12c. If any of the report is running more than 10 minutes we are killing that particular query from Database (with a trigger). As soon as the query get killed in OBIEE front end we are able to see below error message - message: ORA-00028: your session…
-
DV Data Preparation Data Tiles option missing?
Summary Did the Data Tiles on the Prepare tab of DV disappear or move somewhere else? I am only seeing the enrichment options when bringing in a new data set. Content This is where it was in a prior release. Version Release 105.1.1 - February 2019
-
How to hide / encrypt nqUser and nQPassword when Passing to OBIEE
Hi All Below code is shared by one of my friends to call the dashboard URL from external portal but portal should be html link. I tried to transform into URL acceptable by command prompt within oracle 11g application through webutil.client_host but failed, anyone please help, my main requirement is just to hide nqUser and…
-
OBIEE 12c: Upload repository results in inconsistency
Hi guys, first of all I want to state my versions I am using for the upcoming scenario / question: OBIEE: Version 12.2.1.1.0 OBI Administration Tool: Version 12.2.1.1.0 Oracle Essbase: Version 11.1.2.4.008.28 Server OS: Linux RedHat Enterprise Edition 6. Today I was trying to upload a repository-file (.rpd) which I just…
-
NQCMD - Error Application's WCHAR type must be UTF16, because odbc driver's unicode type is UTF16
Hi experts, I am using OBIEE 11g when I am running below command source /u01/prd/app/obia/Middleware/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.sh /u01/prd/app/obia/Middleware/Oracle_BI1/bifoundation/server/bin/nqcmd -d AnalyticsWeb -u weblogic -p Admin123 -s…
-
Essbase-OBIEE-error "[nQSError: 22069] No dimension is available to project the pseudo measure."
Hi expterts, Trying to import Essbase cube in rpd(obiee 12 c) and getting below error when select dimensions with measures. Requirement is- Business dont want flattern measures. Any suggestion please. Getting error: error "[nQSError: 22069] No dimension is available to project the pseudo measure."
-
Possible issues we should take into account before increasing the Session Timeout values.
Hi, I have two questions related to the same topic - session timeout values: LogonExpireMinutes, ClientSessionExpireMinutes and ConnectionExpireMinutes. This question is 1/2. OBIEE 10.1.3.4.2 dashboards have been embedded within another application. Let us call it as the Core Application. Mostly, the users are working on…
-
Summary - Detail Report rows are mismatching in OBIEE12c
Hi , when i am doing testing in Dev environment for the one of the summary report ,Could see that summary having 5 records for the date 07-sep-15 but detail report is showing only 2 records. Summary Report: If I click on roster start time like 10:00 AM ,it is showing first 2 records as per above screenshot but for the date…
-
How I solved my Last 12 months revenue Comparison Problem
Hi All I just want to share my experience with all of you, how I solved my problem of last 12 months revenue comparison, I tried different methods but liked this one, my purpose is just to share my experience, maybe helpful to someone Fig.1, Added a new column in Time dimension with format YYYYMM Fig.2, Added column in RPD…
