search

TabularEditor / TabularEditor3

Bug reports, feature requests, discussion and documentation for Tabular Editor 3 (commercial version).
65 stars 7 forks source link

Vertipaq Analyzer error on SSAS 2022, Compatibility 1600 regarding FormatStringDefinitionID #909

Open zenzeinet opened 1 year ago

zenzeinet commented 1 year ago

Hi,

With TE3.7.0 , Vertipaq Analyzer seems broken for SSAS2022 compat 1600. The error message from TE3 is "Could not find the column specified in the context of line 3, column 5".

Running a trace on SSAS it seems TE3 VA runs the following, which returns an error: As far as I remember, previous versions worked ok.

Query Text:

SELECT [FormatStringDefinitionID] AS FORMAT_ID, [Name] AS MEASURE_NAME FROM $SYSTEM.TMSCHEMA_MEASURES WHERE [FormatStringDefinitionID] > 0

Thanks

otykier commented 1 year ago

@albertospelta @marcosqlbi are we missing some kind of CL check in VertiPaq Analyzer?

albertospelta commented 1 year ago

@otykier this is probably a bug that has been fixed in this PR https://github.com/sql-bi/VertiPaq-Analyzer/pull/56, released in version 1.2.14.

albertospelta commented 1 year ago

@otykier from what Darren wrote in the PR comment: "it appears that the Dynamic Formatting column in TMSCHEMA MEASURES is not available UNLESS your model has at least one dynamic format string"

otykier commented 1 year ago

Thanks @albertospelta - I'll make sure to use the latest version of VertiPaq Analyzer in our next TE3 update.

otykier commented 6 months ago

As we've upgraded to VertiPaq Analyzer 1.5.1 in our latest release of Tabular Editor 3, I believe this issue should now be fixed. It would be helpful if you could verify this, @zenzeinet - thanks!