Solution to Error: Excel 2007 generated MDX queries for multiselect in a pivot table's report filter

Excel 2007 generated MDX queries for multiselect in a pivot table's report filter

Hi all,
 
I'm having some issues with the queries that Excel 2007 generates in case of a multiselect in a report filter of a pivot table.
The setup is quite simple: we have our own MDX server (not SSAS) that contains a cube with a schema that can be reduced to the following:
 - 14 measures, including contributors.COUNT which is the one we are interested in
 - 6 dimensions, including the "Underlyings" dimension, with a level called UnderlierCurrency that contains members USD and EUR.
The Underlyings dimension also has an "AllMember" member.
 
Now, in my pivot table, I choose contributors.COUNT as the value, and I put "Underlyings" in the report filters, choosing to "Select multiple items" and only selecting EUR.
When I do that, Excel 2007 sends the following query to my server:
SELECT FROM [EquityDerivativesCube]
WHERE ([Measures].[contributors.COUNT],[Underlyings].[ALL].[AllMember].[EUR])
CELL PROPERTIES VALUE

That's perfectly good and works fine.
Now when I hit the refresh button, suddenly the query changes and my server receives the following:
 
WITH MEMBER [Underlyings].[XL_PT0] AS 'strtomember("[Underlyings].[ALL].[AllMember].[EUR]").UniqueName'
SELECT [Underlyings].[XL_PT0] ON 0
FROM [EquityDerivativesCube]
CELL PROPERTIES VALUE
This statement is now quite weird, and has no measures selected.
My server returns the correct answer with the default measure (named theta.SUM), but Excel doesn't seem to like it, and simply does not update the table (nor does it send any extra queries).
 
I have done the same experiment with Excel 2003, which always sends the first "correct" query and updates the table without any issues.
 
Does anybody have an idea of what might be going on, and what my server should reply to these weird query?
 
Thanks a lot!

Solutions to the Problem Excel 2007 generated MDX queries for multiselect in a pivot table's report filter

Download Error Fixer for Free Now

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Excel 2007 generated MDX queries for multiselect in a pivot table's report filter in Windows.

1. Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
2. Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
3. Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
4. Close the Command Prompt Window because we are done.

Try and see if you still get the same error Excel 2007 generated MDX queries for multiselect in a pivot table's report filter in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Another Safe way to Repair the Problem: Excel 2007 generated MDX queries for multiselect in a pivot table's report filter:

 

 

How to Fix Excel 2007 generated MDX queries for multiselect in a pivot table's report filter with SmartPCFixer?

1. Download SmartPCFixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed

Related: 2 GIG SD Cards and Windows 7 64 Bit Puzzler adobe reader doesn t work with ie8 in Windows 7 Home Premium Can t read pps powerpoint attachments from my Windows Mail Are there Windows 7 drivers for an Adaptec 2940U SCSI card Brightness won t adjust with Windows 8 1 BSOD Windows 8 help After automatic Windows Updates all pictures are blurry in Internet Explorer 9 Can you install flash on Windows CE7 to enable online flash games to play Action Center telling me to download 32 bit drivers when I am running 64 bit Windows 7 Catalyst Control Center Host application has stopped working Windows is checking for a solution to the problem when logged in to Windows Can t use the edit toolbar in Windows Live Movie Maker Custom created wallpaper in Vista loses resolution in Windows 7 Compatibility issue with Starz and Windows 7 64 bit Desktop Icons disappear when right clicking on desktop in Windows 7 After updating to Windows 8 1 receiving error code 0X80070002 and all of my apps stopped working Do I need the original Windows disks to use Virtual PC 2007,Can I Download Elgato Eye Tv3 Digital Receiver Since My Laptop Does Not Have A Cd Player?,Printer Problem After Win 7 SP1 Installed,HomeGroup Not Working Both Ways,MapPoint Microsoft 2011 Problems Working New Down Load Complete But Software Will Not Open And Work...running Windows 7,I Justed Randomly Start Getting The Blue Screen And I Cant Figure Out The Problem.,Tips On How To Decorate Your Apartment,Regular MBA vs Online MBA,A Review of the Google Assassin Google Adwords Course,Attempting to logon to windows7 home premium,Hard drive NTFS file structure error reported by Windows events.