I'm new to Analysis services, and I need some help with what I'm fairly sure
is an easy process.

I've built a cube in analysis services and I would like to have users be
able to drill down to a company name, which at that point would have an
action associated with it, that will redirect users to a webpage, and pass
on the company id, so that the webpage opens up with that company
information.


How do I do this, or does anyone know where I can find a tutorial on this?

If you use AS 2005, go to Cube Designer and click Actions tab.

Click new action toolbar.
Select Level as Target type.
Select the Company Name level as Target Object

Select URL as Type.

Enter Action expression. For example,

"http://localhost/companyinfo?id=" +
[Company].[Company].CurrentMember.Properties("Key")

Finally, your client tool should support user interface to invoke this
action.

Ohjoo


"Wade" <wade.cormie (AT) thomson (DOT) com> wrote