I have a very weird problem, in PPS dashboard designer I have created a simple data source against a SQL Server table that has only 1 column and 4 rows, the data source works perfect showing all the data.
Now when I create a member selection filter that uses the data source, after I select the dimension (the column in the table), in the Select Members only appears the first member not showing the other 3.
I create another data source against another SQL table and the result is the same, shows the first member only.
I have done this several times in other servers and allways work, now I am working in a brand new server and fails.
I am using SharePoint Enterprise 2010 and SQL Server 2008 R2