Viewing 15 posts - 241 through 255 (of 260 total)
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...
February 18, 2024 at 1:51 pm
ssrs but i think we got it figured out. thx
February 16, 2024 at 6:31 pm
yes, now i can. appreciated. will try running one of (there's only one right now anyway) the pkgs from sql agent shortly.
January 31, 2024 at 9:29 pm
thx Emperor100. 2022 under project->...properties->config->general .
January 31, 2024 at 7:07 pm
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...
January 31, 2024 at 7:01 pm
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...
January 20, 2024 at 7:09 pm
he wont have permissions but i think i'm liking your local host idea. I have to check how big that db is.
January 19, 2024 at 3:40 pm
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.
January 19, 2024 at 2:08 pm
...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...
September 19, 2017 at 10:52 am
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...
September 19, 2017 at 7:40 am
Hi, I think now and then I'm guilty of these things. What does "bump a post" mean? I understand cross posting.
September 14, 2017 at 6:05 am
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...
September 14, 2017 at 5:50 am
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...
September 12, 2017 at 5:44 am
Thx Steve. All contributions are welcome. Below is a picture of the star. I am not committed to the star, tabular, ssrs, power bi, excel, tableau, column store index, multidimensional etc. I'm...
September 11, 2017 at 10:58 am
repairing (without uninstall) just vs2010 from the installer didnt do the trick. Back to the drawing board.
December 4, 2013 at 2:37 pm
Viewing 15 posts - 241 through 255 (of 260 total)