True, on a vm you need to install the OS, for Windows I guess you can have trial periods for Windows Server installs etc. On the linux side I would suggest Oracle Enterprise Linux. It's free (ok, never read all the license details but I'm kind of sure for personal usage it's free) and all the Oracle tools works fine on it.…

Sadly the UI is a bit inconsistent .... For a chart you must hide the column in the "Criteria" tab (so it will be hidden for all the views), "Column properties" > "Column Format" > "Hide" (a checkbox on the top-right).

Hi, Ideally you set the "sort order column" attribute in the RPD for the "Month Only + Year" logical column (in the business model) as it allows your to sort textual months in the right way. But sometime this sorting doesn't work well (I saw that mainly in pivot). If you don't want/can't do that (or it doesn't fix your…

I assume your browser know how to resolve LPT-67, right? Then of course what nm.Mani said : did you start OBIEE ? Because if your don't start it no chance to connect, it's not like Excel or things like that were you just open and close it like that ... If you started then you must go back to check your log files. Just a…

You can look into OBIEE SampleApp (OBIEE Samples ) for some examples on how they used it. Like http://slc02ojt.oracle.com:7780/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2F10.%20Lifecycle%20and%20Admin%2F_port… (Prodney / Admin123)

Hi, No need to do anything as it's already there. Just look the table next to it: S_NQ_DB_ACCT, there you find the physical query.

You are welcome Give it a try and if you got what you looked for come back to close the thread (right now still This question is Not Answered. )

The logs will still log things. A scheduled analysis is executed as any other analysis, just not by a "human", the logs will capture the queries based on log levels.

Your node manager is probably not running ... Node manager is the "piece" making the weblogic servers communicate together, so the admin server can talk to the manage server etc. Simplest way: stop OBIEE with the Windows Start shortcut, when done try to start everything again with the shortcut. If you still end up with…

@3388135 : step back from your keyboard! You are having having problems and reading only half of the answers here and clicking around randomly. 1) Did you saw Analytics working on your system? Did you login once at least? As you are using the wrong port number I'm not sure, so why the hell did you went on deploying a RPD…

Hi, First thing first: you look for Analytics in the wrong place: look at your last screenshot, the "bi_server1" is listening to port 9704 (last column on the right), so Analytics will be on localhost:9704/analytics . Your issue now is more that the state of "bi_server1" is unknown, which doesn't mean anything good. So…

Hi, Well, you have to start from the beginning: is weblogic admin server up? is the managed server up? are the components up? Everything is green in Enterprise Manager? What does the logs tell you?

Sorry but ... aren't you looking for a custom style/skin? Because doing that you can customize everything and then you set that custom as the default for the system or you select the style at the dashboard level. The good thing with this approach: customisations will survive patching etc. (as long as you do it the right…

Yes, that's why I started by "I would agree with Christian" But, if after cleaning up the model, making sure there aren't double joins and circular joins etc. the result is still the same ....

Hi, Are you the one who posted on MOSC too? Creating HFM reports in OBIEE 11.1.1.9 I'm just going to do a copy/paste: The process has been documented in detail by Oracle in a PDF for OBIEE 11.1.1.7. For OBIEE 11.1.1.9 you could imagine things were easier as the ADM driver is already there for Hyperion Planning, but…

I would agree with Christian but I'm guessing if I didn't see something similar as well at some point. Because the joins, as you say, still return the same result, from a logical point view they are equivalent. And I guess I saw few cases where OBIEE try to improve the query and so add filters where needed or adapt joins…

If following that approach all the static files must be on the "other server", not just a bunch of custom images, because OBIEE will stop referencing the static files locally and use the remote http:// instead.

Yes and no... You can have them on a different server but to use fmap you will have to mount on the OBIEE server the folder from the other server containing the images to deploy that as analyticsRes (or link it inside the deployed analyticsRes). If you don't do that you will need a way to "server" the images from the other…

RPD is the repository containing all the "logic" (physical sources, business models and what you expose in subject areas). As "Author" you can't access it, it's more a admin role accessing it.

It didn't existed back in in 11.1.1.7 (14? that one is supposed to be a 6 digits bundle patch date). The best option for your version is to add that formula to the RPD directly and use the new column instead.