Viewing 15 posts - 361 through 375 (of 893 total)
You will need a calculated measure to perform the distinct count over that attribute, because what you are trying to do is count at a level different from the grain...
November 5, 2015 at 12:45 pm
Hi, here's my comments on your questions:
1. In my opinion, no. What you have done here is called snow-flaking. You should really have the employee key in the fact...
November 5, 2015 at 7:42 am
An SCD (Slowly Changing Dimension) is usually applied in the back-end database, and it means that if certain attributes change you will track the new and prior values. There are...
November 5, 2015 at 7:19 am
This typically happens when there is a division error (i.e. division by zero). If my assumption is correct, you're probably seeing this in a calculated measure and there is a...
November 5, 2015 at 7:10 am
There may be some instance-level permission allowing that person to access the instance. Check the SSAS instance properties to make sure.
November 2, 2015 at 2:28 pm
Do you have logging enabled, and is the logging method also using a dynamic connection string?
October 30, 2015 at 9:58 am
Did you try to set all the DelayValidation properties on your connection strings to true?
October 30, 2015 at 9:18 am
The problem here may be related to the pre-validation phase in SSIS. With the "DelayValidation" property set to "False" (which seems to be the case in your package), SSIS will...
October 29, 2015 at 1:48 pm
Considering the fact that your end users would most likely want to see the sub-location numbers in different columns on the same line and totaled for a store, and the...
October 26, 2015 at 9:10 am
YES!!!
I think this calls for a connect item 🙂
October 22, 2015 at 8:31 am
The only other thing I can think of is that you maybe did not have the relationships defined in your DSV when developing the cube.
October 15, 2015 at 1:26 pm
I'd recommend a dimension for the distinct reasons only (which are selected from the dropdown). This will result in a small dimension but give you all the flexibility when you...
October 15, 2015 at 11:29 am
Could it be that you have defined a composite key in that table?
October 15, 2015 at 11:19 am
mm7861 (10/15/2015)
Help 🙂
You're not getting any responses here because the information you have provided are insufficient. Please provide a sample of what your data structure looks like, what relationships you...
October 15, 2015 at 11:17 am
It really depends on what exactly you are trying to do.
If you are looking to track the changes between the relationship of different type-2 dimensions, then a (fact-less) periodic snapshot...
October 15, 2015 at 11:14 am
Viewing 15 posts - 361 through 375 (of 893 total)