-
Error throws when I created the new group in analysis
Dear Team, We have implement OBIA project analytics. Following error throws when I am trying to create the New Group in Analysis. State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError:…
-
OBIEE - IDCS (Identity Cloud Service) SSO provider
Hi, We are using IDCS (Identity Cloud Service) in one of the web application development for authentication and authorization. In our application, OBIEE reports are need to be integrated using OBIEE Web Service. Planning to use IDCS SSO provider for web service authentication. So please let us know, is OBIEE supports SSO…
-
Auto send bursting email in BI Publisher Enterprise
Hello, User would like to auto send burst email when Apply button is hit in parameter section, Can this be done? Can I add a Submit button to parameter section? Any other advise is helpful.
-
Cast / Format - 2 dp for double?
In a non-production environment; - SomeFieldsAndLiterals||Cast(Cast(10.2 as double) as char(20))||SomeMoreFieldsAndLiterals Gives; - SomeFieldsAndLiterals00000000000000010.20SomeMoreFieldsAndLiterals (which is the desired effect - 2 decimal places) In Prod SomeFieldsAndLiterals000000000000000010.2SomeMoreFieldsAndLiterals…
-
OBIEE 11g Siebel Integration - Username and password is returned as a hidden field in the web page
Hi, We have implemeted OBIEE 11g and Siebel direct integration as per OBIEE Integrator's Guide http://docs.oracle.com/cd/E28280_01/bi.1111/e16364/siebel_crm_integration.htm#BIEIT3307. In addition to embedding obiee pages within Siebel, Our security team has raised an alert stating that - Username and Password is returned…
-
Custom Properties Scorecard Management
Hi everyone, I have some problem with my Scorecard Managemenet. I created scorecard and it's working fine, but I can't edit it. Then I try edit it I have give error that someone with some number/code edit it now. In scorecard properties I see something like that: There is in Customer Properties: CurrenltyEditBy and I think…
-
Displaying images from db in bip 10.1.3.2
Hello , We are trying to display blob file in oracle bip. Found the syntax in publisher guide.. but it is throwing an error. We are accessing image(blob) field from oracle database. Column name is passport_photo <fo:instream-foreign-object content type="image/jpg"> <xsl:value-of select="IMAGE_ELEMENT"/>…
-
Problem in setting Email delivery of BI publisher report
Hi, I am trying to configure Email delivery of BI publisher reports. For this purpose i am using BI publisher Bursting feature and i have installed hMailServer in my system as mail server. When I am trying to add Email Server detail in deliver option its throwing "Connection could not be established" error. Same Email…
-
Presentation Name column in S_NQ_ACCT table not getting populated
Hello, I'm implementing Usage Tracking analytics to monitor system and ad-hoc query performance. I've followed oracle documentation and successfully enabled usage tracking i.e S_NQ_ACCT table is getting populated with usage details. However, I'm finding Presentation_Name column in S_NQ_ACCT table not getting populated and…
-
OBIEE 12C
While we connecting Teradada tables through Direct Database request in 12c we are getting below error, State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: 08S01 code: 32 message: [Teradata][Unix system error] 32 Socket error - Connection reset by peer. (HY000) State: HY000. Code: 16014. [nQSError: 16014] SQL…
-
ODBC Unable to locate SQLGetPrivateProfileString function - OBIEE 12C & AWS Redshift
Hello Everyone, Hoping someone can help me. We have set up an OBIEE 12C instance and want to connect it to AWS Redshift DB. Have confingured the Linux box following the following guide but replacing with the Redshift Driver: http://www.rittmanmead.com/blog/2016/08/using-apache-drill-with-obiee-12c/ The RPD connects to the…
-
HtmlViewService generating ServerSOAPFaultException Type mismatch of catalog object
I am trying to use the BI WebService to get a report's HTML back to a Java app (NetBeans). I am able to log in and start a page but when I attempt to addReportToPage, a ServerSOAPFaultException is generated with the following error: Type mismatch of catalog object /shared/Dashboards/_portal/MyPage/MyReportName -- expect ,…
-
show default date value based on another text column prompt value in obiee11g
Hi All, I have requirement like below, If user selected Time Series column prompt value as “General ES/VaR” then date column need to be shown default value as “17 Jul 2015" and if they selected Time Series column prompt value as “Total ES/VaR” then need to show max date value. if you have any idea/suggestions to resolve…
-
How to remove new line character in Smartview
Hi, I have integrated smartview with obiee to access the reports through smartview. But i am facing some issue while opening the report in Smartview. Here is my issue. When i open the report from smartview after few records (in my case after 284) ,its started behaving weired. Value of the second column is shifted to first…
-
Display row count when using a dashboard prompt on a hierarchical column
Hello, I have seen following discussion: I want to understand if this is the same issue that I have and I want reconfirmation that there is no workaround at all. We have a dashboard with dashboard prompts and a report. One of the dashboard prompts is a Hierarchical Column. In the report we want to display: 1) The total…
-
Rank and Count function in Obiee 11g
Hi All, I got a requirement which I am facing issues while implementing, Please find the below details: Suppose I have the below table, where there two groups, group1 and group2, Each group is having three category, A,B, C . and their members business. Shown In First Table…
-
passing parameters to the jobmanager
Hi All, I want execute NQCMD script from job manager. i stored my script. now i want to pass password as parameter. pls guide me how to do that. Thanks in Advance.
-
Saw server crash OBIEE 11.1.1.7 july BP
Hi All, noticed Saw server crash below error in Jh.log [2016-07-28T08:38:49.019+02:00] [dvt] [WARNING] [] [saw.dvt] [tid: 104] [ecid: 2e54f623ef1adad9:30b05701:1560bc9901e:-8000-000000000050b9f5,0:1:1:1] Error[[ oracle.bi.nanserver.fwk.exception.BISvsException: java.io.EOFException at…
-
Usage Tracking Issue:Usage Tracking not started due to non-existent Usage Tracking table
Hi Guys， OBIEE Version: 11.1.1.7.0 MySQL Version: 5.6.20 Physical Layer : MySql Connector and Connection pool are work will, so I can get data from answer. Answer : MySql Client: NQSConfig.INI: PHYSICAL_TABLE_NAME = "Usage Tracking"."crc000_log"."s_nq_acct"; CONNECTION_POOL = "Usage Tracking"."UT Connection Pool Mysql";…
-
OBIEE 11g: BI Admin Tool Crashes when Applying "Online User Filter" from The Identity Manager
Hello, We are using OBIEE 11.1.1.6.0. I'm trying to apply data access security for a set of users, each with a different filter. The available list of users dont contain all the users, when trying to filter the list using Online User Filter, the BI admin tool crashes and display a "Not Responding" Message. Is there any way…
-
How to export to CSV file with folder headings??
Hi, Experts Q1: I hava a biee report and display folder headings as separate rows, but when i export it to csv file ,the csv file only with column heading but without folder headings,Anybody know how to export to CSV file with both folder headings and column heading ? it works fine when i export to excel2007, but i need…
-
Cals in Column Formula Issue
Hi I have write formulas at the column formula level and not at the report level as per the requirement. I need to filter Total sales(from Main Sales table) by Date and Type columns from (consumer table).Screenshot of the RPD design below. when i do it at the report level, i am getting right data. when i remove the report…
-
OBIEE - Not Signed In
Hi All We created an RPD from scratch and deployed to a fresh OBIEE instance. However we are getting 'Not Signed In' message when OBIEE is launched from Oracle EBS instance. We have a new responsibility defined in Oracle for this. I guess some configuration need to take place in Weblogic, Application Roles in Weblogic,…
-
applied no wrap in excel output of BIP RTF format, But pdf format cutting the content
Hi Guys, My Goal is no wrap data in both excel output of BIP rtf format . I changed the table properties> cells> untick wrap text It solved the problem in excel format but in PDF, It wrapped the data and content is cutting for each column (not showing the whole content). How to solve to achieve any of the following: 1.…
-
how to return the filters page for useing "Navigate to web page" action
Hi Experts, Since the special columns for drilling in master report is not the same in detail report, so I use the "Navigate to web page" functin for navigating in answer, but after I filter the data and drill down from master to detail report , and click the "Return" button in detail report, it will show the original…
-
[nQSError: 60009] The user request exceeded the maximum query governing execution time
Hi All, we have installed obiee11g and Upgraded RPD and webcatalog from 10g. We are getting the below error while users are running reports, Also sometimes the drop down list also longtime to fetch the result. Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000]…
-
OBIEE GoURL security issue
Hi Experts, Please can anyone suggest me how I can encrypt the GO URL of OBIEE, so that OBIEE can decrypt the URL and provide me the dashboard page? What am I trying to achieve : I have a Java JSF Web Application in which I need to embed OBIEE report in <IFRAME> tag. I am able to display OBIEE reports. But when I right…
-
Upgrading OBIEE simple install from 11.1.1.6.7 to 11.1.1.9
Hi community, We are currently using OBIEE 11.1.1.6.7 and we would like to go into 11.1.1.9. As this is a simple install of the software, is it possible to get it upgraded? If yes, is there any documentation you can recommend for this purpose? If this is not possible, what would be the best approach? A fresh and clean…
-
Capturing mulitple values in BI session variable.
Hi friends, I do want to capture a multiple name in my session variable, in which im using that session variable in my obiee alert agent email subject. Hence for that i created session variable(DISPLAY_NAME) and init-block like below SELECT SA.DISPLAY_NAME FROM SA_SYSTEM SA, XXMP_HR_ANNIVERSARY_ALERT_V XXMPWHERE SA.LOGON =…
-
OBIEE 11g: Measure not aggregate to root level hierarchy
Hi, I have a fact table and a hierarchy and I want that in a report, some measures show value at root level of the hierarchy, but others show null value at that level (or at a level higher than one I set, maybe only leaves), but when I drill down over them,I could see the agregate data in that intermediate levels. It's…
