In my opinion, you could still be running out of disk space. Remember that when a cube us processed, a new copy is created and processed while queries are still...

RRIOS42 (4/18/2016)

---

I am dealing with similar issue, working with a Patient/Diagnose cube, need to be able to slice and dice # of patients based on diagnosis on selected dates, using...

ffitzpatrick47 (4/13/2016)

---

I think you got it. I need to relate a dimension to a fact table by replacing a foreign key with a corresponding surrogate key scd2. You mentioned a...

The error message is pretty self-explanatory in this case: The impersonation mode you have selected for your data source is not supported. You have to use windows authentication, and can...

Your question isn't very clear...surrogate keys are table attributes (automatically assigned nonsensical numbers that uniquely identify rows), while foreign keys are table constraints. These are 2 very different concepts.

Assuming that...

From a logical point of view, it also makes sense to me that it is stored on the new row...and that's typically the way I do it.

One potential drawback of...

From your description it sounds like the weight will be by Business Unit & Date. If that is the case, I'd most likely opt for a reference table with that...

Yes, what you are seeing is the aggregate value...which usually defaults to sum() for any measures. A better aggregate function to use for this measure would probably be average.

John Rowan (4/6/2016)

---

It really depends on whether the OP needs it as a measure or a dimension member. The original post made it sound like an extension on the...

John Rowan (4/6/2016)

---

These date values are in your dimension? I'm assuming you are OK with the Lead Time value being a dimension attribute? If so, replace your table...

timothy.tatum (3/15/2016)

---

Hello,

I am looking into automating my cube builds using SSIS and/or scripts and have a few questions.

1. I have a cube with yearly partitions and a Date Dim that...

The two sets are mutually exclusive, so even if a number would have been returned it would have been zero. Please share more about the structure of your cube as...

No, because you're changing the structure the dimension effectively needs to be rebuilt and cubes therefore reprocessed.

I don't believe that there is...there is only a DMV that returns the names of all the data sources in a database, but not specifics about the connection strings of...

The reason for the red line is because your Scope statement is incomplete. It should go away once you've added the rest of it.