Gianni Ceresa

As extension to what Christian said, there is also another factor to keep in mind: you select values from a prompt and you want to set a variable with one of those values. Variables are set by prompts, so the variable will old all the selected values. It sounds like a XY Problem (http://xyproblem.info/ ), so express the…

in How to get max date from varchar date prompt Comment by Gianni Ceresa Jul 5, 2019 9:48AM

Hi, First of all this kind of count isn't something you are supposed to code, but something you model in the RPD and it will work for all your months all the time without any complex formula in the front end. NicoLavio wrote:I have the following subject areas:About issues:“Issue_ID”“Issue Open Date”“Issue Completed…

in SQL Formula to count the # of uncompleted issues at the end of each month. Comment by Gianni Ceresa Jul 5, 2019 6:55AM

Hi, Try to have a look into the XMLP_* tables and there are also the QRTZ_* tables which are related to BI Publisher. All those are into the BIPLATFORM schema created by the RCU. Doc ID 1618405.1 has a list of tables related to Publisher.

in What are the tables that host Report Job Error History? Comment by Gianni Ceresa Jul 4, 2019 3:48AM

Is there somebody able to login into OBIEE? (Users from a LDAP or AD?) Or you are totally locked outside OBIEE and only access to Weblogic parts works?

in Unable to login to BI Analytics using weblogic user. Able to login to EM and Console using weblogic Comment by Gianni Ceresa Jul 3, 2019 4:57PM

Hi, This thread is challenging: you have the solution in a MOS document but you can't access it. Must be noted that it's forbidden to post MOS content here, so people with access to the document will not be allowed to post the solution here. By extension I would also say that people not knowing the answer before to open…

in BIP report fails With Error 'XMLPGEN-03111 : user requested cancel operation' Comment by Gianni Ceresa Jul 3, 2019 8:19AM

Create an agent, add somebody inside and run it once. Done!

in Hi, I have configured the SMTP mail server for OBIEE 12 C. How do i test it now? Comment by Gianni Ceresa Jul 3, 2019 7:44AM

Keeping it short, no idea what your example looks like as there isn't one posted. There is not such a thing out of the box. Your option is to look into custom code to try to handle that.

in Session Time-Out Pop Up Comment by Gianni Ceresa Jul 3, 2019 4:35AM

00003f95-ed9e-4641-9a1d-afd151d6f9df wrote:I am urgently looking ... So the best option is to hire a consulting company, they will be paid to answer you as fast as you urgently ask them. PS: did you try searching? The same topic has been asked already 2-3 times ...

in Session Time-Out Pop Up Comment by Gianni Ceresa Jul 2, 2019 1:28PM

I would say the maximum you can have there is using a variable. So use that. "Status Table"."Status Cd" doesn't exists there, it only exists in the criteria of the analysis.

in OBIEE Print & Export Options Comment by Gianni Ceresa Jul 2, 2019 9:17AM

But you didn't say, so far, that the MOS document solution doesn't work. The document clearly says that the variable affect analysis, you reported above that the errors remain the same in the RPD. The MOS document never stated it would do anything for the errors in the RPD. Are you now affirming that even with the variable…

in OBIEE 12c: "A comparison is being carried out between non-compatible types" error (Doc ID 2290231.1) Comment by Gianni Ceresa Jul 2, 2019 6:33AM

This doesn't mean the session variable isn't set. You are changing your question... At the beginning you wanted to know how to set the variable, now you are saying that the MOS document didn't change anything in your case. You maybe misread the document: it is stated that the variable, either local in an analysis or as…

in OBIEE 12c: "A comparison is being carried out between non-compatible types" error (Doc ID 2290231.1) Comment by Gianni Ceresa Jul 2, 2019 6:10AM

What is not working? What did you do?

in OBIEE 12c: "A comparison is being carried out between non-compatible types" error (Doc ID 2290231.1) Comment by Gianni Ceresa Jul 2, 2019 5:02AM

Hi, That's just a pivot. In your analysis select your "employee name", "department", "no of days", "worked days" and "leave" columns and in the result tag use a pivot view and done. ef767cc8-0e54-4c89-9a86-3428c27bbae8 wrote:Currently RPD file is very simple with one table in all layers (Physical, Business, Presentation…

in How to make Report With Column in Column (Dynamic Columns report) using OBIEE? sample data & report Comment by Gianni Ceresa Jul 2, 2019 3:40AM

You aren't helping in helping you Give up pseudo code, post the exact full formulas involved in your calculation (f1 and f2 and every other column referenced by those), post all the datatypes as defined by the admintool for all the presentation columns involved in these formulas. (Column names are not confidential, we…

in Binary Logical operation is not permitted on INTEGER, LONG VARCHAR operand(s) Comment by Gianni Ceresa Jul 1, 2019 1:02PM

Doesn't show those filters if you add the filters view? PS: You have a question but you unmarked (or didn't create) as being a question, this doesn't help others as it doesn't allow to mark useful posts or correct posts.

in Is it possible to display the selected criteria in inline prompts in OBIEE 11g Comment by Gianni Ceresa Jul 1, 2019 11:43AM

Hi, you are talking about a BI Publisher report? Or an Answers analysis? What exact version? As you checked them, what are the datatypes? How did you check them? How is the exact formula of your column? You need to be more precise and post more details as otherwise there are 10'223 possible guesses.

in Binary Logical operation is not permitted on INTEGER, LONG VARCHAR operand(s) Comment by Gianni Ceresa Jul 1, 2019 11:25AM

3334354 wrote:Can somebody help what would be the query/sql for Init block (as mentioned in #1) for the session variable =0 ? SELECT 0 FROM dual; This will be more than enough to get the 0.

in OBIEE 12c: "A comparison is being carried out between non-compatible types" error (Doc ID 2290231.1) Comment by Gianni Ceresa Jul 1, 2019 11:09AM

Hi, Please delete the "solution" part which is a copy/paste from the MOS document. This is a public forum and MOS content is restricted to users with a valid support contract, therefore it's against the rules of the forum to post content of MOS documents in the public forum. If you want to post MOS documents content you…

in OBIEE 12c: "A comparison is being carried out between non-compatible types" error (Doc ID 2290231.1) Comment by Gianni Ceresa Jul 1, 2019 11:07AM

Last detail (explaining why the video works): the guy there is installing OBIEE 11.1.1.7 on a Windows 7 SP1. Guess what? That OS is supported for that version of OBIEE and Oracle certify it's will work. Therefore if you wanted to install that OBIEE on that same version of Windows you could have done what the video did or…

in Error while installing OBIEE 11g Comment by Gianni Ceresa Jun 30, 2019 8:56AM

Nishithaa wrote:Joel,I'm following the steps mentioned in this blog to install OBIEEhttps://www.youtube.com/watch?v=5UBwb81tpag And? That's not an Oracle resource. The official certification matrix clearly says that Windows 10 is not a supported OS for OBIEE 11.1.1.9. Windows 7 and 8.1 are, Windows 10 isn't. Windows 10 has…

in Error while installing OBIEE 11g Comment by Gianni Ceresa Jun 29, 2019 12:20PM

Welcome to the Oracle Analytics and AI Community

Gianni Ceresa Mod

Comments