-
SQL query in obiee report
HI, Please suggest me ...i have report which shows I have 100 employees. there are CEO and subordinates My report should display data in the follwoing way EMployee Sal CEO 10000(CEO only) Subordinates (99 employees) 80000 (sum of 99 employees) All CEO salary + 99 employees salary I have written query with union ....i…
-
Analysis description as tooltip - limitation.
-Hi, When I add a comment to Description property of an Analysis, I can see the comment as a tooltip. However this is only valid when the Analysis' title is included in the compound view. If the title view is not included in the compound view or on a section we select only a table view (e. g.) then the tooltip can't be…
-
Job Manager Window is not opening
Hi, I have installed OBIEE (with jdk 7) and Oracle Database 10g over Windows Server 2003 64bit. All runs fine but when I try to open Job Manger, nothing happens. I have tried the following: 1-run Job Manager form OBIEE Menu as Administrator 2-run Job Manager from Administration tool I found the following in the END OF log…
-
To filter a fact based on an other fact
I have a report where I need to show: 1) number of invoices paid before due date 2) amount related to invoices paid before due date 3) number of invoices paid after due date 4) amount related to invoices paid after due date I have a drill action that shows per number of invoices what suppliers these are related to with the…
-
BIEE logging
Is there method to know who (account) and from where (IP) logged into BIEE? I checked presentation service log which not contain IP.
-
OPMN Listener thread terminated
content of the OPMN.log My os is Window 7 Oracle Database 10g Enterprise Edition 10.2.0.4.0 64bit BI was updated to 11.1.1.7.151020.326 ------------------------------------------------------------------------------------------- when I tried to run "opmnctl start" then Communication error with the OPMN server local port.…
-
Fact Granualarity
Hi all, I have a data in fact table at day level,but my requirement is to populate a report from that fact table at hour level. I mean at 12:00 AM , 1:00 AM, 2:00 AM etc.. So can anyone advise how to solve it..
-
image Path Obiee 12c
Hi experts, I have migrated from OBIEE 11g to OBIEE12c successfully, but I can't see any custom images. Some pages of dashboards have an analisys with static text that has HTML code like this <body> <a href="saw.dll?Dashboard&PortalPath=/shared/Repo/_portal/00.Menu&Page=Menu&Action=Navigate"><img…
-
Passing Variables from Agent to Analysis
I'm working in OBIEE 11.1.1.7 and I am having trouble assigning variable through an agent. I have columns which are derived from variables configured in the prompts tab. For example: YEAR(Production_Date) = @{p_report_year} or YEAR(Production_Date) = @{p_report_year} - 1 When the analysis is run manually, it prompts for…
-
Count on dates
Hi, I like to calculate the count of joined employees, termination employees and the total employees from a given year and all months of that year. I have joining Date field and Termination field, I can not calculate joining and termination based on dates in a single analysis, moreover I can not find a solution to…
-
authentication using two different AD authentication providers (2 separate domains)
Does anyone have a working installation of OBIEE 11 using AD authentication with 2 different domains, implemented as 2 different AD authentication providers in the WebLogic console? We have some users who are members of domain "A" and a secodn group os users, members of domain "B". Our system works correctly against for…
-
Session Variable Multiple Values in Default Initializer
Hello, i have created a session variable in the rpd for the purpose of defaulting a department dashboard prompt for, a select set of users, to their appropriate departments that they are responsible for. My question is; if the session variable returns no rows, is there a way to set the default initializer to select all the…
-
Column Properties Doesn't open up
Hi All, I am on OBIEE 11.1.1.7.0. When I click on column properties, the column properties doesn't open up. Please help me out. Thanks, Deep
-
Demo VM for exploring OBIEE 12c
Hello All, I am looking for a demo VM for exploring OBIEE 12c. Found one in the below path technetwork/middleware/bi-foundation/obiee-samples-167534.html. Have few doubts. 1) will i be able to control fusion middle ware and weblogic in this VM? 2) Can i modify RPD? 3) Is it possible to access the underlying 12c DB and…
-
how to calculate last year current month in obiee 11g?
Hi, I want to calculate last year current month in obiee 11g. i have tried in db. ----SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -12), 'YYYYMMDD') FROM DUAL; Using the above query, last year current month is --"2015-01-08" But i want to get same result using timestampadd() in obiee 11g. Please help me, Thanks in advance, A.kavya
-
Unable to see data in one column on analysis
Hello, I can't see a data in one column although I can see data in database, here is my scenrio: I'm creating analysis like this: As you can see I'm able to see data only in 2 first columns but not in last one. So I'm checking the query in logs and it looks like this: from DIM_ACCRUALPARTNER T2632, DIM_REDEMPTIONPARTNER…
-
Date format uppercase in OBIEE analysis
Hello I am intending to show date in an OBIEE report in the following format. 12-JAN-2016 To do this I am going to column properties -> data format-> select "custom" -> and specify DD-MMM-YYYY. I am getting the date output as 12-Jan-2016. So the problem is Month. How can I get JAN instead of Jan . I also tried DD-MON-YYYY…
-
OBIEE Query Performance degrades when using synonyms
Hello All, I have 2 schemas(say Schema1 and Schema2) where, Schema1 has the actual table and Schema2 has a synonym for the table created in Schema1. For example, I have a table Schema1.Tbale1, then it has a synonym in Schema2 as Schema2.Table1. When trying to generate a direct database request from analyitics using the…
-
Error while scaling out
I am trying to scale out my server horizontally. I have created a shared folder for rpd and catalog. Everything works fine till this. But when i try to add system components at EM -> coreapplication -> Capacity Management -> Scalability, and restart the services, i am getting following error. Command failed: Instance…
-
Parent member in dashboard prompt should select child hierarchy as column
We have a OBIEE-Essbase(ASO) reporting application and have a requirement where a parent member selection should show its immediate child level hierarchy. Any suggestions on how to go about it.
-
Finding the corresponding mapped Siebel field to OBIEE's Presentation layer
Hi all, I'm fairly new to OBIEE and I'm needing to find out what Siebel field/fields makes up a particular fact field in the Presentation layer. I can trace it back to the physical layer in the repository, but I need to know the exact field/fields names in Siebel. I've attached a screen shot of the column source from the…
-
In OBIEE 11g, "Saved Customization" is not working.
Dear Techies... Hope every one will enjoy Good Health & Wealth by this year ahead!!! Environment - Siebel is integerated with OBIEE 11g 1) Able to log in OBIEE from Siebel without any issue and able see all dashboards without header pane. 2) I have saved the Customization on Report UI. Issue is: 3) When I select saved…
-
AND or OR values in Prompts
Hi, I have come through a new request that whether can we create or define two buttons And, OR at prompts. so user can choose any of these both if he wants to further filter on the rows Example: Chequing Acct Indicator = 1, null values savings acct indicator = 1, null values if user choose both 1 value at prompt, it…
-
Scale Markers with Ranges on both X and Y
Want to add scale markers on scatter plots where the markers are in range in OBIEE. The range for X axis is specified, but the the range colors should not start at 0 of Y axis but at a higher value. Attached is an image. Imagine those grey the boxes to be colored ranges.
-
Hiding of rows in pivot table view
Hi, I want to hide the rows in a pivot table view based on a conditon. for ex: i have a pivot view with following structure Op CodeVoyageop costrunning costtotalv10100110011012000030100100200 Now i need to hide the row which has total 0.. the measure are coming from same column but not calculated in OBIEE. Regards Sreekanth
-
Users and groups
Hi All , I am here having one doubt about the users and groups in the OBIEE 11g .As I know the all application roles are stared in system-Jan file in weblogic but where the users ad groups and their passwords will be stored in weblogic ,Measn where identity store will be saved in weblogic.If any one is aware of this thing…
-
DISPLAY THE DATA BASED ON PROMPT SELECTION IN OBIEE 11G?
Hi, I am woking on obiee 11g. I want to display the data as current_month, previous_month, variance. My requirement is , if select the month, then automatically display the current_month and previous_month, variance data columns in table. Please help me. Thanks in advance, A.kavya
-
OBIEE 11g OPMN Issues
Good Morning all All the best for 2016 i hope this will be your year of great things. Iam facing an issue when trying to Start OPMN from the Linux back end. Please see the error i am getting when trying to execute opmnctl startall [2016-01-07T10:10:50+02:00] [opmn] [ERROR:1] [] [internal] lxlinit - NLS boot file not found…
-
Reuse 5 dashboard pages bundle in multiple pages
Hi, I have one dashboard and that has 5 pages. My requirement is need to create Links for all pages from the active opened page (report). Ex: let's call dashboard name as D and page names as P1,P2,P3,P4,P5. Dashboard D has 5 pages (P1,P2,P3,P4,P5). Suppose If I open P1 in D, I want to see links for all reports with links…
-
Change Pivot View Layout to Right-to-Left
Dear Experts, I am currently working on creating a pivot view report in Arabic and since the Arabic text is written right-to-left, I need to have my pivot view's row measure labels to start from the right instead of the default left. I have tried enclosing the pivot view between two narrative views, with HTML markup…
