Get all the OBS details in this table: nbi_dim_obs

select PATH, LEVEL0_NAME,LEVEL1_NAME,LEVEL2_NAME,LEVEL3_NAME,LEVEL4_NAME,LEVEL5_NAME,LEVEL6_NAME,LEVEL7_NAME,LEVEL8_NAME,LEVEL9_NAME,LEVEL10_NAME  from nbi_dim_obs where OBS_Type_Name='Financial Department'
order by Level1_Name