There's not enough here to answer your question effectively. What is the end state that you want to be at?

I often test the steps by running them one at a time. In the BIDS environment, simply right click and choose Execute Task. If something goes wrong, I...

Try compiling each dimension seperately to see if any produces an error. If so, fix that dimension first.

Let me know how that works. If ALL the dimensions for...

View (like named queries) force you to draw the relationships yourself in MSAS. At the same time, they'll allow you to implement record filters (only display active records), limit the...

You don't explicitly say that the problem has been solved, but there doesn't seem to be a question in your comment. Would you please clarify if there's something further...

You will find this in the properties for the package and data pump task. See attached item for an example.

You don't say where you are trying to add this to or from. Assuming you are adding the item in the SSAS BIDS, and that the item exists in...

Your example is a transaction fact table. While I can see the advantages in this case for auditing, I'm not sure a data warehouse is the best place to...

I'll offer:

* Indexed views, when used with care, are an invaluable performance tool.

* Triggers are great to guard consistency, but only when standard constraints fall short.

* Cursors, though heavily overused...

You can build a cube with your metric being the count of students. Might be able to even get away with 1 as StudentCount as a column in your fact...

I have a time dimension that won't sort - I've set the dimesion to order by Attribute Key and specified the variable to sort on. The data are stored as...

its seems like the conformed dimensions. is much simpler on the developer, but no much on the end user? I am thinking more on the lines of accounting or sales...

It may not be a design issue. It sounds as if you are looking directly as the table design and not through SSAS. If that is the case,...

Try making the value you want to hide Null. If that doesn't work, I don't have another way. As I said, my experience is that it can be...

I don't wish to seem rude, but this isn't helpful, and...