OBI Server Hangs in Stopping status

Sometimes, when restarting OBIEE Server, the Service hangs.
The Windows service hangs in the "Stopping" State.
Sicne the Stop time is unpredictable one way to kill a windows service is to use the taskkill command from Command prompt.
Below is a screen shot of an attemp made to kill the task/windows service associated with NQSServer.exe

It worked like a charm.

-A

Default Values for Null Data

We came accross this requirement to replace Null Data with a specific value.
For Eg: The report contains a column Rating. The requirement is that if the rating is null, it should be displayed as "Not Rated".
Ideally, this should be taken care of by the source system itself.
However, if this is not possible or will take too long. The logic can be put into the report itself.

Options:
1. In the report, you can introduce an Expression in the Rating column as:

IFNULL("DW.Rating",'NOT RATED')

2. You can also use a case statement for multiple options.

Rating:
CASE
WHEN "DW.Status" = 'DANGER' AND "DW.Rating" IS NULL
THEN 'HIGH RISK'
ELSE
CASE
WHEN "DW.Rating" IS NULL
THEN 'NOT RATED'
ELSE "DW.Rating"
END
END

3. Similar statements can also be introduced at the Business Model and Mapping Layer.