April 21, 2015
July 16, 2010
Hi Carolyn,
I wonder if it's a dependency issue e.g. if you have queries that reference each other and they all try to refresh at the same time it runs into issues. This might explain why you can refresh them one at a time, but not Refresh All.
Otherwise, I'm not sure. I haven't run into this problem myself before, sorry.
Mynda
Answers Post
April 21, 2015
Thanks Mynda,
I agree that it maybe a dependency issue. Especially since the file eventually refreshes and I get the desired results.
I'll finish up this version but when I have time, will redesign the structure of the fact files and eliminate the dependency.
If I find out anything more, I'll be sure to let you know.
Thanks again and have a great day!
The following users say thank you to Carolyn Rainaud for this useful post:
Mynda Treacy1 Guest(s)