Viewing 15 posts - 1 through 15 (of 533 total)
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...
February 6, 2020 at 2:12 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...
January 31, 2020 at 12:56 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...
January 31, 2020 at 12:17 pm
Yeah, now I got your point. I could see why it is many to one. Unfortunately the users wants the cost group to put it in that particular level. How...
January 31, 2020 at 11:59 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...
January 31, 2020 at 10:20 am
Yeah exactly. I struggling to include cost group in the hierarchy as you rightly said it is many to one account. What could be the solution ? Should I take...
January 31, 2020 at 8:51 am
This issue is happening only when I include cost group column in the hierarchy. I am just wondering, why hierarchy works only if I don't include cost group column ,...
January 31, 2020 at 8:26 am
What are you suggesting by lesser environment?
The story is:
we use visual studio 2019 but ssis packages are made with 2016 settings and we are running the cube on 2016...
January 15, 2020 at 6:08 pm
Hi Thom, I am trying to understand your question . What do you mean by Validation mechanism?
I declared a variable with some default value 'the value is generated by script...
January 8, 2020 at 4:10 pm
I declared a variable to hold the file to pass to send mail task. I had a given a value like 'The value is generated by scrip task' to the...
January 7, 2020 at 3:37 pm
Finally, issue is fixed which was a silly and it's done. 🙂
January 7, 2020 at 11:11 am
The issue that I have right now is that when I try to pass the entire path of the file along with the file name to a variable , and...
January 7, 2020 at 9:17 am
I have tried to achieve this using script task by validating the count of the columns in the sheet. I am validating against a fixed count(using variable from configuration table)....
January 7, 2020 at 8:13 am
Okay, thank you.
December 13, 2019 at 2:12 pm
WITH gaps_and_islands AS( SELECT *,...
February 22, 2019 at 2:47 am