Joel Greijer

To create a measure (RelatedSales) in a filtered spine/factless table (ManySideTableThatIsFiltered), that relates to another table containing a measurable field (SalesAmount) RelatedSales :=  calculate ( sum ( [SalesAmount] ) ,  values ( ManySideTableThatIsFiltered ) )

Why is does not my live Mist Biml script generate packages, even though i can see the expanded packages in the Preview Expanded Biml script? In my case, the loop creating the packages was based on tables generated from another live script. This "double-hop" live scripting is supported. The key to success is using tiers <#@ template language="C#" tier="1" #> <#@ template language="C#" tier="2" #> <#@ template language="C#" tier="3" #>

Error:: BimlScript expected X properties, but Y were supplied Provide required properties The required attribute on parameter object does not seem to work when using CallBimlScript example:  <#@ property name="parameterValue" type="System.String" required="False" #> Workaround: Specify empty/null parameter in CallBimlScript then use string.IsNullOrEmpty(parameterValue) in your callee script. Error When building biml script i get " Error:Node: Varigence.Biml.SsisEmitter.Model.Dataflow.Input:   Expression  contains syntax errors"  No error lines or task names are shown. Cause  / Solution This message actually means that one of your tasks have an empty ssis expression (Note the double space between "Expression  contains". Examples could be columns inside a . Check recent added tasks for missing expressions. Error Cannot build biml file in mist that has an ssis expression containing double ampersands "...

This process is tested with a tabular model on ssas 2014 and that you have the appropriate licences to use the software. First, ensure SSAS Deployment Wizard works on your local machine by installing appropriate prerequisits ssms and stuff (not listed here). Add deployment wizard to repo Microsoft.AnalysisServices.Deployment.exe Microsoft.AnalysisServices.Deployment.exe.config Microsoft.AnalysisServices.DeploymentEngine.dll  (exists in GAC only) Microsoft.AnalysisServices.DLL Microsoft.DataWarehouse.DLL Microsoft.DataWarehouse.Interfaces.DLL Microsoft.SqlServer.ConnectionInfo.dll Microsoft.SqlServer.Dmf.dll Microsoft.SqlServer.Management.Sdk.Sfc.dll Microsoft.SqlServer.Smo.dll Microsoft.SqlServer.SmoExtended.dll Microsoft.SqlServer.SqlEnum.dll Microsoft.SqlServer.SqlWmiManagement.dll Microsoft.SqlServer.WizardFramework.dll   (exists in GAC only) Possible locations for these are C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies C:\Program Files...

Problem : I accidentially pressed ctrl+alt+right key and my display rotation shifted 90 degrees. When I open Intel HD Graphics Control Panel (that caused this mess) to clear it, it says that it's in 0 degrees rotation mode, so I cannot change back. Pressing ctrl+alt+up key does not work either. Solution : Press start button or windows key, type display and enter windows own display settings. From here you can set your display back to landscape mode. Don't forget to disable hotkeys in Intel HD Graphics Control Panel.