in

Prologika Forums

Business Intelligence to the Masses
Latest post 02-26-2008 11:23 AM by tlachev. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-26-2008 10:42 AM

    • IRL11
    • Top 200 Contributor
    • Joined on 02-26-2008
    • Posts 1

    Listing 16.1 where you implement data-driven dynamic security with SSAS stored proceedures?

    I am trying to implement the security option discussed in Listing 16.1 where you implement data-driven dynamic security with SSAS stored proceedures.

    I have followed the example exactly as described and I've also referred to the Errata mentioned on this web site but I cannot manage to get the vb project to build the file.

     I am getting errors (underlines) under "Imports Microsoft.AnalysisServices.AdomdServer" saying Namespace or type specified in the Imports... doesn't contain any public member or cannot be found.

     I have installed the ADOMD.NET update from Microsofts website and it still doesn't work. I have tried this using both Visual Studio 2005 and 2008 with no success.

    The result of this is that I have the following errors:

    Error      2              Type 'Set' is not defined.              C:\...\Class1.vb 10           77           CubeFuncError      3              'New' cannot be used on a class that is declared 'MustInherit'.   C:\ ...\Class1.vb                27           38                CubeFuncError      4              Type 'SetBuilder' is not defined.                C:\ ...\Class1.vb                28           33           CubeFuncError      5              Type 'TupleBuilder' is not defined.           C:\ ...\Class1.vb                29           33           CubeFuncError      6              'ExpressionText' is not a member of 'System.Linq.Expressions.Expression'.          C:\ ...\Class1.vb                32                13           CubeFuncError      7              Type 'Member' is not defined.   C:\ ...\Class1.vb                33           27           CubeFunc

    If anyone can provide any help or support on this I would really appreciate it...

     Steve

    Filed under: , ,
  • 02-26-2008 11:23 AM In reply to

    Re: Listing 16.1 where you implement data-driven dynamic security with SSAS stored proceedures?

    Go to the project properties. Make sure you have references to:

    1. Microsoft.Analysis Services (c:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.AnalysisServices.dll).

    2. msmgdsrv (C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\OLAP\bin\msmgdsrv.dll)

    Also, make sure to enclose Set with square brackets, such as

    Public Shared Function ShowSet(ByVal inputSet As String) As [Set]

    You may also find the following article useful.

Page 1 of 1 (2 items)
Copyright © 2005 Prologika, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems