Hooray!! That's good news nevertheless although always frustrating when something just "fixes itself". I'm assuming you upgraded both nodes and restartd both server? I have noticed issues in the past with .lok files not letting themselves go and causing all sorts of problems. PS I am interested to know how you go with 4. I…

The dashboard pages (ie tabs) themselves are individual objects within the dashboard itself (expand dashboard and you will see them). Therefore, can't you just limit each dashboard page to a specific user/group/application role We have a similar setup in a few of our dashboards where we have a power user tab that we only…

Single node or cluster Ebin? Can you access admin server? When you start manually using start.cmd, does everything come back as "running"?

Something similar to the following will also work (where p_test = the name of your variable). SUBSTRING('@{p_test}{01/01/1900}' FROM LOCATE(',', '@{p_test}{01/01/1900}')+1 FOR LENGTH('@{p_test}{01/01/1900}')-LOCATE(',', '@{p_test}{01/01/1900}')) Martin's method is by far the cleanest though.

Thanks Gianni. @Ebin Cherian, the options there seem fairly bland. Certainly not missing anything having already customised that's for sure.

guys, is this the old method of customisation? https://www.rittmanmead.com/blog/2010/12/oracle-bi-ee-11g-styles-skins-custom-xml-messages/ If so, what is the new way? EDIT: I expect this will be Gianni's response (haha) which means we currently use the old method. Is it critical that we move to use the new way or can we…

So just on the theme management. We have extended the alta theme and use a deployment to house our own styling. Will this be impacted or have we done it the right way? I'm glad this version is focussed on bug fix rather than introducing more features. DV integration is important to us so i'm leaning towards upgrading…

48a4e11a-ed4e-48a0-88ec-f44e5180aaef wrote:When creating a large report I find that it runs a lot smoother if you hide the report output by clicking on "Display Results" Icon within the view editor screen (Third from the Right) If he's having issues building the report, how do you think his users are going to go viewing…

In addition to my previous post, we found that if our connection pools connected using service names, login time would be approximately 30-60 seconds. If we used SID (unique db name) instead, login time would be instant. I worked with one of our DBAs for a few days on this to try and work out "why" but couldn't find an…

We had a similar issue in our setup (12.3) where our init blocks were using connection pools that were connected to Oracle databases using the wrong method. I'll find out more details (evading me at the moment) and get back to you in around 10 hours. It altered login time from 40 seconds to instantaneous. To check if this…

Another option could be to change the colour of the font to match it's background? A second option and maybe Christian or Gianni can confirm if would work, but if you place the analysis on a dashboard and assign a custom css class to the section that it sits in, can you place overrides in common.css to hide that text?…

For anybody who wants to remove the "go to new home page" link, this is what we used. Good write up. OBIEE 12c: Remove the ‘New Home Page’ link - Red Stack Tech

Yep... BIP is the winner here. Simple to use.

Ok, i've worked this one out and it's more to do with my own stupidity that this didn't work in the first place. Firstly, to your point Michael, I discovered that the app connects to the share using the user/pass of the user who starts the app and not who the share is mapped as. In fact, you can disconnect the share…

Aha.... I may have mapped using the domain account. If I map using the local account, then the connection shouldn't drop when the domain account is logged out. Thanks for the light bulb moment Michael! Will let you know how I go.

Domain account has full control. System account has full control. Local account has no control. I originally asked our server team for this access to be granted but wouldn't (against policy) and advised to install with domain account as it was "a replica" of the local account. Should have gone with my gut instincts. This…

I was afraid you'd say that. I've raised a ticket with Oracle. I'm concerned about why the app dies when the user logs off. Does that sound right to you? Best case scenario, we can keep the domain account as the app starter. Worst case, we reinstall. Thanks Christian.

Ok guys. I've stopped the services using stop.cmd and started the app using task scheduler which has executed start.cmd as NTAUTHORITY/SYSTEM. All services have come up except OBIPS. sawlog is as follows: [2018-04-17T13:12:31+10:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] [SI-Name: ] [IDD-Name: ]…

I'll check in the morning (AEST for me) and let you know. I'm almost positive it's a permissions issue because when starting as the local account, all but 3 processes start. Using the domain account, all processes start and using NTAUTHORITY/SYSTEM, all but 1 process starts. It would make sense to me that if these 3…

12.3 at the moment. I can confirm that both windows services and task scheduler work fine but only with our domain user (which was the installation user). Unfortunately, this user can be logged off the server from time to time which causes OBI to stop. What I have tried is running the task scheduler as the local account or…