I have a grid showing sales by region. I put a filter allowing the user to select a salesman and the results are then filtered by this user.
The MDX hitting the server looks like this:
SELECT
{ [Measures].[Contribution] }
ON COLUMNS,
{ [IFA].[Peak Tier].[Peak Tier].ALLMEMBERS }
ON ROWS
FROM [QAP Sales]
WHERE ( [Account Manager].[Account Manager].[All] )
Now, I want to automate this. I want to take the name of the current logged in user and filter to that. (with or without the drop down on screen, at the moment I don't care)
I'm ok with getting the current user out of CustomData(), I just can't work out the rest, how to apply a custom filter, or custom MDX that will allow this to operate in.
Any ideas/pointers?