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.

3363820 wrote:read_image_file('d:\pics\'||:reg_no||'.jpg','jpg','image_name'); [nQSError: 27042] Function read_image_file is not defined by administrator. Maybe you can provide some context on how this thing is supposed to help the OP referencing images using fmap ? Because it's can't at all ...

1503342 wrote:The problem occurs when the mail server is switched to SSL.If I send the mails to a non-SSL server it works ok.Could the problem be the certificate? Bingo ! 98.5% of chances you will find your solution if you look into the SSL config you did (certificate etc.). Things almost never happen just like that

Does the user have access to the OBIEE homepage? If not give him access and ask to test again when at home. The OBIEE homepage privilege is required for few things (act as if I'm not wrong for example) and it's possible that the iPad app also require it. (I guess the user uses the OBIEE app and not the browser as 11.1.1.7…

Did it ever work at some point? OBIEE never managed to send a single email?

Christian already told you why and alternatives. As you are bypassing OBIEE completely you must work without and if you want to have some different style on a cell or another your only option is to return HTML as the cell value and build the HTML as you require. As you can imagine it's even worst than a DDR because not…