-
OBIEE12c default dashboard page for particular user or role
Hi All, I have a dashboard which is having 4 different pages, currently all users accessing first page as default dashboard. Now we have have to set role wise default dashboard For example users 1 will access page2 as default User 2 will access page3 as default . I have created portal path variable and given below path…
-
OBIEE 12 C App Roles issue
Hi All, We are trying to implement Data level security at App Role level. We see that Application role filters are not being applied, even though the session variables are populated. Step 1 : Created Groups in Active Directory. Step 2 : Configured Web logic to see the groups created in Active Directory. Step 3: Created…
-
Getting error while downloading the report in excel
Hello Experts, We have migrated to Oracle Business Intelligence Product Version 12.2.1.3.0 (Build BIPS-20170820114118 64-bit). We have a report created in our analysis, and whenever a user is trying to download it in excel we are getting an error:- We have google all the option available, but its not working. Can anyone…
-
Custom data format override issue
Hello, I'm noticing issue in OBIEE 12c while try to migrate report from 11g that has a date column with custom data format as "MM/DD/YYYY" which is getting overridden to default [FMT:timeStampShort]. Initially, I thought its 11g to 12c migration issue but subsequently, I'm noticing same behavior within 12c when deploy from…
-
OBIEE 12c Tmp files location
Hi Team, What is the location of tmp flies in OBIEE 12C Thanks, Avin
-
OBIEE Usage Tracking RPD and Catalog
Hi Please share the Usage Tracking RPD and Catalog for OBIEE Version 11.1.1.9 Thanks Selva
-
Obiee usage tracking info
Hello Guru's, Obiee Version: 12.2.1.3.0 We have enabled obiee usage tracking. And, i'm able to query table 's_nq_acct' to view which user accessed our reports and other information like presentation name, start time, end time etc.. So, for an instance if i have 5 reports as of yesterday - i'm able to view usage tracking…
-
problem with sum for timestampdiff
Hi, I try to calculate Average Tenure (time of work) based on Vesting date and current date. In theory, it should be sum for work time divided by number of employees, but I have stuck with sum part Formula looks that way: timestampdiff(sql_tsi_month,"Person"."Vesting Date",current_date)/12 I'm setting Aggregate rule SUM.…
-
Connect MAP with Table or Column Selector
Hi, I have some problem with maps and table / column selector. Can I connect my levels on map with column selector? --> my goal is: - when I choose some level on map for example CITY I want that TABLE (Column selector) automatic reload to CITY - other site when I choose some level on column selector for example COUNTRY I…
-
Text field in obiee 12c
Hello all, I have a new dashboard prompt with few columns. Obiee Environment: 12c And, one among them has user input field as - Text field. And, others columns are using - choice list, radio button, slider etc.. As per my requirement - users need to only enter numbers in the text field prompt. It shouldn't enter users to…
-
OBIEE 12c Sample Application v607 download issue
Since few days I've problem with download all parts of sample application. The unzipping was finishing with CRC error. I checked MD5 checksums with Microsoft File Checksum Integrity Verifier and all checksums was ok except part 5. I used for download various web browsers several times and always checksum was incorrect.…
-
Permissions on shared folder sub-directories
Hi All, We have just created a few sub-folders under the shared folder. There are several "high-level" folders for the business users, based on team/functional area.Each is currently set to read, traverse, and write. My question is: I'd like to provide 'delete' & 'change permission' to users, for them to be able to use as…
-
Node Manager username and password
Hi All, I have few questions regarding node manager username and password 1) what is the default username and password for node manager username and password in OBIEE 11g. 2) when I go to the following screenshot I am seeing encrypted key. Is there any way to decrypt it…
-
Loading and Retrieve Dates in Correct Format
Summary Loading Dates formatted as mm/dd/yyyy type but they retrieve in scientific notation Content The outline has the date type enabled. The date fields that are loaded are tagged as date types. Information loads correctly and I have confirmed the load file (.csv) has the dates formatted as mm/dd/yyyy. When I go to…
-
Images are not coming in Analytics application
Hi After upgrading Development analytics application from 10g to 11g, images are not coming. Please check the attached screenshot. Can you tell what exactly the reson causing this and how to fix the issue? Thanks Patit
-
OBIEE 12C: Odbc driver returned an error (SQLExecDirectW). ORA-12154: TNS:could not resolve the conn
Can someone help me figure out how to fix this TNS error I'm getting in OBIEE Server when trying to run a simple report? What I'm trying to do - a simple one column report What I get: Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058]…
-
NULL values in graph (running sum)
i, I have problem in OBIEE 11.1.1.7 with area graph. I have on graph: YEAR, TYPE of ENERGY and POWER, I created graph on pivot table: in rows i have years // columns is type of energy // measures: power I have NULL values for some year and type energy - NULLvalues it's mean that table don't have record. I can't use…
-
From testing environment to production
Hi i am using OBIEE 12.2.1.2.0 I want to know how to transfer my dashboards, analysis, prompts etc... to production, i was developing on test environment and i dont know how to transfer that files. Thx, Matija
-
How to disable LightWeight SSO in OBIEE 12.2.1.4
Dear GURUS, I am facing a little weird problem while trying to disable light weight SSO from OBIEE. Details are as below: OBIEE: 12.2.1.4 (Upgraded from 12.2.1.3) Servers: Windows Server 2012 R2 Old OBIEE Home: OBIEE12C New OBIEE Home: OBIEE12_2_1_4 Environment Type: Horizontally Scaled out Command executed from new OBIEE…
-
Null Values are not displayed in Filter values.
Hello all, When I'm trying to Filter the Gender values, it's only Showing the values of F and M where as I also have some records which have Null values for gender. How Can I make them available for the users. Thanks.
-
DV desktop connection creation issue
Summary DV desktop connection creation issue Content I have DV desktop Windows version 12.2.4.3.0 installed on Windows 7. I am trying to create a new connection using connection type "Oracle Applications". It gives me error "Failed to save the connection". Get this error even when I am trying to create database connection.…
-
OBIEE Webservices - Help
Hi All, Can you please let me know web service name in OBIEE, where i need to know Subject Area, Table name and column name of a report through webservice call? Thanks in advance. Regards, Moses
-
RTF Formating using Word Add-on
Summary How to format columns in word rtf template Content I am trying to split the results of a field into three columns. I am using the word-add-on for BI Publisher, and have a paragraph before and after the field . I highlighted the filed and formatted to three columns. Once I do this, I lose the page break at the end…
-
SQL Query not Executing [Request status(500) : error = HTTP 500 Internal Server Error]
Community, I am trying to run a query in Visual Analyzer and it is legal. However once it starts running a window pops up with a header of "Convert to Dataset Failed" and a body of "Request status(500) : error = HTTP 500 Internal Server Error". I looked up this error and it says it is an internal server error. How can this…
-
Enterprise Scheduler Status Critical with JMS Runtime Failed
Guys, We are very new to BI Publisher Enterprise looks like BISystemUser is having authentication problems In the weblogic Server Administartion Console 12c-->Security Realms-->myrealm-->Users and Groups we having BISystemUser In Bi Publisher Enterprise-->Administartion-->Scheduler Diagnostics Enterprise Scheduler is…
-
Tutorials
Community, Does anyone know any good links for tutorials of how to utilize OBIEE better? I previously came from a company that used Tableau and there was endless documentation/tutorials. I know Oracle has documentation but it is pretty abstract. Thank you in advance! Jeremy
-
Fragmentation content - sources not combining
Dear All, I am currently working on OBIEE 12.2.1.1.0 on BICS. On one of the Logical Facts I have implemented a Fragmentation Content involving two LTS s. Individually, the Fragments work fine. However, in case the requisite filter is not added, instead of sources combining as an UNION, the query can not find any of the…
-
Oracle Analytics Cloud - Existing customers?
Summary Evaluating OAC as a potential product and need feedback Content Hello, does anyone here currently own Oracle Analytics Cloud and would be willing to connect with me and provide feedback? I am currently evaluating the product and want a third-party perspective.
-
DVD 12.2.4.xx versions documentation missing
Content Hello, Could someone help with finding the documentation of DVD(Oracle Data Visualization Desktop) versions between 12.2.4.1 and 12.2.4.3? I have searched around but failed to find them. On this page, the What's new is only updated for the 12.2.4 and the 12.2.5 but not in between. In addition, according to that…
-
OBIEE 12c Conditionally Hide Dashboard
Hi, I'm using OBIEE 12c (12.2.1.2.0). Does anyone know if its possible to conditionally hide a dashboard/dashboard page based on a column value in a database table or an OBIEE Repository object? Thanks in Advance.
