I have a bizarre one.... Ok here it goes. I have a report that is based on a cube. It has several different datasets. On two of the dataset the problem occurs. One of the datasets has fields listed in the report data window like: CM_PC_SCIP_Count CM_PC_SCIP__ MB_CM_PC_SCIP__ A whole bunch of fields but they follow the pattern above. When I open the dataset in the query designer and execute it, everything is fine. However, I switch to mdx mode and then change one of the parameter names and then go back in the code and adjust that name and then click ok, it goes into preparing the query just as it should. However, it takes a long time and when it finishes as if everything is good, a bizarre thing has occurred. Now in the Report Data window, all the fields excet the ones that end in _Count are now gone. So only a list of _Count fields remains. I am doing the exact same process with the other three datasets and no problems. But on two of the dataset this is happenning. These two dataset have the largest number of fields but not sure if that is relevant..... Strange that it strips all the fields other than the _Count ones... But if you then click to open the query designer on that dataset again, the other fields seem to still be in the mdx query even though they don't appear in the report data window. I sure don't want to have to manually add all these missing fields back in the dataset properties window....Any ideas?

There is no quarantee that you can go back to design mode from mdx mode. If you made a "safe" change to the generated query just go ahead (not back), make it into a data set and test it. Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 Grand Slam

I didn't go back to regular query mode..... The fields disappeared from my report data window which means it also disappeared from my dataset properties/fields list....

What if you run the MDX query in Management Studio? Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 Grand Slam

Here is the query: SELECT NON EMPTY { [Measures].[MB CM AMI 2 %], [Measures].[MB CM AMI 10 %], [Measures].[MB CM AMI 4 %], [Measures].[MB CM AMI 3 %], [Measures].[MB CM AMI 1 %], [Measures].[CM HF 4 Count], [Measures].[CM HF 4 %], [Measures].[CM PC AMI Count], [Measures].[CM PC AMI %], [Measures].[MB CM PN 2 %], [Measures].[MB CM HF 4 %], [Measures].[MB CM PN 3B %], [Measures].[MB CM PN 3A %], [Measures].[MB CM HF 3 %], [Measures].[MB CM AMI 8A %], [Measures].[MB CM AMI 5 %], [Measures].[MB CM HF 2 %], [Measures].[MB CM HF 1 %], [Measures].[CM HBIPS 5A Count], [Measures].[CM HBIPS 5A %], [Measures].[CM HBIPS 6A Count], [Measures].[CM HBIPS 6A %], [Measures].[CM HBIPS 4A Count], [Measures].[CM HBIPS 1A %], [Measures].[CM PCM 03 Count], [Measures].[CM HBIPS 4A %], [Measures].[CM HBIPS 1A Count], [Measures].[CM HF 2 %], [Measures].[CM HF 1 Count], [Measures].[CM HF 3 %], [Measures].[CM HF 2 Count], [Measures].[MB CM PC AMI %], [Measures].[CM HBIPS 7A Count], [Measures].[CM HBIPS 7A %], [Measures].[CM HF 1 %], [Measures].[CM AMI 8A Count], [Measures].[MB CM PCM 03 %], [Measures].[MB CM PCM 02 %], [Measures].[CM PC HF Count], [Measures].[CM PC HF %], [Measures].[MB CM PCM 01 %], [Measures].[MB CM VTE 6 %], [Measures].[MB CM VTE 5 %], [Measures].[MB CM PCB 05 %], [Measures].[MB CM PCB 04 %], [Measures].[MB CM HBIPS 5A %], [Measures].[MB CM HBIPS 4A %], [Measures].[MB CM HBIPS 7A %], [Measures].[MB CM HBIPS 6A %], [Measures].[MB CM HBIPS 1A %], [Measures].[MB CM PC PN %], [Measures].[MB CM PC HF %], [Measures].[CM PC PN Count], [Measures].[CM PC PN %], [Measures].[MB CM SCIP Inf 1A %], [Measures].[MB CM SCIP Inf 10 %], [Measures].[MB CM SCIP Inf 3A %], [Measures].[MB CM SCIP Inf 2A %], [Measures].[MB CM SCIP Card 2 %], [Measures].[MB CM PN 5C %], [Measures].[MB CM PN 4 %], [Measures].[MB CM PN 7 %], [Measures].[MB CM PN 6 %], [Measures].[MB CM VTE 1 %], [Measures].[MB CM SCIP VTE 2 %], [Measures].[MB CM VTE 4 %], [Measures].[MB CM VTE 2 %], [Measures].[MB CM SCIP VTE 1 %], [Measures].[MB CM SCIP Inf 4 %], [Measures].[MB CM VTE 3 %], [Measures].[MB CM SCIP Inf 9 %], [Measures].[MB CM SCIP Inf 6 %], [Measures].[CM AMI 1 %], [Measures].[CM AMI 1 Count], [Measures].[CM AMI 10 Count], [Measures].[CM AMI 10 %], [Measures].[MB CM PC SCIP %], [Measures].[CM SCIP VTE 1 Count], [Measures].[CM SCIP VTE 1 %], [Measures].[CM SCIP VTE 2 Count], [Measures].[CM SCIP VTE 2 %], [Measures].[CM AMI 5 %], [Measures].[CM AMI 4 Count], [Measures].[CM AMI 5 Count], [Measures].[CM HF 3 Count], [Measures].[CM AMI 4 %], [Measures].[CM AMI 2 Count], [Measures].[CM AMI 2 %], [Measures].[CM AMI 3 Count], [Measures].[CM AMI 3 %], [Measures].[CM SCIP Inf 1A %], [Measures].[CM SCIP Inf 10 Count], [Measures].[CM SCIP Inf 2A %], [Measures].[CM SCIP Inf 1A Count], [Measures].[CM SCIP Inf 10 %], [Measures].[CM PC SCIP Count], [Measures].[CM PC SCIP %], [Measures].[CM SCIP Card 2 Count], [Measures].[CM SCIP Card 2 %], [Measures].[CM SCIP Inf 6 Count], [Measures].[CM SCIP Inf 6 %], [Measures].[CM SCIP Inf 9 Count], [Measures].[CM SCIP Inf 9 %], [Measures].[CM SCIP Inf 4 Count], [Measures].[CM SCIP Inf 3A %], [Measures].[CM SCIP Inf 2A Count], [Measures].[CM SCIP Inf 4 %], [Measures].[CM SCIP Inf 3A Count], [Measures].[CM VTE 5 Count], [Measures].[CM VTE 5 %], [Measures].[CM VTE 6 Count], [Measures].[CM VTE 6 %], [Measures].[CM VTE 4 Count], [Measures].[CM VTE 3 %], [Measures].[CM VTE 2 Count], [Measures].[CM VTE 4 %], [Measures].[CM VTE 3 Count], [Measures].[CM PCM 02 %], [Measures].[CM PCM 01 Count], [Measures].[CM PCM 03 %], [Measures].[CM PCM 02 Count], [Measures].[CM PCM 01 %], [Measures].[CM PCB 04 Count], [Measures].[CM PCB 04 %], [Measures].[CM PCB 05 Count], [Measures].[CM PCB 05 %], [Measures].[CM PN 3B Count], [Measures].[CM PN 3B %], [Measures].[CM PN 4 Count], [Measures].[CM PN 4 %], [Measures].[CM PN 3A Count], [Measures].[CM PN 2 %], [Measures].[CM AMI 8A %], [Measures].[CM PN 3A %], [Measures].[CM PN 2 Count], [Measures].[CM VTE 1 %], [Measures].[CM PN 7 Count], [Measures].[CM VTE 2 %], [Measures].[CM VTE 1 Count], [Measures].[CM PN 7 %], [Measures].[CM PN 5C Count], [Measures].[CM PN 5C %], [Measures].[CM PN 6 Count], [Measures].[CM PN 6 %] } ON COLUMNS FROM ( SELECT ( { [Dim_Visit].[Visit Type].&[O] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DimLocationLocationDescription, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@AttPhysChairperson, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@Month, CONSTRAINED) ) ON COLUMNS FROM [Visit])))) WHERE ( IIF( STRTOSET(@Month, CONSTRAINED).Count = 1, STRTOSET(@Month, CONSTRAINED), [Date Dsch].[Month].currentmember ), IIF( STRTOSET(@AttPhysChairperson, CONSTRAINED).Count = 1, STRTOSET(@AttPhysChairperson, CONSTRAINED), [Att Phys].[Chairperson].currentmember ), IIF( STRTOSET(@DimLocationLocationDescription, CONSTRAINED).Count = 1, STRTOSET(@DimLocationLocationDescription, CONSTRAINED), [Dim_Location].[Location Description].currentmember ), [Dim_Visit].[Visit Type].&[O] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS After this query prepares.... all the measures other than the ones that have the word 'count' in them disappear from the report data window and are no longer there when you select dataset properties on that dataset and go to the fields tab.....

You can report it at Connect: https://connect.microsoft.com/SQLServer If you do, can you post the link here? Thanks. Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 Grand Slam

Anyone else have a possible answer?