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

These are security patches, so technically speaking you don't need them, the tool will keep working as it does now. You will just have potential, and not potential but real, security issues in your weblogic (all the details of what issues the patches fixes are written there inside).

In addition to what Joel said, this patch isn't directly linked to OBIEE. It's a weblogic patch, OBIEE is deployed on top of Weblogic, but this patch isn't related to OBIEE itself. Therefore the answer is, as Joel said, strictly linked to the version of weblogic you have.

A filter can't use a presentation variable and be "is prompted" in the same time. You need to be coherent in your approach: it's either prompted and it will use the same date for all the analysis, or it uses the presentation variable. You must change your filters.

Sorry but everything works as designed. What you were hoping to happen is just impossible ... Your only chance would be to try what Jerry posted, if the analysis you use as filter works on a different variable you have a chance the context will be preserved once you navigate away from the page. Otherwise it's normal that…

Hi, how do permissions look like on the objects you have in your dashboard page? Also worth looking at all the levels above to verify the user can "get" till the required sub-folder.

aPsikus wrote:Providing easy to implement solution Aka: how to spend $$$$ for nothing! Why to buy an analytical platform if you don't want to use it? That kind of solution is like buying a desktop PC and sit on it instead of using it for doing some analysis on your data. But fine ... easier to make a totally wrong model…

Hi, Out of the box you have 2 separate pieces: in the RPD you can generate a CSV file with a big part of data lineage inside from the admintool. For the catalog you need to use the catalog manager and generate reports from there. Some content is missing, it's up to you to "link" things together between these 2 elements.…