Sorry but ... what are you talking about? The more efforts you invest into writing a detailed thread with as much information as possible, the more chances to get a proper answer you have ... (this also apply to your other thread on hadoop which become SAP Hana). Maybe also worth looking at as you don't have a single one…

"BBB"."Pattern" = "BBB"."Pattern" : what do you expect to get from this one? You are setting a condition like 1=1 ForSly wrote:what did you mean by this (string are written with ', not " .) 'whatever' => this is a text value "whatever" => this is a reference to an object named whatever For example: CASE WHEN…

Use the "selectors" on screen to reference columns. In OBIEE a column is always referenced as <presentation table>.<presentation column>, therefore your current syntax can't match anything. And also: string are written with ', not " . "Family Name" would be a column named Family Name.

The concept of weekends and public holidays is extremely subjective: for some weekend means Satuday-Sunday, for others Friday-Saturday. Public holiday is even worse as in a single country they could be different by region etc. Therefore this meaning is 100% a metadata which needs to be part of your dimensions. To be more…

It sounds like you tried to "fix" it before to find out where time was spent. If it takes 10 minutes you must be able to map out exactly which step took how long, as that is what will drive your "fix" approach. Push logs and do a time profile for that analysis. This will help you in finding where time is spent, and for…

You mean the Oracle SQL "partition by" clause used with analytical functions? Nope, the BI Server speaks LSQL, not Oracle SQL. You aren't writing a physical query which will be evaluated by the database but a piece of query which is sent to the BI server. If you want to send code to the database you need to use evaluate…

Sure ... kind of .... Save it somewhere, read-only access from devs, name it "whatever-name-you-want-template". Devs are going to copy/paste it to have the template instead of an empty new dashboard. That's what you can do.

Hi, Not sure what you use the TIMESTAMPADD... thing for, AGO doesn't require a date, it works based on the time of the "row". AGO doesn't do any blackmagic, it's purely a SQL way to get data from the previous period based. It uses your data and model to get results. If you model is wrong (or at least not fully correct) AGO…

BASSAM CHEHABEDDINE wrote:...the graph axis is appearing and that means i dont have flash play issue. Did you set your 12c to use Flash? Because by default 12c doesn't use flash anymore ...

You don't say what version of the tool you are asking for, which gives you 50% chances replies aren't valid for your case. You asked how to migrate 11g to 12c, therefore you better say what (exact) version of OBIEE you ask things for...

Hi @3868573, Did you give up with the upgrade? Or the doc wasn't what you looked for? If you got what you look for, could you please close the thread?

There are various answers to that kind of question. Out of the box you can cover part of the needs by using Catalog Manager reports to find out which analysis (they aren't reports but analysis, a report is a BI Publisher report) reference directly which presentation column. In the Admintool you can generate a CSV file with…

I guess you have to take a step back and describe the whole case like if you were describing it to somebody not knowing at all what OBIEE is. You assume we all see your screen in the thread at the moment, which obviously isn't the case, so you really need to turn all that "implicit expected knowledge of your issue" into…

I guess the prompt simply use the default format masks defined by the language of your session. So you have a language which has the mm/dd/yyyy as the default date format.

You mean (totally) delete the agent or disabling it? If the first, try disabling it first and delete using Catalog Manager. Can't say if that a generic issue or related to that given agent having an issue in the XML.

Quite sure that nowhere it's said that 11g and 12c needs to be up at the same time. So nothing prevent you from using the same ports if that's your wish. Here it's where a proxy in front OBIEE is handy: it allows a nicer URL (without ports), to manage multiple backends on different ports, to easily set maintenance windows…

Just look in the official documentation, everything is written there ... http://www.oracle.com/pls/topic/lookup?ctx=bi122140&id=OBIUP-GUID-D0867450-1AEF-43DE-8144-7816F7105CB1

You can't. Agents are part of the catalog, therefore they will be there if you have the catalog in your BAR and you deploy it. All the agents will always be deployed disabled, that's how it works. https://gianniceresa.com/2017/03/scripts-to-use-agents-in-obiee-12c-mass-enabling-and-execution-from-a-page/ PS: it's a…

Hi, Honestly I believe the hierarchy is acting fairly right in counting the manager himself in the headcount of the level, at least from a logic point of view. Does the total at each level really include the parent or just include the level itself? Sure you could have a "dirty" approach of adding by default a " -1 " after…

As Joel said, I never heard anything related to that. The authentication logic doesn't really check existing sessions as the concept of "session" itself could be quite relative and not so easy to define. Therefore it doesn't prevent to use the same login if somebody else with that login is connected. As a workaround to…