You also may need to click on the Test Cube Security link in the role to which you are assigned. This is not intuitive at all, but it seems...

For now, don't worry about solve order. Sometimes it's important, but probably not in this case.

Rather than send data, just set up your own front end with key metrics. If something is really wrong, my emails would show it. Otherwise I have an...

Are you presenting the data at start or the desired end state? If the latter, is the file ID part of the file name? Please provide more details.

What does AK stand for? Otherwise you and I create the names the same way.

I don't understand either. How do you differentiate between a skipped an unanswered? Is it all questions above the last answered?

Just because there are multiple possibilities does not invalidate the use of Nulls....

Not sure how I see how using Nulls violates data integrity. If your point is that if 0 is an appropriate value when there is not another valid data...

Apart from being limited to Type 1,2 and 3 The SSIS SCD component does not support Type 4 and 6...which I believe If the need arises The BI developer has...

The issue is when you would prefer one or the other, just a recognition of what applies and what you can do to help your users to recognize limitations. ...

These kinds of statements make me nervous. ...

You can use the topic options to subscribe to the topic w/o the requirement to...

I've use the COALESCE function to do what you've done, although I've only had to flatten one column. You may be able to use this. The code sample...

I have tried, otherwise I wouldn't ask. For all I have accomplished in SSIS, which is a lot, I have not been able to make it return useful error...

I would have preferred a more extensive answer. Could you provide a sample of how you would do what you are suggesting?