dev

With UD Connect you can now integrate the data for the source object into SAP BW. You can either extract the data, load it into SAP BW and physically store it there, or, as long as the prerequisites for this are fulfilled, you can read the data directly in the source using a [...]

The last method (workaround) to solve a lock status is by killing the process. Write this line to Kill a process in sql server:

1
2
3
4
–This example shows how to terminate SPID 55.
KILL 55
–This example generates a status of the rollback process for the specific spid.
KILL 55 WITH STATUSONLY

–This is the progress report.
spid 55: Transaction rollback in [...]

IIf function often used in MultiDimensionalExpression (MDX), It’s quiet simple to implement single block of IIf block.
This an example of Multiple IIf logic block.
Example1:

1
2
3
4
IIf(Measures.[Store Sales] > 50000, "Good",
IIf(Measures.[Store Sales] > 30000, "Average",
IIf(Measures.[Store Sales] > 10000, "Poor",
"No")))