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…

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

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.

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 ...

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.

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…

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…

What is not working? What did you do?

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…

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…

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.

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.

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.

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…

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…

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…

Why a union in your analysis instead of a simple analysis getting the 2 years ? A union disable many features of OBIEE, so it's generally the last option ever you try when there is no way to get things without. Are FY2020 and FY2019 in different business models?

What are all the "." columns for? It's to display the current period mark at various levels vertically and not just at 0 ?

Hi, What version of which tool? (you have an "oac" and an "obiee" tag, not really helpful in guessing what exact product you are talking about). What's behind your analysis? What column do you have in what location of the view and what's behind these columns? Helan Kumar wrote:Its a high priority, awaiting inputs at the…

The official doc is always the place where to look for things: https://docs.oracle.com/cd/E28280_01/bi.1111/e22258/create_data_sets.htm#BABHJCBG