Link server Issue

  • 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.

  • 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[/url]. It has a LIKE function and much much more šŸ™‚


    I'm on LinkedIn

  • šŸ™‚ Thank you so much for your reply, get back to you on this.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply