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, 6 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...

thx frederico.  you should have seen somewhere me saying clear didnt help.   Neither did doing table by table after the clear.  Neither did splitting the dim refreshes into one step...

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

what we saw before the processing started was ssas using about 10 gig for nothing specific that we know about.  I think that's where it is always at rest.  When...

thanks Ed.   Do you believe that 16 gig to be db sizes on disk or maybe total available (to ssas) ram?

Our 3 tabular model dbs total about 5 gig in...