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.

That's what I said: a measure column will be replicated for all the attributes ... And in addition you have the grant total as well. OBIEE isn't supposed to manage that requirement, your user being too lazy to make a "right click > insert row" isn't enough to justify to build a weird pivot. A pivot has some basic rules and…

I guess you forgot/missed to upload screenshot or something (or they disappeared). Arjun_Mehta wrote:Users dont want to take the trouble of adding one row on his part every time.... Please tell that user that he is lazy, and a lazy user using the wrong tool for the wrong need is "dangerous" (yes, I say it and mean it )

You maybe got it wrongly ... "archive" isn't based on any date/time parameter. "archive" works on a path, it archive what is in that path at the time of running the command. You have runcat.cmd installed on your workstation/laptop to see the attributes the runcat.cmd -cmd archive accept. (Catalog Manager being installed…

The requirement sounds a bit "dumb" as in Excel your user just need to go down or right and he has a empty row/column. You can add a column and give it a NULL value and you have a empty thing. Of course it depends totally on how your pivot looks like (because a "measure column" will be repeated for all your attributes and…

Correcting my previous answer ... Sure SampleApp has 2 domains configured against a single install ... But when you start it, 2 weblogic Admin server, 2 weblogic managed servers etc. So double resources used (ram, cpu) even if sharing the same binaries on disk.

By the way, joining the party later ... You apparently can have multiple domains on the same OBIEE install (so same "oracle_home" and multiple configs). Sample App has that with 2 BI instances.