-
Best Way For Creating Specific Fact (Non-Standard Aggregation)
Hi All, Question about the best way to create Margin of Error as a fact? Originally I had created a new logical column off of a database fact for Margin of Error by selecting Derived from existing columns using expression and then the calculation: 1.96(STDDEV(FACT COLUMN)) / (sqrt(COUNT(FACT COLUMN)))/ Which works mostly…
-
Duplicate definition error in OBIEE Administration Tool
I am trying to import tables from the database through Administration tool. I am using version 12.2.1.0.0. I have successfully connected with the repository but the problem is while importing the datasource to the physical layer the administration tool is showing duplicate tables. In the picture SAMP_ADDRESSES_D table is…
-
False midnight filtering
Greetings all, We have an OBIEE dashboard that is used to basically count the number of widgets we produce a day. This dashboard is displayed on a console that is updated every 5 minutes or so to the floor supervisors. The problem we have ran into is working the filter work with our plant's false midnight. For example our…
-
obiee wsdl service url format
using http://host:port/analytics-ws/saw.dll/wsdl/v7 I can get the entire wsdl. Is there a URL format that would allow me to grab a specific services wsdl 'SAWSessionService' for example. I'm trying to build some web service metadata in talend and the metadata tool is only pulling back 1 service or portname for the url…
-
Presentation services down in 11.1.19 v
Hi, My persentation services(coreapplication_obips1) is down after server rebbot. I didn't see any error message in Nqsserver file except this message {[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1a84] [nQSError: 46073] Operation 'GetFileAttributes()' on file '' failed with error: (3) The system cannot find…
-
GUI does not shows in Informatica 9.6.1 installation on ORACLE LINUX
Hi I try to install Informatica Power Center 9.6.1 on ORACLE ENTERPRISE LINUX 6.5 but running ./install.sh does not display GUI mode. All the installation happens only on text mode.Since i am new to this installation, I wonder what need to be done for GUI display. Please advise By the way in am using informatica 9.6.1…
-
how to utilize MUDE shared RPD
Hi, i would like to know how can i get my updated MUD sahred RPD in to server. do i need to manually deploy in server everytime?
-
BI Publisher - Unable to display 'Date and Time' parameter in the report
Hello, I am trying to add 'Date and Time' parameter/icon to the report to display 'Time of the Run' as shown below: Although it is working fine in 3 different environments but isn't working in Production Environment as shown below: All the environments are alike in terms of configuration. No changes have been made in the…
-
Scheduler trigger fails when a parameter has several values
Hello everyone, In my data model I have a data set: Select * from v_cobranza where Convenio IN (:Convenio) and Docto_Tipo IN (:Docto_Tipo) and EstadoCobranza IN (:EstadoCobranza) and email_1 is not null Scheduler Trigger: Select cobranza from v_cobranza where Convenio IN (:Convenio) and Docto_Tipo IN (:Docto_Tipo) and…
-
Two Prompts -- Simple & Advanced
I'm creating a dashboard where users will want to have the option of doing i.) a simple search with 8 column prompts and ii.) an advanced search with up to 30 column prompts. The dashboard will have multiple dashboard pages where user selections will carry through (be inherited) on all pages. What is a clean, user friendly…
-
Obiee 12c logging off
Hello All, I have followed (Doc ID 2077764.1) to setup Task scheduler for OBIEE12 and this is working without problems, if I restart the server, however...If for some reason I have to manually restart OBIEE 12c services stop.cmd / start.cmd from BITOOLS and after that log off from the Windows Server, all services will…
-
Obiee 10g upgrade to 11g
Hi everybody, i would to know if its possible to upgrade Obiee 10g from 32b archit envir to Obiee 11g in another envir running in 64b archit system by using default Upgrade Assistant. because in docs they says it very important to do the upgrade process in the same archit system . Thankfull
-
LAST_PERIOD function
Hello, Did someone successfully used LAST_PERIOD function? I need to use that but there is no diffrence in physical query if compare it to query with LAST function. No difrence in results. "Data is dense" flag is checked. I need that becouse LAST returns the last non-null value, whereas LAST_PERIOD returns the last value,…
-
Oracle patch 22221772 conflicts with 22475251
I'm currently using OBIEE 11.1.1.9.160119 on MS Windows 64 bit. I was experiencing an issue with the RPD where new application roles were not synchronizing with the RPD identity manager, as described here: Bug 22221772 : NEW APPLICATION ROLE CREATED IN EM DOES NOT APPEAR IN THE RPD I installed patch 22221772 on 11.1.1.9.0…
-
Based on Two individual calender prompts ,two individual columns must change?
Hi, I have created two presentation variables @{OSM_007_CME@} for current month end column, @{OSM_007_PME} for previous month end column. one calender prompt for current month end: TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(MAX("GL_BAL_CRF"."BUSINESS_DATE")) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 1,…
-
OBIEE 12c - Offline repository location
I found something that I think is odd. I created a repository from scratch (binary file) and stored it at c:\myrpds. When I attempted to open it in offline mode, I was informed that it could only be opened in read-only mode. This happened repeatedly - create a new repository, save it in some random location, try to open it…
-
OBIEE 11g: Setting default data format subject area wise
I am using OBIEE 11.1.1.7.0 We have 2 Subject Areas and I am trying to set default formatting for all the text fields from only one subject area - Plain Text (Don't break spaces). If I chose this data format to be system-wide default, it will impact both the subject areas, which we don't want. I tried editing…
-
after changed the port of biserver, unable to sign in analytics
obiee 12c I alter the biserver1 port to 9704,9804(SSL) through admin consle, then stop and start all the server. I met error when I want to log in analytics: Unable to Sign InAn error occurred during authentication. Try again later or contact your system administrator.Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC
-
[nQSError: 46036] Internal Assertion: Condition ids.size() == 1 when using NQSModifyMetadata()
Hi Gurus I want to modify an RPD using webservices I first converted the RPD file to XML using biserverxmlgen command and then used SOAPUI to run the following request: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ws="http://ws.admin.obiee.oracle/"> <soapenv:Header/> <soapenv:Body>…
-
Can't load external libraries in obiee 12 because it is violates the following Content Security Poli
Hi, I have obiee 12 and I used external JS libraries such as google graphs and bootstrap but I faced issues with this error: "Refused to load the script 'https://www.gstatic.com/charts/loader.js' because it violates the following Content Security Policy directive: "script-src 'self' 'unsafe-inline' 'unsafe-eval'"." Any one…
-
When customize one border of column, rest disappearing in obiee 10g
In OBIEE 10g when we are trying to customize right side border of one column (want to give another color) from Properties -> Style -> Border, rest all three borders of columns are disappearing. (default gray border is removed). Can some one let me know if this is version issue and happens only in 10g? Also, please let us…
-
Assertion failure: hDestObject->isTotalRootType(nROOT_LEVEL_TYPE_FROM) at line 1975 of project/webco
Hi All, When I am trying to click new pivot table view or new graph view or any other new view from analysis it is giving me the below error. How to over come this error. Assertion failure: hDestObject->isTotalRootType(nROOT_LEVEL_TYPE_FROM) at line 1975 of project/webconnect/subjectareamdloader.cpp Thanks !
-
Brio(BQY) to OBIEE
Hello , we are using Oracle Hyperion Interactive Reporting Translation Workbench to move the metadata to OBIEE .. but getting the below error Started importing BQY files at 2016-03-07 17:32:45 from D: /nqyfiles/BQY5 -- Importing 1 new documents -- Starting file 1 D: /nqyfiles/BQY5MatchingReports_PDF.bqy Did not import…
-
OBIEE 12c Configuration Issue unable to start BI Services
Hi , I am facing this issue. Installation of Fusion Middleware and Obiee 12c installation was success. Created repository using rcu.bat file. Using config.cmd i am trying to configure OBIEE 12c. But while starting all BI services it is throwing an error saying that "OBI Has Stopped Working". And i captured the image also.…
-
OBIEE installtion failing with timed out error while staring OPMN
i am installing OBIEEE 11.0.0.7.0 32 bit on windows 7 32 bit-- All the solutions for this problem indicate problem with loopback adapter..but i have configured it correctly as: 192.168.255.11 test.oracled.com test do i need to use some other host name?i am able to ping test from cmd error message in log *************Try to…
-
Trying to hide NULL in dropdowns in OBIEE 12c
Hi Guys, I've been trying to hide nulls in dropdowns in OBIEE 12c but I am having issues, I read about this in documentation: <ServerInstance> <Prompts> <ShowNullValueInPromptsWhenDatabaseColumnIsNullable>never</ShowNullValueInPromptsWhenDatabaseColumnIsNullable> </Prompts> </ServerInstance> However when I add the…
-
Writeback functionality from Dashboard page not working
Hi Experts, I have implemented writeback functionality and it works fine in the Compound layout. I am able to update the records in database. But when I place that report on the My dashboard and try to update the records, it does not work. The 'Apply' and 'Done' buttons do not work on the dashboard. Do we need any…
-
OID and LDAP SSO authentication on OBIEE 11g, can it co-exist?
A customer wants to use SSO for logging into OBIEE from an iFrame in SFDC. Can this be done? If so, where can I find documentation? Thanks Tom
-
OBIEE 11g - how to pass full context when navigating from bubble chart
I am trying to enable navigation (Action Link 'Navigate to BI Content') from a bubble chart to a table, but it is not behaving as expected. I figured out that (somewhat counterintuitively, IMO) the dimension used in the 'Bubbles' section is what needs to carry the Action Link. Why it isn't the 'Bubble Size' measure is…
-
OBIEE 12c - Uploading repository to cluster
In OBIEE 12c, when we use the data-model-cmd.cmd uploadrpd command to send a repository to BI Server in a clustered environment, does the propagation to all servers in the cluster happen automatically, or must we restart the BI Server on each clustered machine, as was the case in 11g?
