Viewing 15 posts - 1 through 15 (of 574 total)
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...
May 14, 2020 at 11:29 am
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
March 16, 2020 at 12:17 pm
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...
January 31, 2020 at 12:59 pm
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...
January 31, 2020 at 12:20 pm
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...
January 31, 2020 at 11:35 am
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...
January 31, 2020 at 9:04 am
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...
January 31, 2020 at 8:45 am
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...
January 31, 2020 at 7:59 am
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...
January 31, 2020 at 7:42 am
It's because your "Account Level 0" attribute is finding a duplicate composite of the dimension key (e.g 88 and 99 are both P&L). You need to make the KeyColumns property...
January 31, 2020 at 7:31 am
You need to use a global temporary table rather than a local one. So ##temptable instead of #temptable
January 24, 2020 at 1:21 pm
You need the GENERATE function if you want to show the top ten products by customer. You have taken this out which is why your results are "garbage".
For the "0"...
July 11, 2019 at 10:05 am
Looks like a typo to me. According to the text of the book it should show the last 5 years so the calculation should be:
Note, negative 6.
July 11, 2019 at 6:35 am
The simplest way to do a "top 10 by customer" type thing is to use Generate to iterate over each one and perform the TopCount. The below uses this method...
July 10, 2019 at 11:36 am
You must work in Toyland.
You must work in Toyland.
Where others use variations of "foobar" for things they can't think of a name for, I use variations of "noddy". You're not the first who's...
July 5, 2019 at 1:20 pm