create procedure [dbo].[BcGetDimensionConfiguration]
as
begin
set nocount on

    select
        BranchDimensionBcId = BranchBcDimension.BcId,
        DivisionDimensionBcId = DivisionBcDimension.BcId,
        MoveTypeDimensionBcId = MoveTypeBcDimension.BcId,
        DriverSalesDimensionBcId = DriverSalesBcDimension.BcId,
        ProjectDimensionBcId = ProjectBcDimension.BcId
    from BcDimensionSetup
    inner join BcDimension BranchBcDimension on BcDimensionSetup.BranchBcDimensionFid = BranchBcDimension.BcDimensionId
    inner join BcDimension DivisionBcDimension on BcDimensionSetup.DivisionBcDimensionFid = DivisionBcDimension.BcDimensionId
    inner join BcDimension MoveTypeBcDimension on BcDimensionSetup.MoveTypeBcDimensionFid = MoveTypeBcDimension.BcDimensionId
    inner join BcDimension DriverSalesBcDimension on BcDimensionSetup.DriverSalesBcDimensionFid = DriverSalesBcDimension.BcDimensionId
    inner join BcDimension ProjectBcDimension on BcDimensionSetup.ProjectBcDimensionFid = ProjectBcDimension.BcDimensionId
end
GO
GRANT EXECUTE ON  [dbo].[BcGetDimensionConfiguration] TO [MssExec]
GO