-
Problem after admin server restart
Hi, We have recently installed obi 11.1.1.9 in a windows box .. it was all going fine.. But after stopping admin server we have started it by running the bin/startWebLogic.cmd command. But whenever we are cutting off the command prompt windows prompt ,console em and analytics all are going down.. previously we normally…
-
Presentation variable issue
Hi I am using OIBIEE 12.2.1.2.0 My issue is like this I have a prompt page, analysis and a drill down from analysis, I have to pass one parameter from prompt page to drill report, that prompt is not shown on a report from which drill down is made, so i cant make just is prompted filter on a drill report i am talking about…
-
Browser differences
Does anyone know what are main differences between running OBIEE 12 c in Firefox an Explorer?
-
Email Button in Results Bar after Upgrade to OBIEE 12.2.1.4.0
Hi All, We upgraded our non prod environment to 12.2.1.4.0 from 12.2.1.1.0. After upgrade, we notice Email button present in the results bar in of the environment. Email button is visible in all browsers. We need to disable Email button. Also we notice a broken black line in the Analysis page. Please let me know how to fix…
-
Strange behaviour of dashboard page
Hi i am using OBIEE 12.2.1.2.0 I have two dashboard pages and so0metimes i go on page 2 and click save and it svaes me page1 as page two like duplicate it and i lose my prompt page?? Did anyone encountered the same problem Thx, Matija
-
Create Private connection to OBIEE
Hi Experts, I have been trying to use the hypCreateConnection() smartview function to create a private connection to OBIEE, but I am unable to make it work. I was able to use the same function to create connections to HFM/Essbase apps and it works perfectly. The function expects certain mandatory parameters like provider,…
-
OBIEE Mapviewer - Reset Password?
I have a request to investigate how to get maps into OBIEE for analysis. I dug around on google and came across mention of something called mapviewer From what I understand mapviewer is pre installed along with OBIEE (I am on OBIEE 12.2.1.2) I can see that I can pull up the mapviewer url (https://<server>/mapviewer) When I…
-
OBIEE 12c NQUser & NQPassword with SSO Enabled
We recently upgraded to OBIEE 12c. While using OBIEE 11g, we did not have SSO enabled and were able to use NQUser/NQPassword parameters in an OBI dashboard URL so that it would login/appear on an external website. Oracle support is saying there is no way to configure this the same way with OBIEE 12c and SSO enabled. Has…
-
How to bypass SSO for a public user/password to display BI analysis - 12c
In 11c, we could bypass SSO by appending &NQUser and &NQPassword to the analytics URL when the dashboard was specified. Here's an example below: http://hostname:port/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FDashboardname&Page=Dashpage&NQUser=XXXXX&NQPassword=YYYYY&syndicate=Siebel This allowed us to put a public…
-
Oracle Data Visualization / ML
Content Dears, I am a beginner in using ODV and i need to prepare a HR report but I don't have any experieI I want to prepare a HR report using ODV but i don't have any experience neither ODV nor HR. i would appreciate if you can mention some videos, documents and the most important is providing me a HR report use ML.
-
Update to DVD (Next Release)
Summary The promised June release never came with all the promised map changes. Content Looking for when the next release for DVD will come. It was previously on a monthly release cycle, but that has seemed to have stalled as the last release was 12.2.4.3.0 in May. Is there an update with the publishing date of the next…
-
Complete data in email attachment
Hi, I have an agent which send out an Analysis as an attachment in the email. When I open the analysis through the OBIEE dashboard, I have to click the arrow button to navigate to the next pages to look at the complete data. But when the email is sent, it shows only the first page in the attached PDF or XLS. Is there a way…
-
OBIEE Error 15048
I have a logical table called MyTable Dim. When I do a global consistency check, all works well. Next, I added a level based hierarchy in the logical level containing three fields from MyTable Dim. Now, when I do a global consistency check, it gives me an error on the Business Model. The error number is 15048: "The logical…
-
OBIEE archive specific object
Hi, OBIEE 12.2.1.0.0 I am trying to 'model' some automated scripts(Linux) to manage objects in OBIEE catalog .. I am successful with runcat.sh report command to list the required catalog objects.. what I am trying next is to runcat archive command on one object(analysis) (or a list of objects ).. What I can find from help…
-
Grand total of subtotals
Hi I am using OBI 12.2.1.2.0 Can someone tell me how to add grandtotal of subtotal to pivot view, i have a subtotals by stores where i count how many products are sold on my analysis but i want to have a grandtotal of all stores , I dont see option for that Thx, Matija
-
Customizing a 'Total' label
Hi, I am using OBIEE 12.2.1.2.0 I would like to know is there a way to set a custom name in Total labels, but not in the way that it has a label that is the same throughout analysis but in the way that it has dynamic name like Totals by (value of the column) For example if the column name is Store 1 My Total should be…
-
Assertion failure: 1 <= nMonth && nMonth <=12 at line 629 of project/webbedrock/datetime.cpp
Due to customers being on different versions of OBIEE, we develop our RPD in 11g and then convert to 12c where required. Have come across a strange issue where a date object recently added works fine in 11g but is generating the below error when selected in a 12c environment, can anyone see anything obvious as to why?…
-
Case in text box in obiee
Hello, I am using OBIEE12c In text box on Dashboard I placed a thing like this Year: @P_YEAR (which is a presentation variable i put my prompt in) So I can show which year i chosed in prompts, but when i dont choose anything it says Year: @P_YEAR What i want to do is if i dont chose year it should give me Year: How can i…
-
opening and closing balances in supplier ledger advances summary(Account Payables) in BI Publisher
Summary supplier ledger balances summary Content Hi, Have got some custom BI Publisher requirement where i want to get the supplier number, name , opening balance of selected from date parameter , debit , credit and closing balance. opening balance should be previous date closing balance. This is custom build not standard…
-
Hiding "Edit Dashboard" option to Specific Role
Hi, I am trying to disable "Edit Dashboard" option for specific groups/roles in OBIEE 11.9 version. What is the procedure to disable this "Edit dashboard" option Thanks in Advance GSR
-
Customizing Prompt value in BI Publisher rtf report
Summary Prompt value for All option shoud show text - 'ALL' isntead of all the values from the prompt Content Hello All, I got a requirement in BI Publisher Reporting.The users wants to see the prompts that are selected on top of the page in output. Currently they're seeing the selected prompt values. But the latest…
-
Data Model shows - Failed to Load XML when All is selected in the prompts.
Summary when selected All in all the prompts - Data Model shows - Failed to Load XML and inturn Report is failing. Content Hi Gurus, I've a report which works fine with manual selection of values for the prompts. But when I enable 'Can Select All - All Values Passed' Data Model is throwing error - Failed to load XML. Total…
-
obiee 12c calculated measure from two other measures - incorrect values
Hi Gurus, we have a requirement to create a custom metric in answers. This new metric is the division of other two metrics. Issue is when i create this new metric and pull the other 2 fields into the f(x) and set aggregation content to average , obiee shows incorrect values. Third metric is a simple division of first…
-
Aggregate rule in rpd not working
I have created an rpd with an aggregate rule set to sum howver when I upload the rpd to BICS, the aggregate rule doesn't seem to work and instead of getting a sum I am getting a count. anyone ran across this issue before?
-
Previous quarter value in variable
Hello! How to do a proper calculation to get a previous quarter value using passed presentation variable? I have @{Quarter} in my prompt which passes a quarter for "Sales - CRM Pipeline"."Time".Enterprise Quarter" and then using this variable I want to get a previous quarter for "Sales - CRM Historical Pipeline"."Pipeline…
-
download analysis results to csv using agent (oracle bi12)
I need to download analysis results to csv-file using agent. Is it possible? I've tried to use a js-action (like it's described here OBIEE: Actions in Agents - Part 1 ), but it doesn't work for csv (and cirillic letters too) May be there is a way to configure delivery options or smth else for this task?
-
Business Intelligence & Data Integrator Domain on single Node
Hi, I have installed below tools on Windows Server 2012 single node machine: * Database 12c R2 * Business Intelligence 12.2.1.4.0* RCU - Completed * Domain Configuration - No done yet * Data Integrator 12.2.1.3* RCU - Completed * Domain Configuration - No done yet Is it possible to configure BI and DI domain as 1 domain on…
-
OBIEE 12c: Image not showing in dashboard page after scheduling entire page in HTML format
Hi all, I have scheduled a dashboard page in HTML format as delivery content to email. In dashboard level I am able to see image icon but after receiving dashboard page to mail I am not able see image. It is showing cross mark icon. I have added that image in Obie shared folder not in server level Below one is image syntax…
-
ssi folder doesn't exist
Hello Experts. I am facing an issue while downloading/uploading the rpd in OBI 12c. Issue:- We have migrated from obiee 12.2.1.3.0 (Build BIPS-20170820114118 64-bit) (older version was 12.2.1.1.0 ) on cluster node. All the services are up and running fine. When we are trying to run the command…
-
debugging isprompted problems
Are there any tools to see isprompted values or session metadata available in a report using javascript? I have a number of pages on a dashboards that drill to common data, single key to single key. The drills go a report based on one subject area to another and the common column is in the same folder and has the same name…
