Forum Discussion
Google Analytics connector missing startdate/enddate parameters
We don't do aggregrations locally. All cube operations (Expand, filters, collapse) always results in a query that is 100% sent and run on the service. When you collapse a dimension, we simply don't request it in the query. This is why the date is gone in the second request you've posted. This is equivalent to not selecting a dimension attribute in MDX:
select {[Measure].[Users]} on 0,
filter([Date].[Date].[Date], <date filter>) on 1
from [GA]
Then when the date is collapsed, we issue:
select {[Measure].[Users]} on 0
from (select filter([Date].[Date].[Date], <date filter>) on 1
from [GA])
I tried the same query on our GA account and the issue doesn't reproduce. I get the same results if I aggregate locally using List.Sum over the column than if I collapse the date dimension attribute.
That being said, you seem savvy and I'm sure you've identified something. I'm very interested in getting to the bottom of this and I'll gladly setup a call.
Can you use the "Send-A-Frown" feature in Power BI to send feedback. It doesn't seem like these forums have direct message and I'd rather not post my email here. You can ask for "Tristan". :-)
Hi,
Since I can't reach you, how about you contact me.
chris AT activeinterface DOT com
Thanks,
Chris
intrasight, we narrowed the problem down. In summary, lifting the start/end date to a cube level parameter will address this problem.
Cool. A cube-level parameter is the only generic solution. I'm meeting with the client on Monday. Is there any guidance you can give on the timeframe of that update?
