This would be more of a client tool requirement than a server issue. The server itself is actually aware of what items have data and those that don't. ...

Yes, you can definitely do that - thought you were looking to add the (alt) calendar permanently to the dim.

Simplest way is to simply define a range, like (depending on...

Someone changed the database table that provides the data to the DSV? Check the metadata from the DB and compare it (field length) to the field defined in the...

Not sure Jason said you had to create a new table.... Just work with the different calendars (hierarchies) in that Dim.

Take a look at the official documentation...

Can you post just a small sample of the xml doc itself and also the xsd?

Out of interest, have you tried using something like IE to view the xml but...

Brandie, skip what I said (on both the fact as dim [ie degenrate dim] and M2M).

I go back to what I had suggested initially. To make this work, you're...

On looking back over what you've written, i think I get where you're headed and it sounds almost like this should be treated as a Fact, maybe with a dim...

I guess it's structural (in a way) but it's definitely a processing option - to ignore the missing key values (and the structural part is setting the dim to have/use...

So using your example, (assuming it's keyed on OrderID) your dimension *doesn't* contain all OrderID's that exist in the Fact? I guess you could let AS handle the unknown...

At first glance, I would say 'yes' you will. I would recommend you read over Marco Russo's great whitepaper on M2M dimensions in SSAS, it gives several examples of...

Have you tried accessing the document library through a UNC path? This sometimes has issues and I've tested only with Windows Explorer not anything else (eg SSIS, text...

Hey Brandy,

Did you check this KB article? If you get bored with it (it's a little dry to begin with) at least skip down to the 'Simplified Explanation' for...

I think you've maybe got to change your approach. RollNo would never be (IMHO) a measure. It's an attribute of the student and so should be an attribute...

You'll want to review the processing architecture/flow (link - it's 2005 specific but holds true for 2008) when doing this as a lot of people simply select 'Process Full' as...

Best guess would be that someone has added a WEEK function to your sql DB and SSAS is simply identifying it as a user function versus the built in functions...