-
OBIEE User forgot password, Where can i change it from?
Dear All, I am new to OBIEE and today I face an issue. A user came to me and he has forgotten his password to log in to OBIEE. I want to change/ reset its password. where can i do that from? Regards, Farrukh
-
[nQSError: 92008] XML validation error at line number 709: unknown element 'AttributeDefn'
Hi all, I have a trouble with admin tool in Obiee 11.1.1.9.0 during development with mud. I'm trying to move new developments from test environment to integration. In test environment I checked out a single project with my new developments and after integration rpd checkout I copyed and replaced Metadata1.rpd file in…
-
Bursting control file pick up a previous variable value. how to solve it?
Summary bursting control file pick up the previous variable value from xml output Content I am in EBS 11.5.10.2 using BI publisher 5. I have a very strange problem. I will upload the bursting control file and XML Output. I have a print invoice concurrent program ( in xml output ) it can have multi-invoice and each invoice…
-
Even after upgrade showing old version
Even after upgrading 12.2.1.2 to 12.1.4 , its shows the old version 12.2.1.2 in Obiee -about Obiee. Thanks
-
Oracle Data Visualization Desktop to Mojave Macos
Content Do we have an version compatible with Mac OS Mojave? there it is an ETA?
-
BI Security Report
Summary Can we create a BI security report? Content Is it possible to create a report of BI security or export the data so that security reports can be created? I'm just starting to set up a BI Cloud instance. I'm still trying to figure out security. It will be a major help to be able to report on security so that I can…
-
Custom Script in Data Visualization Desktop
Summary I am actually learning to use custom python scripts in the tool. Seems like it has to be formatted into an XML. Any tool / easy way to do wrap the python script I have into XML?
-
Button to print a pdf page from dashboard
Hello! Usually, to print a PDF page from a dashboard, i use the path Options-->Print-->PDF. I'm asking if there is the possibility to put in my dashboard pages a button (like an action) that let me print my pdf document immediately. In other words, i need a button that call the action called by the path above. Someone can…
-
Conditional Formatting on Grand Totals
Hi guys, I am trying to hide a grand total column using conditional formatting. Currently there is no such feature available. Is there any workaround? I want to change the background color of the grand total for some columns in my pivot table analysis. Regards, Farrukh
-
How to invoke BI cloud connector using REST or SOAP service
Summary How to invoke BI cloud connector using REST or SOAP service Content Hi All, In BI Cloud Connector console, We have the option to submit the extract job in the Manage Extract Schedule. How can I submit this through REST or SOAP service. Actually I want to invoke from our PaaS offerings like ICS, SOA CS, JCS. In HCM,…
-
Obiee Admin Tool Logon Failed Error
Hi, I have a problem on obiee administration tool. When we try to log in as online mode, it say "Logon failed" and no any other details :S This issue occurred a few week ago, before we could successfully connect it. Version: 12.2.1.3.0 (Build BIPS-20170820114118 64-bit) This is the screen details; What do you suggest for…
-
Showing Monthly, Yearly Sales in the same report using Time Series Functions
Hi, My Automotive client has a requirement to create a sales analysis report that comprises the below columns: * Car Model * Current Month Sales * Previous Month Sales * Current Year Sales * Previous Year Sales Report Requirement Description: User would be selecting Date Prompt, as per the Date Prompt selection the report…
-
Return First Non Null value
HI All I am working on a report and I need to return planner code at item level. Typically planner codes are set at Item - Org combinations. But I am creating one report aggregated at item level. There are few orgs where there is no planner code. But OBIEE should return first Non Null Planner code. Can this be done? Please…
-
OBIEE 12c - Google Charts Error - "Pre Flight No Access-Control-Allow-Origin header is present on th
My team recently got merged under a new manager of which has a few things that she would like implemented in OBIEE 12c (Google analytics, Google Charts and Google maps). I believe I got google analytics working sufficiently, but am now trying to get Google Charts working. Initially when I was trying to get Google charts…
-
OBIEE 12c - Installing/Using Google Analytics to Track Usage in OBIEE12c
I was recently asked to see if I could get Google Analytics working in OBIEE 12c to see if there was a way to track usage. I know that OBIEE 12c has its own internal usage tracking via the tables S_NQ_ACCT, S_NQ_DB_ACCT and S_NQ_INITBLOCK - But this tracks usage only when someone executes a query/runs a report. From my…
-
BI Publisher - data in XML but not in template
Content Hi all, I'm having some problems with a BI Publisher report, where data is shown in the "View Data" tab for the columns I want to use and in the exported XML that I'm using to build the report (see point 1 in attachment), but won't come through to the template (see point 2 in attachment). Despite there being data…
-
BI Publisher in a browser?
Summary Is there a browser version of BI Publisher? Content Can BI Publisher be run from a browser with OAC BI or is the client installation required? Jerry
-
OBIEE 12C Usage Tracking Dashboard Error
Hi All, when i am trying to run the top usage report in OBIEE 12c ,i am getting below error OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. State: HY000. Code: 43113. [nQSError: 43113] Message returned from…
-
How to tune Performance in OBIEE 11.1.17
I have a dashboard which run within almost 5min but its back sql run fast in Database side by 25s. May I know why it is slower that db? Besides, I found 2 time in Administration. one is 27s another is 4m55s. the second one is actual dashboard run time. How to tune the performance?
-
Why does user see blank page after logon -you do not have permission to access this page.
After logon gets message - you do not have permission to access this page. User is in an application role. Application role has permission to subject area.
-
Formatting Calculated Items
I'm working on an analysis where I have a pivot table that looks at Total Award by Institution, by year, and ranks the institutions by Total Award. The general format is: 20182017InstitutionTotal AwardRankTotal AwardRankCool Biscuit University1,000,0001950,0002Excellent Soup College of Broth900,0002975,0001Great Taste…
-
Create Opaque View using multiple tables
Hi, Can we create an opaque view using multiple tables in query? I have a query from 2 different tables with a join condition, now I want to create a view and see the results of view in the reports. Also, how to model in BMM as there is no other table to join as prerequiste before seeing the report. Appreciate for help.
-
Is there a method available to upload descriptions into the OBIEE repository?
We want to build a way for users to create descriptions that will be available when users are using OBIEE. These descriptions need to reside in the repository at the right level. The users want to maintain these descriptions outside of the Admin tool and have a method to upload them into the repository. Are any methods,…
-
Catalog reports not showing the current version after in place upgrade from 12.2.1.2 to 12.2.1.3. Pl
Catalog reports not showing the current version after in place upgrade from 12.2.1.2 to 12.2.1.3. Although the server is running in 12.2.1.3, the version being reflected in the catalog reports when opening up the properties is 12.2.1.2.
-
Maximum data set size / overall data storage in DV
Summary What is the maximum data set size you can load into DV? Content Hello experts, Is there an upper limit on the size of an individual data set in DV? - either in terms of MB size or number rows size? What happens if the source connection attempts to load a file or run a query from relational database that is too…
-
Send analysis on email
Hi guys, I am trying to send an analysis through an agent on email. I have configured the email on Oracle EM and restarted my services, but my alerts are still not sending emails. Thanks Regards, Farrukh Nasir Siddiqui
-
Access To Visual Analyzer Through EBS SSO (Doc ID 2250853.1)
Hi Per this note, VA does not work with EBS SSO. Any idea how it is to be configured if integration is built that way. (or it means that this product cannot be used if you've EBS SSO Regards G1 Version 12.2.1.3.0
-
How to migrate OBIEE 12c RCU database between 2 SQL Servers?
Hi guys, I am planning to migrate our OBIEE12c(12.2.1.2.0) RCU database between 2 different SQL Servers(2012). I tried restoring RCU db in another server and change ALL connection pool setting in "WebLogic ServerAdministration Console 12c"-->>data sources The weblogic can't start the service. Any other suggestion? Thx Joe.
-
OBIEE 12c Sax parser returned an exception Error
Hi, I have a question for obiee analytics side. When I run an analysis, OBIPS log file alwalys say following erros. (For all reports not for specific ones) [2018-10-10T14:08:50+03:00] [OBIPS] [ERROR:31] [] [saw.catalog.serviceinstance.readObject] [ecid: 8c4164d1-ab63-4625-b7dc-9d159e642218-0000bdd2,0:1] [tid: 1531143936]…
-
OBI 12c on Windows Server 2016
Hi everyone, Is Oracle BI 12c certified on Windows Server 2016? Can anyone give some doc or certifiction matrix which has information about Windows Server 2016 and it's certified/supported?
