Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  MDX as parameter to ASP page through 'Action'

Author  Topic  gayatri Starting Member 2 Posts Posted - 2004-10-19 : 06:10:18 I want to pass an MDX to an ASP page through the 'Action' functionality in the cube. Is it possible to do so? The result of my MDX is a recordset. The expression is Descendants([D].CurrentMember, [L1]) where 'D' is a dimension and 'L1' is a level in the dimension 'D'. When I try to pass this MDX to an asp page in the url of an action, I get an incorrect syntax error. Any suggestions? Thanks, Gayatri