Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Link server Issue Expand / Collapse
Author
Message
Posted Thursday, November 7, 2013 4:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 4, 2013 2:36 AM
Points: 28, Visits: 78
Hello expert,
Can you please help me?
I have created the c# project VFE_AS_Functions to build the Like function to be used in MDX query and deployed the assembly under the assemblies folder of cube but I’m getting issue while accessing the query using Link server:
1) It displays result when we call this function under MDX query only

WITH 


set BradSet as [Shop].[Shop Model].[Brand].&[Brand1]

SELECT {
[Measures].[Stores2 Sales Quantity]
} ON COLUMNS,
NonEmpty(BradSet) ON ROWS
FROM Cube1
WHERE (
VFE_AS_Functions.Like(
NonEmpty([Articles].[A1].[A1],
(StrToMember("[Shop].[Shop Model].[Brand].&[Brand1]"),
[Measures].[Sales Quantity])),
"%",
[Articles].[A1].CURRENTMEMBER.MEMBER_CAPTION
)
)


2) But gives error while accesing query using Link server.
SELECT * from OPENQUERY(LinkServerName, 'WITH 

set BradSet as [Shop].[Shop Model].[Brand].&[Brand1]

SELECT {
[Measures].[Stores2 Sales Quantity]
} ON COLUMNS,
NonEmpty(BradSet) ON ROWS
FROM Cube1
WHERE (
VFE_AS_Functions.Like(
NonEmpty([Articles].[A1].[A1],
(StrToMember("[Shop].[Shop Model].[Brand].&[Brand1]"),
[Measures].[Sales Quantity])),
"%",
[Articles].[A1].CURRENTMEMBER.MEMBER_CAPTION
)
)')


I think this assembly information should be included in OLAP Link server... please help me... how to fix this issue.


Post #1512195
Posted Thursday, November 7, 2013 10:09 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 6:28 AM
Points: 608, Visits: 1,165
Hello again

I have to admit I don't have experience of this myself but I'd imagine it's something to do with permissions. Have a read of this article, paying attention to the section on security as it may provide an answer.

Either way, post back as I'm intrigued.....

Oh and check out the analysis services stored procedure project. It has a LIKE function and much much more





I'm on LinkedIn
Post #1512362
Posted Thursday, November 7, 2013 11:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 4, 2013 2:36 AM
Points: 28, Visits: 78
Thank you so much for your reply, get back to you on this.
Post #1512537
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse