Dears, I work on an Azure AS (ver. 16.0.43.23) on which I have a model made of many tables. One of those tables has no relationships to any other table.
Who designed the product had built several SQL Jobs and each of them is responsible for ETL and processing of a subset of those tables. In this way tables are updated frequently. I cannot change this but I need to process, once in a while, that single table I mentioned above. I noticed that if any other SQL job has issued a process request to the cube then my requests has to wait for all the other to finish. Since it has no relationships whatsoever to any other table, is there a way to force the processing of such table without waiting?
Thx!
Hopefully I have been able to explain the issue I am facing clearly enough.