I have just Discovered that when creating a Crosstab Table in Anaylsis Grid while using ActiveSQL, does not conform to the "First Day Of Week" rule in _Settings, well at least for me.
I have run Analysis Grid, set date range using a week starting date of a Monday and set the End Date to a Saturday date, 4 week range for testing. Aggregate - sum, group by week, data looks good. However, when I add a Crosstab Table the start date is Saturday so i end up with a single day at the end of a chart.
I tested the same Analysis Grid using Datalayer and everything looks good. I also retested in another application both on my laptop and the server with the same results. Fellback to 14.1.051 and it looks OK.
Also I notice the date range for the last date cannot be set.
I wanted to confirm if anyone else see the same before opening a ticket.
Please sign in to leave a comment.