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)

Ok, in all your examples you posted the AGO function is used wrongly. The syntax is: AGO(<measure_expression>, <level>, <number of period>) You don't seem to have a <level> anywhere in what you posted so far. If you want AGO to work at the month level, you need to tell the system to do so.

Are you really talking about BI Publisher reports? Or is it analysis (the Answers analysis you put in dashboards) ? You don't really provide much info, so it's all about guessing ... Did you look at the generated query? Most databases have limits on the number of elements in a IN clause, even Oracle is limited to about…

Did you configure your admintool properly? As said it's something happening on the client, therefore settings tnsnames in linux paths doesn't really help as the admintool is a windows-only program. 3984491 wrote:... you cannot import data. Data? Which data? There is no data imported in the admin tool, only metadata…

Well ... even by SQL you can't really bypass a limit set by the presentation service. So the question is more if you have the proper aggregations set in the RPD so that the query would return you a smaller number of results. As alternatives add a prompt and request your users to select something to see a subset of the data…

There are bunch of settings in instanceconfig.xml defining how many rows/columns/cells etc. to display for a query result. It's a OBIPS setting. The doc and various MOS documents cover them, there isn't a magic setting and those who say to set everything to "millions" are those who wants to use OBIEE for datapumping. For…

Hi, What is the exact message you get? What version of OBIEE are you using?

I now feel very sorry for those students By the way: do you maybe have a link or a reference where the credentials and address of this demo instance is posted? I wasn't aware of it and it's good to know there can be OTBI demo instances around when needing to check a thing quickly. My fight with Office is more generic,…