[Passing Security Roles via XML/A to SSAS 2008 Cube]

Hi,

Has anyone successfully passed Security Roles via an XML/A connection to SSAS 2008 to restrict access to data within a Dimension e.g. based on customer Id.

I believe you can pass role(s) as part of the DataSource in the format:

Provider=MSOLAP;DataSource=localhost;Roles=Role1,Role2,Role3

I can successfully connect to a SSAS 2008 cube via my Analysis View but I currently don't have access to define Roles within the SSAS / the schema to test with, so am hoping someone else has done this before?

I'm using JasperServer 3.7.0 CE.

Thanks,

Michael

 

[jasperjpivot-ce-3.7.0 source code available?]

Hi,

I'm looking for the source for jasperjpivot-ce-3.7.0. The CE Source Build Guide documentation suggests it is available for download, but the latest version I can find is 3.0.

Can someone please direct me to it or confirm if / when it will become available.

Thanks,

Michael