Here are the values
Action : Url link to opportunity
Name: Url link to opportunity
Caption: Test ( checked Caption is MDX)
action type : url
Target type: Attribute Members
Target: [opportunity].[Oppotunity #]
Condition : (left blank)
Invocation : Interactive
Perspective : Checked one of the perspective : Opportunities
I have not used any table& column names yet in the expression, but for testing I just want action to take me to test website.
Yes are there are many perspectives in tabular model and In excel I am connected to one of the perspective : Opportunities.
In excel pivot, I connect to the perspective : Opportunities, then drop one of the measure and attribute member > Oppotunity #. Now right click on one of the values for Oppotunity # and in the context menu expecting to see > Additional Actions>Url
link to opportunity
Thanks. Pl let me know if you need any further information