-
How to call stored procedure in direct database request obiee 11g analytics?
Hi, I have created stored procedure in db.... I want to execute stored procedure in direct database request in analytics.. When i trying , i am getting errors.. my stored procedure is CREATE OR REPLACE PROCEDURE TESTINGPROCEDURE(OutCur OUT sys_refcursor) AS BEGIN OPEN OutCur FOR select * from w_company_d END; execution:…
-
GroupByNoSort in OBIEE leading to wrong data
We are trying to create a very simple report with our datamodel with 1 fact and 3 dimension with simplest joins with 1 column keys. When running a report from OBIEE Answer on top of this data model , we are getting wrong results. And i could see the logs it is some kind of function applied : GroupByNoSort Please help.…
-
Add Hierarchy to dashboard prompt
Hi, I have some question I created analysis: And add filters: And I add Purchasing Category Hierarchy to dashboard prompt: But when I open a dashboard, and choose some option in prompt, for example: Nothing happens: Do I need something extra set or whether there is even an option to use a hierarchy in prompt?
-
12c calculated item not showing up in analysis when add column view (worked in 11g)
Hi Community, When I add a calculated item to an analysis it shows up in my bar chart. The analysis is just one measure by one hierarchy dimension that uses selection steps. When I add a second dimension to the sections. The bar charts that show up no longer show this calculated item anymore. This worked fine for this…
-
Installing OBIEE11.1.1.9.0 On Windows Server 2012 SP2
Hello Experts, I am trying to install OBIEE11.1.1.9.0 On Windows Server 2012 SP2. I have been asked to do S/W only installation as Enterprise Installation was failing (Doc ID 2027617.1). The solution was - There is a work-around which is to implement a software-only installation and follow the instructions in section 4.2.5…
-
Missing or bad option "-baseline" when comparing two catalogs
I'm using OBIEE 11.1.1.7. I have archived off 2 catalogs (shared folders only). C:\temp\old_shared and C:\temp\new_shared. I am trying to compare the 2 files using the following command: runcat -cmd diff -baseline c:\temp\old_shared -latest c:\temp\new_shared -outputfile c:\temp\diff.txt -verbosity detail When I run this…
-
OBIEE 11g Pie chart - pie name text size
Hi all, on chart having multiple pies, any way to change the text size of "pie name title"? Standard interface permits to format legends and data markers only. Thanks! P.
-
automatically exclude a new column from a pivot table
Hi, I have some reports that have several pivot tables. If I add a new column to one of these reports it gets automatically included in the pivot table. This can cause an error as too much data may be returned for the pivot table to be created. I cant exclude the column using drag and drop because the results screen hasn't…
-
Reg. Access Privilege to New User in OBIEE 11g
Hi all, We have OBIEE 11.1.1.1.9 installed and in the process of creation of new groups and users. I followed the below steps for creation 1) A new user (ABC) is created in Weblogic Administration Console. 2) A new group (RetailUsers) is created in Weblogic Administration Console and assigned to BI Consumers Group. 3) The…
-
OBIEE SAMPLE
withdrawn
-
Convert char to date format in obiee 11g?
Hi, I want to Convert char to date format in obiee 11g. i have this date '07/31/'||CAST(YEAR(CURRENT_DATE) AS CHAR) I want to change char to date format. please help me, Thanks in advance, A.kavya.
-
Issues While Installing OBIEE11.1.1.9.0 on MS Windows Server 2012 SP2
Hello Experts, We are installing OBIEE11.1.1.9.0 on MS Windows Server 2012 SP2. It was installing (Enterprise Install - Create New BI System) smoothly however in the last configuration Progress Page at 27% it was stuck. As per oracle's recommendation - This is a problem with WebLogic Server installing on Windows 2012 R2.…
-
Trouble getting Percentage Variance between 2 Values used to get by Timestamps in Obiee
Hello, Im having trouble working out a percentage in OBIEE. Im trying to work out what the variance level is between current Month and Previous month. I have created 2 formulas using time stamps. Current Month Sum(DISTINCT CASE WHEN "XXXXX" >= TIMESTAMPADD(SQL_TSI_DAY, -1*(DAYOFMONTH(CURRENT_DATE )-1) , CURRENT_DATE ) AND…
-
Set date differentiation in BI: 7 days ago
Hello, I am using Oracle BI. I would like to create a report to be based on the recent 7 days. What is the formula / code to be used in BI? Regards, Uriel
-
Changing horizontal axis label orientation to 90 degrees instead of -90, dynamically.
Hi, We have OBI EE 11.1.1.7.0. Initially, at higher levels of a hierarchy, on a vertical bar chart, the horizontal axis labels are displayed with 0 degree orientation like as under. This is fine. However, when drilled down, the horizontal axis labels are displayed with -90 degree orientation, by default, like as under. Is…
-
OBIEE 11.1.1.9 on Windows 10 64 bit
Hello, I am facing an issue while installing OBIEE 11.1.1.9 version on Windows-10 64-bit version. The process gets stuck at step # 13 - Deploying Financial Reporting JEE Application... I tried to check this link https://bisoftdiary.com/obiee_windows10_not_a_guide but not much of help. Any help?
-
Trouble working out percentage in Obiee using timestamp formulas to bring back total value
Hello, Im having trouble working out a percentage in OBIEE. Im trying to work out what the variance level is between current Month and Previous month. I have created 2 formulas using time stamps to get my overall value back. Current Month Sum(DISTINCT CASE WHEN "XXXXX" >= TIMESTAMPADD(SQL_TSI_DAY,…
-
Configuring OBIE EE 12c with AD/Kerberos and SSO
Dear Experts, I'm dealing with problem in configuring OBIE EE 12c with SSO. MSO documents are pointing out to some OBIE EE 11g configuration screens which are inadequate in OBI EE 12c. In Doc ID 1274953.1 there is: ---- Stage 3: Configure BI for SSO <Moderator Edit - deleted contents of MOS Doc - please do NOT post such…
-
Installing OBIEE 11.1.1.9 on windows 7
I have installed obiee 11.1.1.7 32 bit on Windows xp several times without any problem. Now I am trying to install obiee 11.1.1.9 on Windows 7 64 bit and I downloaded the files from Oracle OTN. I installed the loopback adapter Edit hosts file as localhost 10.10.10.10 (I am able to ping localhost) Installed…
-
Hide columns in RPD
Hello, I have the following requirement: I created a new group in OBIEE called BIAuthorLimited. I need to hide certain columns in the presentation layer from the users in this group when in Edit mode. However, these users should still be able to see the columns in existing analysis during run time. I tried using the "Hide…
-
For "YTD/month" - store "YTD" in OBIEE/Essbase and leave "/month" to MS Excel?
Hello, I was wondering about in either OBIEE or Essbase, I know it's already very common to have YTD as a time series stored member in the system. However, what about the times when it comes to interpreting complicated calculations such as "YTD/month"? Would you still save "YTD/month" in OBIEE or Essbase? or would you just…
-
Essbase - OBIEE
Hi All, This is not the first time I am trying to use Essbase as a source for OBIEE. Never had this issue. I have one BSO cube where Accounts dimension is measure dimension, these Period dimension. And some other dimensions like Industry, Location etc. In OBIEE, I have made the measure dimension as Value type and it's a…
-
Error outside of Presentation Catalog occurred.
Error outside of Presentation Catalog occurred. Error Codes: EUMOQYH6. Do anybody know why I'm getting this error on my dashboard? Solution: * Check Obiee Application Server Disk Space.
-
Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.?
Hi All, I am trying to display more than 10,000,000. it is been showing error as Exceeded configured maximum number of allowed output prompts, sections, rows, or columns. , the columns were only just 5 and 2 prompts. The links I have found were.…
-
LDAP(Microsoft AD) failover on BIEE 12c
Customer Problem Description --------------------------------------------------- Problem Summary --------------------------------------------------- LDAP(Microsoft AD) failover on BIEE 12c Problem Description --------------------------------------------------- BI server dont do failover between LDAP hosts right 1. I…
-
How to call db functions from obiee 11g?
Hi, How to call the db functions from obiee?. I want create reports in analytics using 'Create direct database query'?. please help me . please send document for this.. Thanks in advance, A.kavya
-
Session variable error with no reference to session variables in Prompt/RPD
I am receiving 3 errors in the session logs for my dashboard prompt as seen below. Despite multiple prompts using the same identical subject area and column prompts, only one dashboard is throwing these session log errors. I have done extensive research for this error type and all solutions point to either the dashboard…
-
Ho can we change the display type in a column in OBIEE to "change sign"?
We want to generate an income statement in OBIEE Is there a way, like in Oracle eBS FSG's, to "change sign" to display data in a row/ column? We only want to change the way a particular row/ column DISPLAYS data without changing the underlying data itself. This is to show Revenue account balances as positive number (with…
-
Resetting password for RPD in obiee 10g
I am trying to reset password for the RPD and though I make changes on the nQSconfig.conf file it still fails to login. Can someone please help me with this. Thanks in advance!
-
saved customization location
where can i see saved customizations in file system?
