I have a very frustrating problem. I'm trying to make some very basic BI Dashboards on SharePoint 2013 using Dashboard Designer.

I have a cube that I've created in on SQL Server 2012 using BIDS. It builds/deploys/processes just fine and I can browse it in BIDS. When I add a new Data Connection in Dashboard Designer, I can connect to the cube using Secure Store and everything looks hunky-dory.

However, when I go to set the Time dimension, I run into an issue. I can pick my Time Dimension, but cannot browse the members to select a date. I get a pop error that says "Invalid parameters when querying for the child members of a member or dimension dashboard designer data connection time." If I ignore the Time dimension and just try to make a basic Analytic Grid, I can't browse anything there.

I'm working with SharePoint 2013 and SQL Server 2012. I've already install the SQL Server 2008 R2 AMO dll on the SharePoint server.

Any advice, or even where to look for what the problem might be, would be great, thanks.

Just want to verify a couple things, are you using SP1 of SQL 2012 and are you using a multidimensional cube?  Thanks.