Hi,

You can execute the stored procedure as following

exec [Linkedserver].databasename.dbo.usp_testing

I am getting problem inexecuting the query thro OPENQUERY

SELECT *

FROM OPENQUERY([Linkedserver],databasename.dbo.usp_testing)

So yOu can write a SQL Function Object on the top...

Hi,

I have updated the SP for Following

1. Looking for is_linked = 1

2. Exclude Offline databases and they may give problem

3. Use CHARINDEX function to search the procedure text.

Please test and...

Hi,

I found the naswer from Microsoft Portal:

ALTER CUBE CURRENTCUBE UPDATE DIMENSION Measures, DEFAULT_MEMBER=[Measures].[Profit]

This will set my calculated member as Default member...

Hi,

I am also facing similar problem while browsing the cube.

Please let me know if you have found any...