The .abf file is a backup of the SSAS database. You can restore that to your SSAS...

Yes, because deploying from the Visual Studio solution means that...

What error message(s) are you getting? And did you change the data source and deployment properties to reflect your settings?

Does your expression currently work for one date value?

The MDX syntax for a date range is this: <date1> : <date2>

You should be able to use this in your CUBEVALUE function,...

I think your problem here is the .NET process identity, and that's why you're getting the "anonymous" login attempt details.

SSAS only works with Windows Authentication, so I'd check the...

I think it is vitally important to know how your end-user population...

Your scenario seems similar to a medical claims and patient diagnoses problem, where one medical claim could be related to more than one diagnosis and you would like to proportionally...

There are some third-party tools that claim to generate all of these things based on the metadata you supply. From what I've seen of those (my opinion only), making everything...

Brad Allison (11/10/2015)

---

I will need to check that tomorrow. That would be done at the DSV level, correct? I have a Date table that is being pulled in...

Steve Jones - SSC Editor (11/11/2015)

---

I thought about a future date. Using 2999/12/31 or something makes sense as well.

I've done it both ways. I guess as I think about it,...

Steve Jones - SSC Editor (11/10/2015)

---

All your queries need to look at dates if they span time. They should look at the begin and end dates, with the end date...

In addition to what you have said above, your customer dimension should also contain effective/termination dates and preferable a "current record" indicator.

The effective/termination dates should be used when populating your...

Just to clarify, I'm hoping that you've included the effective dates and current indicator in your dimension table...not your fact table. These attributes should then be used to determine the...

A scoped assignment seems appropriate in this scenario.

I would recommend a calculated measure which is set to zero/null first, and then updated with the relevant value and dimension scope....

To be fair to SSAS, you're not really using the snowflake in a typical fashion here. A snowflake is typically used to split out levels of a hierarchy (for instance...