Viewing 15 posts - 31 through 45 (of 123 total)
I had this same conversation last week about tabular models. The biggest problem I can think of with making a single view is when you need to alter the filter...
October 25, 2017 at 8:18 am
Are you running in Direct Query or In Memory mode?
October 23, 2017 at 1:29 pm
Try changing the relationship "Filter Direction" to two-way. This isn't necessarily the solution, but may help to troubleshoot the issue. In general, the way you have it set up is...
October 23, 2017 at 1:05 pm
I'm not following what the problem is. If you post your code for the measure, it may make it easier to see what's happening.
October 23, 2017 at 12:47 pm
This doesn't seem like something that requires a SUMX. Wouldn't the following give the same result? SUMX may give worse performance because it can use the formula engine instead of...
October 23, 2017 at 12:36 pm
The model looks straight forward. I'm not sure what you're doing as to why you'd need to use related. Are you creating a measure or writing a DAX query? Posting...
October 23, 2017 at 6:59 am
Yes to the donation amount question.
EventDate is the date dimension. I changed the name to be clear, since you can have more than one date dimension.
October 17, 2017 at 10:32 am
Also, the base measure:
Donation Amount := SUM(FactEvent[DonationAmount])
October 17, 2017 at 9:59 am
Here's some code I took from my current cube. I made a few changes to fit what I think you're looking for. I am rolling up the measure to year...
October 17, 2017 at 9:57 am
Also, the example for [PY Sales] is more difficult that needed in most scenarios. I use this instead:
[PY Sales] :=
SUMX (
VALUES ( 'Date'[YearMonthNumber] ),
...
October 17, 2017 at 9:29 am
Normally, I have the date in the fact table so I don't have any specific examples I can post. I don't think that it should be a problem that the...
October 17, 2017 at 9:22 am
It seems to me like this can be modeled with two dates - event date and donation date. Then the YoY calculation can be done in a normal fashion on...
October 17, 2017 at 8:28 am
In SQL Server, you can use SQL Profiler to determine what the failed permissions are. I think it's "User Error" event but not sure off the top of my head....
September 22, 2017 at 10:36 am
It sounds like a permissions issue in your source. When you deploy it you need to give the account that you've used permissions in the SQL Server database. This is...
September 21, 2017 at 6:15 am
Not sure if this is the cube processing or the source. Check the SSIS logs to see what the slow step or steps are.
September 18, 2017 at 11:32 am
Viewing 15 posts - 31 through 45 (of 123 total)