create Date Sets in Data Model using SQL query (select "a function" from dual)

We are now doing the OBIEE 10g upgrade. The bip reports in 10g is working fine. We create the data model with sql query. the data is returned by oracle stored prcedure. we use the statement like "SELECT ASSETMGMTREP_DG_PACK.GET_ASSETMGMT_FUNC(:fundcode,:fromdate,:todate,:reporttype,:reportgroup)FROM DUAL". After upgrade to 11g, it also can run successfully with parameters. for somereason, we want to re-create it, but when i create a new data sets with the sql statement, the obiee is hunging and alert processing for a long time. please refer to the attachment.

any one have this kind of experience and can help me out? thank you.