Viewing 15 posts - 226 through 240 (of 1,839 total)
Hey mark,
Have you tried creating the calc measure first? And then using it (with it's default SUM rollup) in the subsequent calc member?
June 20, 2011 at 3:15 pm
SHowing my 'age' since reading the docs.... Back on 2000 and maybe 2005, the file share was a sample :hehe:
So, now in 2008, it's standard - doc here.
This should get...
June 2, 2011 at 2:24 pm
I *think* (ie i havent checked, so tkae with a grain of salt) that the guys at Pragmatic Works have a 'better' SCD component for SSIS. Could we worth...
June 2, 2011 at 2:16 pm
I think you're talking about a data driven SSRS subscription.... 🙂
June 2, 2011 at 1:15 pm
Yeah, basically that.
Design in SSRS, you can obviously test this easily in debug/dev mode. Publish to SSRS service and test.
It's been a while but 'back in the day', one...
June 2, 2011 at 1:06 pm
you should be able to do this with some out of the box SSRS functionality (ie from the URL it can be called to save a report to PDF; you...
June 2, 2011 at 12:50 pm
Hey Nico,
After reading this post (and your other) I would be leaning towards using an MDX Script within the cube definition itself to perform this. Using SCOPE statement/s and...
May 17, 2011 at 10:19 am
You mean having something called 'COL' on the rows doesn't make sense Ninja? aww, come-on....
May 13, 2011 at 8:36 am
Can't speak to the performance, but I tend to agree though - I could understand a 'datamart.' schema, where all of these related objects could live, but to have fact...
May 13, 2011 at 8:34 am
@Snap - keep in mind, with Attribute Hierarchies, these can represent independent views of the same data. To me the question here is, do you *absolutely* have to create...
May 12, 2011 at 11:57 am
I second the question re: why not use both facts (ie measure groups) in the one cube.
I also agree, the 'Used' or 'Active' flag on the dim table could simply...
May 12, 2011 at 11:51 am
yep, not supported out of the box. Apparently Cozyroc (spelling?) has an excel connector that supports this, but, thats 3rd party and costs (not sure how much) so it...
May 12, 2011 at 11:21 am
ROTFL you just couldn't leave it alone.... LOL
May 11, 2011 at 7:59 am
You may want to try the powershell script in this post. Or perhaps the cozyroc components (apparently, they support pwds on excel docs).
May 10, 2011 at 11:49 pm
The virtual server could be an issue, but not so much because it's virtual and more if it's not in a domain or a DC itself (not really recommended).
The last...
May 9, 2011 at 7:12 am
Viewing 15 posts - 226 through 240 (of 1,839 total)