It's been a while since I've had to do this, but from what I remember...as long as the first 2 cells of the first 2 rows contain data, Excel will...

I don't think the write-back option has anything to do with it. Found another interesting article though, which suggests that you should enable the "ProcessAffectedObjects" option if you only do...

ttdeveloper (3/6/2015)

---

Thanks Martin

Alvin also suggested I check the processing steps of the Cube. Not sure why only this one dimension will be affected out of the others during processing but...

I guess the point I was trying to get to, is to see whether the generated MDX is different for some reason when the dimension members are missing, as opposed...

That is pretty weird/interesting. I've seen some "interesting" behavior with Excel before...can you check to see what query is being executed against your cube?

I would also check the properties of...

To verify, are you using the Attunity Oracle connectors? Have you installed both the 32 and 64-bit versions on your SSIS machine?

winston Smith (3/4/2015)

---

I have one more scenario to expand this further:

SourceSystem has Persons of type Applicant and test scores for each applicant.

The persons would be pushed into MDS for...

Yes, MDS is your typical line-of-business application and used to store and maintain the current version of that entity. In your data warehouse, you would make use of type 2...

winston Smith (3/4/2015)

---

We are figuring what type of data constitutes master data for our organization. At present we are dealing with just one entity - Person.

A person can be an...

Ok...I think it makes a little more sense (to me) now.

I think a union will work in this case:

NONEMPTY

(

{

Filter

(

{

(

[Prospect Client].[Account Number].[Account Number].ALLMEMBERS *

[Prospect Client].[Account Name].[Account Name].ALLMEMBERS *

[Prospect...

faulknerwilliam2 (3/2/2015)

---

Hello

I have noticed with one of my reports, when I add weekdayname, that tomorrow's value appears.

I tested this by adding a textbox with =WeekdayName(weekday(Today())) in it. I have just...

scottcabral (3/3/2015)

---

Martin,

thanks for your help on this.

i changed the query to include the filtered set using the "OR" logic:

WITH MEMBER PREM AS

StrToMember("[Measures].[" + @PremiumType+ " Premium]")

SET FilteredBrokers AS

{STRTOSET('{[Broker].[Account Broker...

erics44 (3/3/2015)

---

Hi

I have written this MDX

select {[Date].[Calendar Year].[2014], [Date].[Calendar Year].[2015]} on columns

, [Holidays].[Start Date].members on rows

from Cube

and i get something like the following results (sorry i dont know how...

One of the options when...

erics44 (3/3/2015)

---

Hi

I have access to an analysis services database in management studio. Is it possible for me to open this as a project in BIDS?

Im brand new to SSAS...