Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Does the URL I sent work?
-
Sorry, I meant Http://localhost:7001/console
-
Port 7001 is the port that your Admin Server is running on. You'll need to go to your Admin Console localhost:7001/admin and then navigate to the Servers section where you'll see which port your Managed Server (BI Server) is running on. Your OBIEE URL will then be http://localhost:port number/analytics
-
So you'd have to build your SQL statement for your DDR report. An example with pseudo code is: SELECT CASE WHEN column1 = 'ABC' THEN '<FONT COLOR="#00FF00">' || column1 || '</FONT>' ... END column1name, CASE WHEN column2 = 'ABC' THEN '<FONT COLOR="#00FF00">' || column2 || '</FONT>' ... END column2name FROM tablename
-
Hi @EmmanuelMash, here's my 2 pennies worth - there is no scientific formula to this I'm afraid but most times, it is ends up being a case of "if it aint broke, don't fix it". patches are usually applied to correct issues with certain functionality. Ideally, it would be best to be using the latest versions but that again…
-
The folder can be anywhere as long as the OBIEE server has access to it. "1) First you must create a folder on the OBIEE server filesystem (or at least a place OBIEE can access, can also be on a mounted shared folder). This is the folder where you place the content you want to make available via your browser."
-
Yes. Sent from my iPhone
-
In 11g, the only way of doing this is to create this column in the repository for reuse elsewhere. In 12c however, you have the option of saving a column formula in the same way you can save a filter and reuse in other reports for instance.
-
@Gianni recently blogged about this: https://gianniceresa.com/2016/12/deploy-custom-folder-obiee-12c-analyticsres/ Once you've followed these steps and created a custom folder, you can place your images in there and they'd be accessible to OBIEE. I'm not awre of any image size limits but larger images will slow down your…
-
In which case, I think that you should look at your SSL certificate.
-
Possibly. Have you done the SSL SMTP server configuration? https://docs.oracle.com/cd/E23943_01/bi.1111/e10543/ssl.htm
-
The only way you can get this done is by implementing the conditional formatting yourself. You'll need to go the the column format tab and ensure that the HTML markup checkbox is checked. You'll then need to use a CASE statement in your formula to set the background colour, font colur etc of the column dependent on your…
-
Have you tried to open admin tool from another machine?
-
As Gianni said, Direct SQL requests bypass the BI Server and are executed directly against the underlying data source so as a result there is no cache involved with these query types. Sent from my iPhone
-
There are a load of variables to take into account in making that decision ranging from resilience, failover, hardware capacity, usage capacity to mention but a few. For some guidance, take a look at Oracle's capacity planning guidelines - https://blogs.oracle.com/proactivesupportEPM/entry/obiee_capacity_planning Sent from…
-
There's no reason as far as I'm aware why BVT won't work in your scenario. Be aware that you'll be using the BVT to carry out catalog, UI, reports, logical query and dashboard tests Sent from my iPhone
-
A quick google search brought back this document https://docs.oracle.com/cd/E14571_01/bi.1111/e10543/privileges.htm Sent from my iPhone
-
Hi Luciana I forgot to mention that you will also need to restart your BI Server after making the NQSConfig.ini change. EVALUATE_SUPPORT_LEVEL needs to be set to 2 and I can't see anything wrong with your EVALUATE syntax.
-
You'll need to replace columnofyourobiee1 and columnofyourobiee2 with your actual OBIEE Presentation Column names, for example, "Time"."Calendar date". Also, you'll need to change EVALUATE_SUPPORT_LEVEL to 2 to enable all users to use the EVALUATE function.
-
You can increase the logging level of the Migration Tool to see if you get some more detailed information about this issue - https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=357188409098123&id=2175544.1&_afrWindowMode=0&_adf.ctr…