I have an OLAP universe built on a BW query, which in turn is built on DSO. It returns around 100k records. If 20 objects are included in the webi query, the webi processing server will be down, with status of "starting..." (checked in CMC).
However, if I build a universe on the active table of DSO directly, the webi query executes perfectly even with 180 objects included.
I understand the performance difference between this two approach and it's acceptable. But the behavior of webi processing server is not acceptable. Does anybody else have this issue too?
My env is BOE XI 3.1 SP2