Viewing 15 posts - 1,996 through 2,010 (of 3,482 total)
You could always restore a read-only copy of your database and let your users connect to that... then at least the two databases would be separate... if you ran a...
March 23, 2016 at 3:40 pm
What if you change the formatting to some kind of decimal? If SSRS is rounding behind the scenes and the numbers are less than .5, then they may be rounding...
March 23, 2016 at 1:06 pm
Young Jedi,
A LEFT/RIGHT/OUTER join is "lossless". In other words, you'll get NULLs propagated on the "outside" table if you use an outer join. It's the way outer joins are...
March 23, 2016 at 12:38 pm
There are several options...
If they're already good at Excel, you might try either PowerPivot or PowerBI Desktop. I would lean toward PowerBI Desktop. If you have something like...
March 23, 2016 at 9:23 am
I need =Parameters!FundId.Value if this equals Fields!Fund_Name.Value than show =Parameters!FundId.Value
=IIF(Fields!Fund_Name.Value = Parameters!FundID.Value,Parameters!FundID.Value,NULL)
?
March 23, 2016 at 9:16 am
Since you're new, maybe this won't hurt... watching Grant Fritchey explain it and walk you through it...
March 22, 2016 at 11:09 pm
Probably the easiest way is to (temporarily) set those values as the defaults for the respective fields. If you want the same values tested over and over again, because...
March 22, 2016 at 6:26 pm
I'm not an expert on SSAS, so I can't answer that part, but PowerBI lets you build a quick star schema and start analyzing data immediately. SSAS can do...
March 21, 2016 at 5:54 pm
Hi,
this is close, but not quite right, I think... First off, since you're new, it would help those folks trying to help you if you could post your table...
March 21, 2016 at 10:00 am
Jeff,
Just wondering what you would say to an applicant that admitted up front that he may be underqualified, but asked you to help him figure out what he needed to...
March 20, 2016 at 11:46 am
I would start by reading this article: The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url]
March 19, 2016 at 12:29 pm
well, people on the US side of the pond might not know it...
March 19, 2016 at 9:28 am
Then honestly I'd leave it off. I don't think it's worth the space.
March 19, 2016 at 8:56 am
If, for some odd reason, you can have actuals records with no budget, and the reverse, then you would need a full outer join between the two tables, not an...
March 18, 2016 at 5:55 pm
Viewing 15 posts - 1,996 through 2,010 (of 3,482 total)