Viewing 15 posts - 886 through 900 (of 1,354 total)
Try clicking Test Cube Security on the Cell Security tab. I found that necessary even though I wasn't using cell security. It's not at all an intuitive step...
April 23, 2012 at 4:57 am
So that the package doesn't crash when you use any kind of dynamic configuration?
I have not had it crash. Sometimes it can't tell me it can't find a...
March 12, 2012 at 9:00 am
Assuming you have some kind of location dimension, you can create a reference dimension that would do this. I have, for example, a location dimension with region, state, county,...
March 11, 2012 at 8:02 am
The article should have mentioned that this is very useful for external data sources that would otherwise cause the user to have to wait for several minutes while all the...
March 11, 2012 at 7:52 am
The attributes are create automatically. Those are the characteristics you listed.
March 6, 2012 at 8:48 am
No, that is not possible directly. However, it's just a matter of adding attributes from the different dimensions one after the other. This is also a common way...
March 5, 2012 at 2:27 pm
Drill down is the ability to expand the categories in a dimension by clicking on them or a symbol by them to expand a more detailed category. For example,...
March 5, 2012 at 5:15 am
There is no substitute for doing proper data quality checks during the ETL. While there is a provision to convert to unknown member during processing of the cube and even...
February 28, 2012 at 7:11 am
The join is no more "mandatory" than by a standard OLTP design. But that doesn't mean it's not a good idea.
Why did you opt for a snowflake schema? ...
February 27, 2012 at 8:15 am
No need to feel dorky. There are a lot of good DBAs who don't go where you are now.
February 14, 2012 at 6:33 pm
There's a setting on the dimensions that allow the activation of the unknown member. You must be doing something to set it, because it's not automatic. I never...
February 14, 2012 at 6:22 pm
I don't think you're quite there. From what you're saying and what I see in the design, the granularity is the amount due and past due by client by...
February 13, 2012 at 8:57 am
Sorry, but that doesn't answer the question. Granularity refers to what is being measured by a fact table. Does it refer to a single telephone call, a single...
February 13, 2012 at 8:15 am
Your first major question should be: at what level of granularity do you want to report at? Without us understanding that, it's difficult to comment on your design. ...
February 13, 2012 at 7:56 am
First one. Not totaly sure about the snowflake DimCustomer-DimLocation structure... it looks like a plain 1-1 relationship which I usually try to avoid at all costs.
In a sense, it is...
January 17, 2012 at 8:09 am
Viewing 15 posts - 886 through 900 (of 1,354 total)