thx Brian, that makes a lot of sense and we already nixed the idea of a laptop for other reasons.   But your reasons are better than ours.  We started talking...

thanks phil, do you mean all on the same single pc?   That's the kind of feedback i was hoping for.   That way no one instance of sql could interfere with...

thx, so those 2 selects are mdx.   i was able to run them right on the ssas instance without a linked server.  But i understand the value in having a...

• This reply was modified 1 year, 6 months ago by stan.

thank you chrissy321,

i read your link quickly and see if i have an mdx query, it would be sent native thru openquery probably via a new query from a db...

thx chrissy321.  Where would i run that?  in the engine on the same server where ssas is?  I dontg think t-sql ius a choice of language on the ssas instance. ...

thx lowell, by any chance do you also know how to get a list of members/groups from each role under a tabular model database?   I might have asked too  many...

thx Jeffrey, that was all laid out in the original post and i believe showed nothing was restricted at least palette wise.

But your answer gave me an idea that i...

hi jeffrey, by palette did you mean the tablix/subreport link on the master report?  If yes, i expanded that to cover the whole page and everything works.  let me kinow...

i systematically changed one thing at a time.  Eventually just running the sub report by itself after each change.  I'm convinced its the sub report creating the problem.  But after...

thanks frederice, deubel, jeffrey.

1.  frederico i've changed full vs incremental and sometimes the go to step when we need to skip.  No problem when using the client.   i believe when...

they arent only ssis Jeffrey but your points are still well taken.   All of our packages are versioned , in the catalog and at the moment set with some very...

apparently clearing means its gone unless you plan to reprocess.  its a catch 22.

for me right now this is ok because nobody uses the 1 gig cube anyway.

i'm guessing that...

• This reply was modified 1 year, 7 months ago by stan.

what i did in response to frederico's post was add a clear step on our 3rd cube prior to the dim table level sequenced refreshes (was step 1) and fact...

thx Jeffrey, i thought it was going to be something more sinister.  You hit it on the head.  Funny thing is because of configs each of the 3 pkgs that...

thx folks, but has anybody seen the unwanted byproduct of changing a step (eg different step to go to next etc) while right on the server?  I believe what is...