How to identify the SQL server objects that a SSAS cube is dependent on? -
i have several ssas cubes processed daily. done ssis project scheduled run daily @ set time. have etl issues , processing job chugs ahead without knowing underlying tables incomplete. depending on nature of etl error, processing completes successfully, stale data; ssas error.
i want optimize processing jobs check/wait until objects given cube dependent on done extracting before sending process command cube.
ssas 2016, sql server 2014. cubes using query binding in data source view, , extracting metadata xmla script generated during deployment.
a potential solution thought of parse out query information in xmla's data source view node. complicate deployment/metadata extraction process quite bit, worth if there no other way. have searched through discover_schema_rowsets dmv, , not find dmv return these dsv queries, although not familiar dmvs, may have missed one.
it should noted lazy , not want duplicate development work maintaining index of dependencies separate ssas projects. solution needs programmatically pull data, , not rely on me keeping updated because unreliable human.
how ensure cube processing starts after dependent objects extracted? programmatically identify sql objects ssas 2016 cube dependent on? if so, how do it, , pros , cons approach?
Comments
Post a Comment