1. SSAS 2008 doesn't support "-" anymore.
"
everal Team Foundation pre-upgrade reports, and specifically the Scenario Details and Unplanned Work reports, show one of the following errors when run on SQL Server 2008:
The set must have a single hierarchy to be used with the complement operator.
The above messages appear because the WHERE clause in the report query is using a minus or complement operator (-) to exclude a specific attribute from the query. For example, the Scenario Details report includes a WHERE clause with the following syntax:
"
More details at:
http://msdn.microsoft.com/en-us/library/ff452590.aspx#REMComplement
Power BI Copilot, AI Instructions And DAX Query Templates
-
At the end of my last post I showed how, if you put the definition of a
measure in the AI Instructions of your Power BI semantic model, Copilot can
use it ...
1 day ago
No comments:
Post a Comment