UFN_OLAP_GETEXISTINGOLAPATTRIBUTECATEGORIES

CREATE function dbo.[UFN_OLAP_GETEXISTINGOLAPATTRIBUTECATEGORIES]
(
  @OLAPDATASOURCEID uniqueidentifier
)
/*
Returns a table of all attribute categories currently included in the data mart.
*/
returns table
as
  return
  (
    select
      [ODSAC].[ID],
      [ODSAC].[OLAPDATASOURCEID] as [DATASOURCEID],
      [ODSAC].[ATTRIBUTECATEGORYID],
      [AC].[NAME],
      [AC].[DATATYPE],
      [RT].[NAME] as [RECORDTYPE]
    from
      dbo.[OLAPDATASOURCEATTRIBUTECATEGORY] [ODSAC]
        left join dbo.[ATTRIBUTECATEGORY] [AC] on [ODSAC].[ATTRIBUTECATEGORYID] = [AC].[ID]
        left join dbo.[ATTRIBUTERECORDTYPE] [ART] on [AC].[ATTRIBUTERECORDTYPEID] = [ART].[ID]
        left join dbo.[RECORDTYPE] [RT] on [ART].[RECORDTYPEID] = [RT].[ID]
    where
      [ODSAC].[OLAPDATASOURCEID] = @OLAPDATASOURCEID
      and [AC].[ISLISTBUILDERATTRIBUTE] = 0
      );