I'm getting a new error back from the Adobe Analytics connector 2.0. It says that the string was not recognized as a valid DateTime. The weird thing is that this happened to an existing report that...
Hi,
I'm using the Adobe Analytics 2.0 (Beta) data connection:
When I pull in the date, it pulls by year, month, day in separate columns, like below.
The mquery looks like this:
{Cube.ApplyParameter, "DateRange", {#date(2022, 6, 8), #date(2022, 6, 8)}},
{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"variables/daterangeyear", "variables/daterangemonth", "variables/daterangeday"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}},
This method has worked for more than a year and only just recently started prompting the error. I've tried it before and after an update. Other colleagues have had the same issue. This error pops up for existing connections when trying to refresh as well as when building a new connection as soon as I add a metric.