quote:

---

Seems like there is something missing from the question as the answers refer to do the above 1,2,3 and 4 then else....

Try giving the account MSOLAP runs under read access to the SQL server you need to connect to.

Keith Henry

DBA/Developer/BI Manager

Someone else had a similar problem here:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=19084&FORUM_ID=17&CAT_ID=3&Topic_Title=Analysis+Services+Crashes+with+large+Parent%2DChild&Forum_Title=Analysis+Services

Keith Henry

DBA/Developer/BI Manager

How are you processing the cube? In Analysis Manager or DTS or DSO etc. Are you using Windows NT security or SQL security on your source...

But this one has the correct date

Keith Henry

DBA/Developer/BI Manager

Why is the plan bad? Could you execute the following on each:

set showplan_text on

go

/* Your query here */

It can depend on the exact nature of the sub query, if you have a sort of some kind, for instance, it will completely change the query plan....

What SQL are you trying to execute and what on?

Keith Henry

DBA/Developer/BI Manager

Beginners should look at:

"Fast Track to MDX" ISBN: 1-852-33681-1

Good beginners stuff but lacking in detail.

More expirenced users will need:

"MDX...

Ah Ha, I thought, clever trick question with an answer most will pick that will remove the top 5% of their sales team. I pick the right...

select x.* from

#xx x

inner join (

Select Col2, Max(COl3) as 'mxCOl3' From #xx

Group By Col2 ) g

on ...

What do you mean? The statistics for an index could become out of sync if you did a large insert, update or delete in certain conditions. ...

quote:

---

I've worked at places where they've let trained (or untrained sometimes) end users use QA or tools like QA (depending on the...

Build the cube with a month dimension that you can total the change on that month.

Then either handle it in the client app or:

with

Not adversly. The answer to the question is technically right from a pure SQL point of view, but not from an application point of view. You're...