Viewing 15 posts - 2,071 through 2,085 (of 3,489 total)
toggle the visibility by making it depend on an expression might be an option.
February 23, 2016 at 11:16 am
you can only filter a dataset as a whole, not just a matrix or whatever where you use the dataset. Unless there's something I've been overlooking all this time.
February 21, 2016 at 6:48 pm
One option might be SSIS to a new database? (then you can clean in between... in the SSIS pipe).
February 21, 2016 at 6:41 pm
it's a star schema. It's just normalized a different way. One relatively painless way into understanding some of star schemas is Rob Collie's book "DAX Formulas for Power...
February 19, 2016 at 10:51 am
Yup, I'm being stupid... figured it out... I had to select the formula for the Measure first!
(still kinda wish PowerBI Desktop acted just a little more like Excel!!!)
February 17, 2016 at 8:56 pm
You can use an FTP task in SSIS. You might want to look at Brian Knight's book. Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
It covers the basics...
February 17, 2016 at 4:12 pm
Steve,
you can add as many datasets to your report as you like... the caveat is that you can only use one dataset at a time in a single tablix/matrix.
If you...
February 15, 2016 at 3:47 pm
Once you create a dataset, you can convert it to a shared dataset. Shared datasets can be used in multiple reports, because they "belong to" the solution, not the...
February 15, 2016 at 11:53 am
February 14, 2016 at 6:52 am
If you want to learn PowerPivot, get Rob Collie's book. Takes a bit to get your head around, but he's really good at walking you through a lot of stuff....
February 12, 2016 at 6:39 pm
You could do this in PowerPivot... makes it really easy... You can use PowerBI, which is a free download too... if you can get someone to install it for you....
February 12, 2016 at 8:09 am
Instead of using a tablix, use a matrix. then put the date field in the columns part of the matrix and you should be off to the races.
February 11, 2016 at 12:51 pm
You have to join the two tables somehow
the INSERT INTO part is a bit of a red herring.
SELECT A.Field1, B.Field3
FROM A INNER JOIN B ON A.SomeKey = B.OtherKey
WHERE...
then you just...
February 10, 2016 at 2:10 pm
post the CREATE TABLE and INSERT scripts so we have some data to work with. what version of SQL Server are you using?
February 10, 2016 at 1:10 pm
Jason Selburg wrote an article with his code that does all this. without Enterprise edition. Probably worth a read.
HTH,
Pieter
February 10, 2016 at 1:04 pm
Viewing 15 posts - 2,071 through 2,085 (of 3,489 total)