Hi manthangandhi - have you tried the Excel based Cube View Connections? It sounds a bit like you are trying to recreate that functionality. It will allow you to display a cube view while still prompting (or utilizing) the parameters within the report.
If that is not what you're after, you could do a button that pops-up a window with all the dimensions in a specific order. Users could then copy these dimension members and paste them into Excel. Its not fully automated, but might be satisfactory for your needs?
Cheers, -db
Edit: ignore all of the above! I missed that you want the selections as part of a table view. Table Views can also be setup to prompt for user provided parameters. You add the parameters to the SpreadsheetFunctionType.GetCustomSubstVarsInUse section, which can then be referenced in your queries. Reference: here
db_pdx i will try the approach mentioned in edit and get back. thanks
