-
12c install - Config assistant complaining BIPLATFORM schema is missing
Seeing a strange error with the OBIEE 12c install, when I get to the Configuration part to install domains and enter the RCU information, it is complaining that the BIPLATFORM schema is missing, when in reality it is there and was installed successfully by the RCU. Steps 1) Ran RCU - generated scripts for DBA 2) DBA runs…
-
Conditional formatting for grand total column in pivot view
Hi, In my report, i am using conditional formatting on measure column. But those conditional formatting is not applying in grand total column in pivot view. any work around for this?
-
User of Power function in RPD
Hi, I am trying to develop this excel formula in OBIEE using Power function. =((1+11.9/100)^-0.25)*(Auth Total Interest + Auth Total Fee) =((1+0.119)^-0.25)* (Auth Total Interest + Auth Total Fee) Can anyone please help to get the right syntax. I am not sure how to apply power of -0.25. Thanks
-
Add report numbers in incremental order
Hi, i would like to know if I can add number to the report and whenever I do the migration, for the new copy I want next number. Ex: today I have report in prod. Initially I want to display 1. Next week if I do some changes in UAT and do the migration to prod, then I want that number to be increment end to 2 On the report.…
-
Update Saved customizations
Hi, 1) we have saved customizations created by users in UAT environment. I would like to know how to move all those customizations to prod Or if I move report to prod automatically does customizations for all users come with report? 2) we have requirement like data can be updated in saved prompts selections in saved…
-
Adding SA button disabled while creating a column prompt
Hi friends, Im in OBIEE 11.1.1.7.1 When im trying to create a column prompt with the primary SA and also im trying to add the another column from the other SA, but the button for adding it is disabled in the column prompt window. But from the help note i can find this "This button is available only if one or more related…
-
How to restrict the date prompt values in obiee 11g
Hi, I have a requirement wherein I would like to limit the values of date prompt in the dashboard for user selection. For example:The user will be allowed to select the date from year 1990 till 15 days after the current date. All other dates will be disabled or greyed out in the calendar. Thanks, Sayan
-
Free formatting of graph labels in views
Is there a way to format the labels of graph in a view so it get information from another place instead of the graph axis? My case is the following: I have a table made of three sets of three columns, like the following example (hypothetical values): State_s1 Date_s1 Total_s1 State_s2 Date_s2 Total_s2 State_s3 Date_s3…
-
RPD cust BI apps
Hi all, I came to know,OBIA has rebuilt RPD and webcat,but in general what changes required to do in RPD part.. Since I am new to OBIA, I need your valuable suggestions. Also please do share any url links for better understanding OBIA finance module Thanks
-
Oracle Mobile HD - Reload Content
Hello Everyone, I have installed the Oracle Mobile HD Apps and connected to my OBIEE, When navigating from one dashboard to another I am am Network Content Reload Error, so often it pops up, even though I cancel or click ok... Thanks, Thirumal
-
Oracle reports builder - format bar graph
Hi, I have a bar graph created in Oracle Reports Builder which contains 3 series. Normally I will only see 1 series for each value on the x-axis. Is it possible to expand the bar to fill the entire width on the x-axis value instead of staying in it's relative positions. See image. I would like to see the bar in the middle…
-
URL (from database field) in RTF report
Hello! I create BI Publisher report (ver. 11.1.1.7..) in RTF format. One of the fields of the report contains the URL link to an external resource. URL is stored in one of the database fields in the format (varchar2). After the launch of the report, URL is displayed as the text, it is not clickable. Please tell me how to…
-
OBIEE 11g Mouse Hover display column value from another dimension
Hi, I want to view column definition using mouse hover. I loaded the column definition in one dimension. Is it possible to view those dimensional values using HTML or JQuery. Any example would be appreciated. Thanks,
-
OBIEE enterprise manager doesn't show system components
Hi Experts, I need your help here, i have upgrade OBIEE 6.9 to 7.0 and everything upgraded successfully and all the services are up and running. But i got one problem that enterprise manager doesn't show any system components. Overview tab is blank, saying NO DATA TO DISPLAY. Availability folder shows 5 OBIEE components…
-
Best practice to display a wide data range on a non-table view.
Hi, Currently, we are on 11.1.1.7.0. I have developed a stacked vertical bar chart to display data by hour and various zones. The data range is wide (0.01 .. 500) and because of this, lower end stacks are not visible at all. I have tried zoom in along with scaling based on data, dynamic scaling and also specific scaling.…
-
Not able to open RPD in online mode
Hi friends, I am not able to open RPD in online mode. I am getting this error "log on failed due to : nqserror 37001 could not connect to the biserver instance" please do the needful help. Thanks in Advance.
-
Upgarding Operating System of OBIEE and BI Apps Server
Hello, Currently OBIEE(11.1.1.7) & BI APPS(11.1.1.8) is running on Windows Server 8 SP2 but infrastructure team is planning to Upgrade Operating system of BI to Windows server 2010. Is obiee and BI APPS will support windows OS server upgrading? OBIEE 11.1.1.7 BI APPS 11.1.1.8 weblogic 10.3.6 OS Windows Server 8 SP1 ODI…
-
Getting error like:The authentication has exceeded the allowed amount of time. Access for the reques
HI, I am working on obiee 11.1.19 Getting error like:The authentication has exceeded the allowed amount of time. Access for the requested connection is refused. in obiee 11g analytics I am able to login into console, enterprise manager that credentials are weblogic(uname), welcome123(password). same credentials are i am…
-
Catalog Migration from OBIEE 11.1.1.7 to 11.1.1.9
Hi, We develop custom BI analytics in OBIEE 11.1.1.7 and we want to migrate to our new OBIEE 11.1.1.9 environment. Is there any migration utlitle in OBIEE 11.1.1.9 cause we try to open old OBIEE 11.1.1.7 reports we didn't got any success. regards
-
Unable to Edit a view in Answers - getting 'Processing, please wait ...'
Hi, I am trying to edit a view of an Answers BI report and am getting 'Processing, please wait...' - and the view never displays. I am trying to delete a summary line so don't know how else I can do this other than editing the view at run time. Many thanks, - Jenny
-
iam installing obiee 11.1.1.7.0 32bit version i faced the problem last 13 th step configure bi doma
please give the solution Message was edited by: sureshbhavana
-
OBIEE Authentication Through OFFICE 365
Hello Experts, We are trying create a scenario where a user logs in to Office 365 and he gets authenticated in OBIEE as well. He doesn't has to go through one more authentication to view OBIEE Dashboards. I wanted to know if this can be achieved, if Yes can i please get steps of how to configure it. Thanks,
-
Prompts, Top Parents by X and Top Parents by Metric
I have a requirement to create 2 prompts, Top Parents by X Allows users to select the number of Top (10, 25, 50, 75, 100, 200, 250) Parent Customers as they are ranked by metrics as identified in separate filter. AND Top Parents by Metric Allows users to select the metric used to identify Top Parents by that specific…
-
In OBIEE how to convert the currency
Hello , I have one revenue column and one related to revenue currency column , but the problem is revenue contain multiple currency value (Eg:- AED, USD,EUR,INR) but I want to convert all the currency in to USD format . How i solve this issue , please help me Thanks & Regards Sandeep Andhale
-
ORA-20001: YOU CAN NOT CREATE, ALTER OR DROP (Kindly Use SUPERPKG)
Hi Experts, i'm very new in oracle Obiee. i have created one analysis but its given error message like tate: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Oracle Error code: 604, message: ORA-00604: error…
-
how to add empty row in middle of the rows of analytics report obiee 11g?
Hi, I am working on obiee 11g.. i want add empty row in middle of the rows in analytics report obiee 11g For example, empty rows marked in the following screen shot.. Please help me, A.kavya
-
How to draw 'X axis' of chart by Hour (actual data is Min and value)
I gurus, I have a difficulty in drawing chart. Below is sample data. Hour Minute Value ------- ---------- --------- 16 20 15 16 36 20 16 55 22 17 2 25 17 11 35 17 22 33 18 5 31 18 10 40 ... As you know, the records has 1440 (24Hour X 60Mins) and I would like to draw X axis chart only show 'Hour' not by Minute. Is it…
-
OBIEE 12c. Relative path to the objects in the dashboard
Hi! Is it possible use relative path to the objects in the dashboard? I want make dashboard in my special folder (all object will be created for dashboard in this folder), next i move this to other folder (for all users). And if i open a dashboard in the new paths, i get error, because objects in the dashboard reference to…
-
How to add custom visualizations to analysis?
Hello Can anyone tell me how to add new custom visualizations to the view definitions. So far I was using the narratives to achieve through javascript, but would like include my visualizations to be part to the existing views list. Anyone know how to achieve it? Thanks
-
Connect OBIEE windows client to Linux VM
Hi, I have installed SampleAppv506p running in a Virtual Machine on my windows PC. I want to connect to OBI in the VM with OBIEE windows client from my PC. I need to establish a ODBC connection for that, but don't succeed. Trying with telnet from my PC to the VM also gives an error. telnet 10.0.2.15 9703 => Connecting To…
