Gianni Ceresa

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

The certification matrix ... take some time to get into it in detail (it's Oracle ) The "system" sheet in the file is the one giving you the OS details for the "server" on which you want to install the tool. You first need to look at the column "Product Offering" to identify all the values that match your needs. In your…

in (Oracle business intelligence 12.2.1.2) oracle bi failed with exit value 3 Comment by Gianni Ceresa May 7, 2018 3:58AM

3491748 wrote:in this picture I saw windows 7 sevice pack 1. the file I looked into is "fmw-122120-certmatrix-3254735.xlsx" donwloaded from oracle. sheet "client". Look better in the picture you posted yourself ... Column A: do you see OBIEE as one of the products matching Windows 7 ? And you seem to be looking at the…

in (Oracle business intelligence 12.2.1.2) oracle bi failed with exit value 3 Comment by Gianni Ceresa May 2, 2018 3:05AM

My assumption (based on the question) is that the OBI users are stored in the embedded Weblogic LDAP and not in an external corporate LDAP or AD.

in Last login date for Weblogic users in myrealm Comment by Gianni Ceresa May 1, 2018 7:06AM

Adam Wickes wrote:What if they login but don't do anything?Does anything go into Usage Tracking? I would count those as "no longer in use", because just login to see the homepage but not run a single analysis is like not logging in

in Last login date for Weblogic users in myrealm Comment by Gianni Ceresa May 1, 2018 3:44AM

It's perfectly normal ... In the physical layer you simply define the condition connecting the 2 tables, not the inner or left/right/full outer nature of the join. You then set the kind of join in the business model. So forget the physical layer but go in the logical layer where you have the logical join between your fact…

in join type in physical diagram is read only Comment by Gianni Ceresa Apr 27, 2018 3:01PM

MFA for Oracle Community

Welcome to the Oracle Analytics Community

Gianni Ceresa Mod

Comments