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…

https://docs.oracle.com/cd/E10415_01/doc/bi.1013/e10417.pdf Just keep in mind OBIEE 10g is very very very ... very old ! Therefore you can't expect it to work perfectly on new browsers, the certifications covers minimal versions and the "+" generally means up to the existing version when writing/publishing them. From a…

What about asking the SMTP server admins to look at what they see on their side?

Hi, I assume you have an analysis (a report is a BI Publisher report). A narrative view in an analysis is a fairly basic view which doesn't support any logic by itself as it's supposed to only have "text" inside. Do you 'just' need to change a title or something like that in your narrative or "Previous day", "Week to date"…

Hi, Move it, that list is generated from a list of dashboard being in default locations, if you move it away in another place in the catalog it isn't in the list anymore.

As already said be Joel above, your price will be different of what you see on the list price. In more than 10 years I never meet anyone who paid the list price for OBIEE/OBIA. And it isn't really a "yearly license" : these products generally come with an initial price to buy the licenses you need, then you pay support on…

It looks like they don't update the version in the front-end all the time based on the bundle patch you apply. With 12c there are many patches which just never change the number there and generating tons of questions if the patch is applied or not. The official answer is what Joel said: opatch is the way to know which…

I have the impression "Standard Edition" isn't a thing anymore ... This was the one existing: https://www.oracle.com/technetwork/middleware/bi-foundation/standard-edition-one-095406.html It really comes with products which don't exist anymore (in an actively supported way), therefore I would assume the product doesn't…