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

To extended Christian's reply: a logical model is a start schema. A fact table is only supposed to contains measures while everything not being a measure goes into a dimension. Logical dimensions *can* have a dimensional hierarchy. If you don't do it you are missing a lot of what OBIEE can do, that's why it's easier to…

Are you on your own OBIEE 12c on-premises or is that a cloud thing (managed by Oracle)? If the latter, it's easy to see where the change came from: too many things running too often and they wanted to reduce the load from agents I imagine.

So it sounds like the first thing you have to do is to clarify what your need is 3184221 wrote:Users want to click on Project no and it should open a another URL which has project ID for Forecast but they don't Project version and Project ID in the report.Eg :- www.google.com/PJJ_ID=12 Is the page you want to open, as your…

It obviously influences the granularity of the analysis. But you can't expect to have a value of a column without the column, and to have the column without the granularity being impacted by it.

There isn't a MS Project native connector in OBIEE. If MS Project has an ODBC driver, setup the connection (depends on the OS your OBIEE is installed on) and inside the RPD you will be able to use that connection. Of course OBIEE expect that ODBC driver to speak a standard query language, so as long as the driver can reply…

Did you try keeping the "Project ID" column in the view of your analysis but as hidden column? As it's still there and part of the view it maybe has a chance to work. If you exclude it, it doesn't exist in the view, therefore your action can't reference something not present.

Ok, so the wording was a bit confusing and made us think you were doing something different. If you want to keep control on what you analysis does when it's inserted in a dashboard, you need to control the possible behaviour of filters. It's clear that a filter set as "is prompted" will take the values of the prompts, but…

user4109719 wrote:...supposed to detect the grain from the field being used ... Every time you let the system do something supposing it works as designed, be ready for surprises (been there, done that, concluded it's good to suppose but it's safer to be sure ). The grain of the analysis is generally identified based on the…

Let's take a step back: Are you talking about OBIEE Answers objects? Analysis, dashboard prompts and dashboards? Or are you talking about BI Publisher reports?

In an analysis (not report, analysis) a filter if it isn't protected will be replaced by the values selected in a dashboard prompt if any. Therefore your analysis is probably running with a very different filter. Add the "filter" view in the analysis and you will have a hint, look at the generated query and you will be…

3923818 wrote:Hi,Thank you for the reply. Please help me to understand better with your question as the default value for this setting is NO. https://docs.oracle.com/middleware/11119/biee/BIESG/configfileref.htm#i1076541 Oracle seem to disagree with you ... A.6.2 PROJECT_INACCESSIBLE_COLUMN_AS_NULL Controls how…

What exact version of the tool are you talking about? An official doc says this: The default value is YES

3923818 wrote:I have changed the setting 'PROJECT_INACCESSIBLE_COLUMN_AS_NULL as YES' Why was it at "NO" before? Because 'Yes' is the default value... And would be good if you could post some more info, right now you don't give much. (More efforts put into writing a thread result in better answers)