November 7, 2013 at 4:48 am
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.
November 7, 2013 at 10:09 am
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 š
November 7, 2013 at 11:51 pm
š 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