You got everything already in above answers but just to recap: - rename to the right filenames, it isn't .zip, but .zip.001, .zip.002 etc. (right names isn't an option !) - check the checksum (the names in the checksum file are the exact names your files must have) - if with the right names your standard unarchive utility…

Isn't this the exact same thing as Dashboard prompt - report not generating ?

Check this: https://blogs.oracle.com/proactivesupportepm/obiee-12c-infrastructure-tuning-guide Follow the link to MOS and download the PDF. Point 4.3 is about JavaHost and they talk about Excel exports. But ... do not randomly apply everything because it's written. Always read the PDF first, compare with your use case and…

The export also bring into the equation java memory settings for javahost etc. Ideally you must check the settings in all the components getting into the loop. If you look on MOS there are documents about that and the tuning guide probably also cover that.

Hi Pius, How are the permissions? the 2007+ exports require the user to have access to its own personal folder as it's where temp file will be generated. So depending on security this can be an issue. Other problems can depend on the size of what you try to export: so are you doing a database dump with Excel via OBIEE?

Hi Robert, Yes and no .... Meaning that if it's 11g the legend is inside the flash, so you will not manage to manipulate it. If on the other side it's 12c (or 11.1.1.9 configured for that) and so the charts are HTML5 things yes, you will be able to interact with the legend and hide things. But like always the problem here…

Alternative option can also be to make all numbers absolute, so both your axes start at 0. To see the negative costs you make the bar of a different color when negative (like red). Of course you can also consider to split into 2 charts : if a dual-axis chart is complicated to read because of the dual zéros then keeping it…

With this kind of definition you will ideally need to test a login and executing an analysis. Perfectly doable by script, but of course will require a bit more than just "process up or down". And also be ready to have a possible gap between what you detect as downtime and what users can report as downtime : if one of your…

Hi, As far as I remember there isn't a setting to "align" 0 of both axis. As you said the only way to achieve this would be to "align" scales of both axis with a fixed ratio between MIN and MAX of both axis. In your case if you fix the right axis to be -4.5 MIN and 9 MAX the 0 will be aligned ( 9 / 300K * -150K ).

Hi, I guess you first have to clearly define what you want to monitor: OBIEE can be up and running but queries not going anywhere and logins refused, this can be considered downtime in a way. Or you maybe take the simple approach of "bi server processes" UP = up, one or more down = downtime. Based on this definition of…

Hi, Although I'm not @Christian Berg ... what isn't clear in the answer? In your analysis you do not retrieve details but edit the formula to give you the total directly and that's your performance tile value. PS: "something similar" ... you could at least spend 30 seconds to write your own thread with your own…

Did you read the posted link? It's 7 + 6 steps, sounds like doable ... So did you try it? If yes: what is the issue? If no: what is the issue?

If you think from a modelling point of view you easily see that you don't have anything letting you get that value so far. So an option is what Sherry George posted: if on Oracle database by using EVALUATE you can get that info. But in general your analysis isn't an analysis itself ... You don't have measures and your…

As far as I know there isn't any variable with the LSQL hash. You can of course open a SR and ask your colleagues (as your work for Oracle).

The official documentation is quite good in general: B.9 Migrating 11g WebLogic Users to 12c And never forget that Google is your friend ... The idea of the OTN community forum isn't to have somebody doing your work, but more to give you directions to explore...

Hi, First you clearly need to identify where the users/groups you want to migrate come from. Are you talking about users/groups of the embedded LDAP inside Weblogic? (so the users you create in Weblogic Console?) These ones must be migrated by hand, there are scripts (wlst) able to export and import if you look for it. If…

Keeping it short ... what @Pedro F said Yours is a common case and the "reduction" of the snowflake to a start is done inside the same logical table in the way Pedro said. OBIEE will be smart enough to not make the joins to D and C if only columns of B will be requested by the analysis, so you don't have to worry about it…

The question is ... why? Why do you want 2 instances of OBIEE? You probably (for sure) can have a single one answering the needs of all your users. The resources which will be highly impacted is more RAM: CPU not much as it's used when something need to be done, but lot of RAM will be used. Depending on the number of users…

Thanks for confirming what I was saying with visual examples As said: once selected it is selected and it will not be unselected without manual action (unselect them or reset). In 11g it's the same business, that's how OBIEE worked, works and will probably continue to work (and it makes sense ....).

In extension of what Sherry George said: currently running agents (so doing something at the time you look) and agents are .... fast, so they don't run for hours.