You'll have to figure out your own relationships as I don't know your data. However, if there are two true relationships, then whether they intersect at some point or...

It is not only possible to set an attribute relationship without creating a user heirarchy, but creating a user heirarchy does nothing towards telling the SSAS engine about the relationships.

Not sure what you mean by you wish you could set the relationships for performace but make them invisible. You can set the attribute relationships to each other to...

I don't know if it's by design, but what you describe is the expected behavior in Excel. If you want to be able to bring in the attributes individually,...

Each attribute is a heirarchy. From a big picture, the name makes sense, though there are others who can explain that aspect better than me.

A lot of people turn those individual items off, but make sure your check with your users. You can always put those individual items in display folders so that...

I have told my children that "Family comes first, but not always." Sometimes work intrudes on the evenings and weekends and that's just the way it is.

Did you have to add it? My value is returning...

Doing it as a rename worked. I'm all for using code, but if a non-code solution will do, I'll use that instead. Thanks,

I'm really puzzled by this as that's exactly how I had it set up. The first two steps are still that way since w/o that the code wouldn't work...

Would you be able to send a snapshot of the appropriate tabs on your file task system. I would be very interested to see it.

Thanks,

@imz--I tried the task once again as I'm working on a project where I need to do that. Although the same variables that are used in the code are...

I can only tell you that it didn't work, and searching the internet made it clear that I wasn't alone. As I don't document processes that don't work, only...

You can actually simplify it even more if you like, by using a File System Task, instead of a Script Task to move your processed files once done. That way...

SSAS is meant to provide a way to quickly analyze aggregate data. I can't imagine a scenario where any person is doing an analysis and needs to look at a...