Gianni Ceresa

Is your OBIEE working? Or is it down? And you maybe want to review and post some extra pieces other than few lines of a log.

in Getting Emergency alerts in Admin server Comment by Gianni Ceresa Jul 4, 2018 7:01AM

You have been slow on this one ... doing the screenshot took you longer than expected (that's why I didn't go into many details as I knew you were doing it)

in OBIEE 12c: System-Wide Default for Column Property -> Settings lost when Catalog is archived and tra Comment by Gianni Ceresa Jul 4, 2018 6:26AM

The system wide defaults are stored in the catalog, but in the /system path, so you would need to move those settings as well and not just the subpart of /shared you look for.

in OBIEE 12c: System-Wide Default for Column Property -> Settings lost when Catalog is archived and tra Comment by Gianni Ceresa Jul 4, 2018 6:07AM

3690885 wrote:Ma demande d'aide concerne la bonne configuration et l'exploitation de la solution OBIEE 12C. J'ai besoin d'un résumé du document technique sur l'administration de l'OBIEE 12C en français si vous avez. Hi, I'm not going to translate that for the community as others suggested they would do it (sorry Christian,…

in How to create Mix market report on OBIEEE 12C Comment by Gianni Ceresa Jul 3, 2018 12:51PM

Did you try Blog : How to Fix ID Errors In Reports After Upgrading From OBIEE 11g to 12c ? Not the same versions but depending on how the upgrade went you maybe have some permissions issues ...

in Panel Div 'idSelections' not found in document. Comment by Gianni Ceresa Jul 2, 2018 10:57AM

Martin van Donselaar wrote:Yes that is correct, I was thinking too complicated :/ Or thinking right when other columns get in the analysis (or the 2 mentioned aren't there). Never ever imagine the OP will do just what he asked for on the thread

in OBIEE count Comment by Gianni Ceresa Jul 2, 2018 5:37AM

"zero values" = no value at all, nothing (not a 0, not a NULL, not a "" ... just nothing) OBIEE will never generate data which doesn't exist, so you better fix that during ETL to add at least an empty/NULL/zero row at that point. Or you need to model things to cover this case with the right logic (or use EVALUATE to send a…

in Populate prior weeks data when have zeros Comment by Gianni Ceresa Jun 27, 2018 11:21AM

Robeen wrote:....as a database administrator what would be my role? Your role? Sit down and enjoy your coffee As a DBA from a BI point of view you don't really have an active role as long as your BI developers know their job. In a more realistic situation you will probably have to help diagnose slow queries and find out if…

in BI questions Comment by Gianni Ceresa Jun 27, 2018 5:56AM

The answer is in what Christian wrote: a DDR doesn't give you almost any of the feature the tool as. It's all about cheating ... By CSS you can force things to try to match the cell size as much as possible, but it's all about cheating and a shitty one as the rest of the HTML is generated by the tool. So do not expect a…

in Back Ground Color for the Table Row Cell - Conditional Format - Direct Database Request (DDR) Comment by Gianni Ceresa Jun 26, 2018 3:07PM

Dimitris Karydis wrote:Yes that's exactly what I am doing. I knew that was the reason (ok, the screenshot was also quite obvious ...) The issue with pivot view is that there are tons of interactions you can do when visualizing it (either the analysis itself or in a page), things like moving columns, sorting, add or remove…

in Change formatting for Hidden Column in Pivot Table Comment by Gianni Ceresa Jun 21, 2018 7:48AM

Hi, I didn't read the full thread but ... aren't you try to cheat and complaining your cheat doesn't work? Do you actually have something else (at least another column) visible there where you have the grey in the "Rows" part of the pivot? Because from your screenshot it looks like you use a pivot but want it to act as a…

in Change formatting for Hidden Column in Pivot Table Comment by Gianni Ceresa Jun 21, 2018 5:35AM

Hi, What you look for is HTML (so not OBIEE or any Oracle tool), and you were quite optimistic with <b><body>.... (<body> is supposed to be unique in a webpage as it represent ... the body of the page). You need just a line of CSS for that, something like: <div style="background-color: #00ff00">green</div>

in Back Ground Color for the Table Row Cell - Conditional Format - Direct Database Request (DDR) Comment by Gianni Ceresa Jun 20, 2018 9:21AM

Hi, Did you try searching the forum, the doc and even just Google? It's one of the most asked questions and the answer is always the same ...

in Export Data To Excel From OBIEE Report Comment by Gianni Ceresa Jun 19, 2018 9:49AM

Hi, And what did you do to fix it? Because right now you are sharing the information that it doesn't work, but you aren't asking anything and neither provide logs or anything else which could drive to some hints. So start by checking the logs, read what the tool and the system generated and find out the root case of the…

in OBIEE 11.1.1.9.0 on Windows 2012 server fails at configuration Comment by Gianni Ceresa Jun 16, 2018 9:00AM

Hi, You are missing a key point in your thread: different as "they are finally correct" or different as in "they aren't correct" ? Did you do some analysis/debug of the case to find out what is different between how 11g and 12c do things? (generated queries etc.) Do you talk about analysis or reports (BI Publisher) ? Did…

in After upgrading from 11g to 12c essbase reports shows data different from 11g. Comment by Gianni Ceresa Jun 15, 2018 4:29AM

Plan B: keep it simple ! Make as many condition analysis as you have values in the prompt ... Basing conditions to display one of many sections on number of rows returned by a single condition analysis and trying to find dimensions having different (but fixed) number of rows is the best way to get in troubles in the next…

in Dummy report for Dashboard section condtional format Comment by Gianni Ceresa Jun 14, 2018 3:38AM

Hi, Did you check the official documentation? It cover those topics. You also find more documents in My Oracle Support website. Search there and you find everything you look for ...

in Doc for LDAP, SSL and SSO after upgrading OBIEE from 10g to 11g Comment by Gianni Ceresa May 11, 2018 10:15AM

The favorites are stored in the catalog, not in a database ("almost" nothing is stored in a database in OBIEE). So you can do it by editing the files on disk (XML) for all the users: _internals/_favorite inside each user personal folder. You probably want to do a backup first ...

in Can OBIEE favorites be changed en masse? Comment by Gianni Ceresa May 10, 2018 11:11AM

It doesn't require an extra license. The tool is "cluster by default" in a way, so you always get the concept of cluster in Weblogic even if single node.

in Does OBIEE install with single node cluster requires separate cluster based license? Comment by Gianni Ceresa May 7, 2018 1:48PM

Hi, Not sure what you exactly expect to get ... First would be good to know if you want to do a report (Publisher) or an analysis (OBIEE Answers). Then keep in mind OBIEE isn't Excel, if you want an Excel behaviour keep using Excel and Smartview also exists for that reason. PS: I thought Oracle employees were required to…

in Report layout – Report line items with Levels have different headers. i.e., One header is Level 1 an Comment by Gianni Ceresa May 7, 2018 4:06AM

Welcome to the Oracle Analytics and AI Community

Gianni Ceresa Mod

Comments