There's some info here: https://www.sqlservercentral.com/forums/topic/sp_prepexec-vs-stored-procedures

...and here: https://www.brentozar.com/archive/2018/03/sp_prepare-isnt-good-sp_executesql-performance/

• This reply was modified 3 years, 10 months ago by  PB_BI.

A former colleague of mine, who is much smarter than I am, once opined that people that do what we do should be in some way licensed, especially when working...

Have a look at the DMVs for SSAS. https://bennyaustin.com/2011/03/01/ssas-dmv-queries-cube-metadata/

That should give you all you need.

Thanks Paul. The ASSP is a top 1 answer for this problem. However, I needed to do this with bare SQL. Which I managed.

On a side note, I...

Have you tried the ASSP project? Namely the DiscoverXMLMetaData function: https://asstoredprocedures.github.io/functions/DiscoverXmlMetadata/

Makes all of this easier.

Good post - I have leveraged this for a while (this also works for deployment targets of SSRS/SSAS projects) but I'm always surprised more people don't use it. Nice one...

SSIS Expressions are not T-SQL. Not only are there some things in your code that don't exist in SSIS expressions (CAST, CONVERT), where there are shared function names sometimes the...

Everyone is missing the most important barrier to home working. Tips on overcoming it can be found in this helpful guide: https://www.youtube.com/watch?v=IW3lhfVpLL4

😀

You would have to do some analysis of your data and determine where in the hierarchy, if at all, cost group should go. Bear in mind that users can always...

You have to change the error configuration in the dimension properties to ignore key duplicates: https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/error-configuration-for-cube-partition-and-dimension-processing#bkmk_dupe

This can really mess up your query performance but if it's what the users...

Because you are attempting to put Cost Group in a position in a relationship where it does not belong. The attribute relationships/keys are how SSAS determines what SQL to run...

Work out the cardinality of it vs the cardinality of the other attributes (taking into account composite keys and existing relationships) and then place it in the appropriate place in...

It very much depends on how you have each attribute set up (the key columns and the attribute relationships) but what you have to bear in mind is that when...

You don't mention whether you are using Tabular or Multidimensional - it's different in each case.

If it's multidimensional, based on what you are saying, the pattern would be 1. Process...

You have a few options, depending on how your cube is structured, but the most simple is to create a calculated column/named calculation (either in the underlying view/query or the...