UFN_OLAPSMARTFIELD_GETQUERYVIEWOBJECTNAME

            create function UFN_OLAPSMARTFIELD_GETQUERYVIEWOBJECTNAME
            (
                @SMARTFIELDID uniqueidentifier,
                @OLAPDATASOURCEID uniqueidentifier
            )
            returns nvarchar(128)
            as
            begin

                declare @QUERYVIEWOBJECTNAME nvarchar(128);

                select 
                    @QUERYVIEWOBJECTNAME=replace(upper('V_QUERY_' + o.MARTKEY + '_SMARTFIELD' + convert(nvarchar(36),TABLECATALOGID)),'-','')
                from 
                    dbo.SMARTFIELD s
                    inner join dbo.OLAPDATASOURCESMARTFIELD ods on s.ID = ods.SMARTFIELDID
                    inner join dbo.OLAPDATASOURCE o on ods.OLAPDATASOURCEID = o.ID
                where 
                    s.ID = @SMARTFIELDID
                    and
                    o.ID = @OLAPDATASOURCEID

                return @QUERYVIEWOBJECTNAME;

            end