I tried to post this on Stack Overflow, but it's against their guidelines. So since we want to use it with Sparx EA, I thought I'd try here.
We have used a third-party SQL parser (GuduSoft GSP) to parse SQL code into a DOM which we then analyse to create models in our metadata repository (similar to various data lineage tools - this procedure reads from that view, writes to this table, uses that function etc.)
Are there equivalent tools for DAX (and MDX)? I have seen posts about using RegExs for getting some information out, but they acknowledge that it's not as enlightening as a proper DOM analysis. I tried a quick search of the Net, but I must have been using the wrong terms since nothing really showed up.
TIA,
Paolo
