-
flat page of obiee 12.2.1.4 after upgarde
obiee 12.2.1.2 login page: obiee 12.2.1.4 login page ============================================================================================================ After I upgrade , I still get the old type home page and when I login , I don't get any thing, it like a static page: As you see there is nothing , not even help…
-
[OBIEE 12c] Unable to run Catalog Manager
Hi all, I have installed Oracle Business Intelligence Developer Client Tool (12.2.1.4.0) on my windows 7 laptop. I am able to run Admin Tools without problem, but unable to run Catalog Manager. I am facing an error : Return status from Catalogmanager command : 13 Is one of you faced this problem ? Best regards, Ben
-
Date Descriptor ID column in OBIEE
Hi everyone, I have some problem when design RPD file in OBIEE version 1.1.1.7.141014. When I design a logical column with Descriptor ID: When I create filter on Analysis. OBIEE show datetime picker for the descriptor id column instead of combo box for the Name column This is what OBIEE show me (datetime picker for…
-
Create insight in Visual Analyzer for Oracle Business Intelligence 12.2.1.2.0
I cannot create Insights in Visualizer analysis VA projects. Once I created the insight, some of the old data is deleted Please could you help?
-
Average in a pivot table not displaying values as intended
Have a basic pivot above that counts attendances for particular days of the year. (ignore the column Attendances AVG ..) i would like to have another total/summary/measure that calculates the running average for a day, week by week so in example above for Monday: Week 27 45 Attendances Avg: 45 Week 28 31 Attendances Avg :…
-
Deploying Analytics Cloud report from Data Visualization desktop to Mobile App
Summary Deploying Analytics Cloud report from Data Visualization desktop to Mobile App Content Hi I want to know how can we deploy Analytics Cloud report from Data Visualization desktop to Mobile App. Thanks Ashish
-
Print Report excel report - BI publisher api for word
Summary Print Report excel report - BI publisher api for word Content Hi, I am having a report layout template created in BI publisher API for word, the reports works as expected but when i print the downloaded excel it cuts off some of the fields. How do i set the Report page or the template to print wide horizontally…
-
User is not able to add reports to favourites menu bar in OBIEE 12c
Hi Team, Users are not able to add reports to favorites menu bar in OBIEE 12c, users has bi consumer role, and we can't provide BI-Author Role. even if he add to favorites menu bar in OBIEE 12c, he is getting an error access denied. Please suggest. Thanks, Avin
-
OBIEE Dashboard prompts
Hi I have a requirement in the calendar prompt default selection. The start date should be from 01-Nov-(year should change after every year i.e., the current year it should show as 01-Nov-2018 and next year after November it should change as 01-Nov-2019) and the second default selection should be the current date. Anyone…
-
DVCS Version
Summary DVCS Version Content Hi, How to check the DVCS Component version in Autonomous Oracle Analytics Cloud. Regards, Dineshkumar
-
Oracle Essbase in the Cloud: A Mercer Advisor's Success Story
Summary Webinar on the successful implementation of Essbase in the Cloud at Mercer Advisors Content https://www.perficient.com/insights/webinars/on-demand-webinars/2017/oracle-essbase-in-the-cloud-a-mercer-advisors-success-story
-
Date filter having sql server as data source not working in obiee 11g
Hi, I am using sql server as data source in obiee 11g but when I am using any date field in filters in reports its giving error as : [ODBC SQL Server Driver][SQL Server]'TO_DATE' is not a recognized built-in function name. I checked the physical query and found that to_date is applied in where clause. The report is working…
-
Enable Guest user
Summary Enable Guest user Content Hi guys, I have enabled for Guest user to read report but facing an error while viewing report as Guest: "Unauthorized Access: Either you do not have the privilege, or you have not signed in." I think Guest could not read data from JDBC, my settings are Administration > Security…
-
Width_Bucket - don't understand?!
I came across something on the internet over the weekend about an OBIEE function called width_bucket - which I had not used before - can anyone help me understand the point of it because whatever I read I am just not following the purpose of it.
-
Obiee new home and old home
old Oracle Home : /u01/obiee12212/ 12212 domain : /u01/analytics/user_projects/domain/bidomain/... new Oracle Home :/u01/obiee12214 I wanted to know , which oracle home will be now used after upgrading the 12212 domain? Nodemanager of old home or new home? I can see the analytics.jar file of new home is taken in EM Thanks
-
Issue with Ago function in OBIEE
Hi, Below is the scenario of my issue. When I try to add the “# of Orders Previous Year” ago function formula to the criteria both the “# of orders” and “# of Orders Previous Year” become 0. The expected results should be as above. “# of Orders Previous Year” formula is Ago (# of orders, Person Visit Year, 1) Can you…
-
BI Publisher - using to_Char in LoV returns Invalid Parameters Requested
Summary BI Publisher - using to_Char in LoV returns Invalid Parameters Requested Content Hi all, I'm using Oracle Business Intelligence 11.1.1.9.0. I have a report where i would like to use a parameter with LoV which is just a sysdate trimmed to the minute : TO_CHAR(SYSDATE, 'RRRRMMDDHH24MI') I make this parameter hidden…
-
Need to understand how data filter works -1
Hello Team, I have asked in last thread about a data filter how it works and thank you for response. (Need to understand about the Data filters ) Current situation:- In my rpd there are two fact table F1-Shipment and F2-ClaimsLogistics. There are no confirm dimension to join these fact table. There is a dimension table…
-
[OBIEE 11G] Business Intelligence node is missing in Enterprise Manager
Hi Team, As the title mentionned, 'Business Intelligence' is missing en EM under the Farm_Foundation_Domain. The more strange is that all my OBIEE Services are working correctly, i am able to connect to Analysis, etc.. without any problem. I have already search solution on the community website and i found no solution yet.…
-
cannot start bi_server1
Hi all , I am just done with an in-place upgrade from 12.2.1.2. to 12.2.1.4 .. all good. except that when I try to being the managed bi_server , it throws this error. Caused by: oracle.security.jps.service.keystore.KeyStoreServiceException: JPS-06519: Failed to get/set credential with map fks and key current.key in…
-
OBIEE Apache Hive
OBIEE 12.2.1 Possible to use apache hive -> data source for OBIEE? Anyone point me at - references - blogs - real world experiences?
-
Upload RPD (-D is not a valid argument)
Hi All, We upgraded to OBIEE 12.2.1.4.0 and then tried to upload the RPD using the command we used in OBIEE 12.2.1.1.0. Command we use is shown below. Once we execute the command, we get an error saying -D is not a valid argument. I checked OBIEE doc for 12.2.1.4.0 and it still have -D argument. Please let me know if I am…
-
Duplicate folders showing in Presentation Catalog (but, not in Catalog manager)
Hi All, I was trying to clean some items up in our Dev instance and have encountered some unexpected behavior. In particular, I deleted a folder (under the shared folders) which contained some analyses for some dashboards. Now, two things happen: if I try to archive and unarchive the same folder from another instance I get…
-
SQL Injection attacks?
Is it possible to attack the databases that OBIEE is connected to via sql injection attacks?
-
Running all the reports in back end while using switching between reports in OBIEE dashboard
Hi Team, We have 6 reports in dashboard.We need to show only the selected report in dashboard.We have used presentation variable and some conditional reports for switching between the reports. We are able to see only the selected report in front end.But all the 6 reports are running in back end.Whatever the report we…
-
OBIEE Pivot Graphs: Columns&lines
Hi! I use the 11.1.1.9.160419 version. I've made a Simple analysis in OBIEE and i want to graphicate it. It would be great if i can use the pivot table view and his graph too. The analysis is simple: by month, i've to show 4 indicators: Efficiency, Quality, Availability, OEE (in the analysis i put them in this order). Now:…
-
OUA 2.7 installation question and error
Hello, I am performing an Initial Installation with the following versions: Oracle DB 12.1.0.2.0 Oracle Fusion Middleware 12.2.1.0 ODI 12.2.1.0 OGG 12.2.1.0 installed on UNIX boxes 1. I am following the OUA Install guide for 2.7.0 (updated Nov 2017), can you please confirm if I understood the Install path correctly: * On…
-
Unable to import oracle db metadata in OBIEE Admin tool
When I try to import metadata, I am unable to connect to the (eBS Vision) database. I did update my tnsnames.ora in Oracle_home/network/admin and can connect to the db using sql developer. I can connect to the db if I use the fully qualified "(DESCRIPTION = (ADDRESS =..." string in the metadata OCI description field.…
-
How to debug/troubleshoot issue related to NQSGETUSERS in OBIEE 12c ?
We are facing issue related to OBIEE 12c login after looking into the log, we found UserPopulation: GetUsers took 5 seconds for SQL {call NQSGetUsers Now, we are not sure about the flow of this method execution, in other word where to look or debug ? What might be causing NQSGetUsers execution longer. We don't see any…
-
Conditional formating based on grand total in obiee
hi all, I have created a report with pivot view and applied grand total (after total option). Can we apply Conditional format based on that total. for example total values is 3 I want to display amber and more than 3 red. Total value coming automatically when we select after total option in pivot view. I have created new…
