thx Jeff for your time.   Unfortunately the reports needing the data are operational.   So the data they need is pretty detailed.   So the volume is going to be a factor...

• This reply was modified 2 years ago by stan.

thx phil

thx Jeff, you are basically suggesting ETL loading data incrementally after reshaping into a star.   we actually talked about that but arent ready.  we do it in other business areas...

ssrs but i think we got it figured out.  thx

yes, now i can.   appreciated.  will try running one of (there's only one right now anyway) the pkgs from sql agent shortly.

thx Emperor100.  2022 under project->...properties->config->general .

i think i got it.  The path is /ssisdb/folder name/project name.       And in order to make everything fluid, you have to hit "connect" in the wizard next to...

apparently you right click the top left data cell, click insert and choose subreport.  Its pretty self explanatory from there .  In the dataset you bind to the tablix, one...

he wont have permissions but i think i'm liking your local host idea.  I have to check how big that db is.

Thx Brian.   He wont be updating.   I appreciate your response.   A sandbox is my next choice but i want to go down this path first.

...and I just pointed ssdt/ssrs to a 2016 tabular model and there is no assistance building dax.  Just mdx.  And nothing that looks like any improvement in 2016 when it...

I installed ssdt 2015 and went thru the steps one might follow to create a cube driven report over a 2012 tabular model.  I believe I am now simulating ssrs 2016...

Hi, I think now and then I'm guilty of these things.  What does "bump a post" mean?  I understand cross posting.

thx ssc guru.  I wont be able to install dev 2016 for quite a while because of the OS prereqs.  I'm on W7 now.  However,  I am taking steps to...

Thx Steve and pietlinden.  I already hooked power bi (pbi) up to the model directly and saw positive results both visually and performance wise.  I'm not a big fan of...