Hi Keerathina;

  I would agree with David in that the probable reason is because the SP is returning a NULL result set. However, I would also suggest dropping the expressions & replacing these with Display Format masks. In a DF,  you can set the mask to account for a "Null" & let the App user know that's what the DBMS is returning.

FYI ...  string-format ; null-format

  That way, you can show the App user that the actual value is a "null" (or say "nothing") vs displaying a blank value which is not intuitive. Just my $0.02.

Regards ... Chris 

Hi

I'm sorry but I do not have a lot of help to offer..

Based upon what you have described and the computed field expression I would say that all the column values are Null. You can prove this by adding the columns themselves to the DW.Does the procedure work directly, can you create another DW using the procedure and does that work?

I'm not sure how it can fix itself after sometime unless the data has changed, is there any Font/Background colour expressions that are affecting the text colour?

Just some ideas to look at.

Hope it helps

David