Viewing 15 posts - 256 through 270 (of 1,839 total)
Come on Lutz, isn't this jeopardy? 😀 The answer is like "If i was to paste a script to this forum, what would it look like?" LOL
April 6, 2011 at 1:49 pm
Excel definitely comes to mind. Most of the other major vendors (e.g. IBM Cognos, SAP BO) support querying SSAS cubes, so if you have these on hand, they should...
April 5, 2011 at 8:48 am
Glad it worked. On the book front, anything by Mosha Possumansky, George Spofford, Chris Webb would be good. If you're looking for a course, i know Brian Knight...
April 1, 2011 at 10:02 am
I agree totally on identifying the grain. The first thing I thought when reading this last week was you need a Transaction. Your case may be different, but...
March 29, 2011 at 10:32 am
Haven't used it but the following link is an (old-ish) ODBC handbook for it, so you may find some pointers there. The whole multivalue may be problematic if...
March 24, 2011 at 2:26 pm
Why not run the Profiler on SSAS when the package is executing - this iwll show you whether it's running in parallel or not.
I tend to agree with Koen, it...
March 23, 2011 at 9:05 am
Reminds me a little of that footer i've seen floating 'round here 'bout being able to explain when using 😀 (no offence intended guys).
The issue is that you've got...
March 23, 2011 at 12:06 am
Also, forgot to ask, why not use User!UserID ? (ie SSRS variable)
March 15, 2011 at 3:32 pm
Couple of things to look at... You could run profiler when accessing the report and see what user contex tis being used to pass the query to the server....
March 15, 2011 at 12:20 pm
Can you expand on what 'doesn't work' means to you? ie it doesn't return anything? it returns a name you don't expect?
One thing I would check is whether...
March 15, 2011 at 11:38 am
Oh, forgot to add - i'd be significantly more comfortable giving users direct DB access (with dbreader priv) than allowing xpcmdshell to be executed on the server. just my...
March 11, 2011 at 4:30 pm
Depends a little on how u implement this.
If you take on the work yourself, so, you'll need powerpivot (and optionally sharepoint 2010) and excel 2010. *You* download the data...
March 11, 2011 at 4:29 pm
Why not write up a quick asp.net/ asp (or any other quick and easy web dev language) page to collect the parameter and then pass it to SSIS to do...
March 11, 2011 at 3:01 pm
Maybe get them to download the PowerPivot addin, use Excel to grab the 90k rows, and then push it into powerpivot and get them using aggregated data. Over time, you...
March 11, 2011 at 2:31 pm
However, you need one dataflow per target table, and for 200+ that would be difficult (although not impossible) to maintain.
Maybe I missed it, but I didn't see the requirement to...
March 11, 2011 at 2:22 pm
Viewing 15 posts - 256 through 270 (of 1,839 total)