Hi all,

within an SSAS project we are using an assembly to retrieve dimension
permissions based on data stored in a adminstration database.
Currently we store the connection string used to access in the
administration database within the assembly:
Dim locCon As New SqlConnection

....

locCon.ConnectionString = "data source=eira; database=ServiceAdmin;
Integrated Security=SSPI;"

....

Obviously this is not a nice solution. As I understand it is not possible to
access a application.config file from a DLL, because the DLL will use the
config file belonging to the corresponding application.

I wonder if it is not possible to access one of the data sources deployed
with the cube from the assembly.

somthing like:

locCon.ConnectionString = "data source=cubedatasource"

with cubedatasource beeing the name of the data source used in the cube

Well, it doesn't seem to work that way. Any help is appreciated

Thanks

bjh