SSRS 2008 Data Driven Subscriptions to SSAS cube for retrieving Roles membership data
Hi,
I've digged deeply into the data driven subscription subject, but i'm facing problems.
I need to create an implemention for sending weekly automatic report, based on the cube Roles Members.
That subscription should send the report to relevant users\AD groups which are stored in Roles Membership.
Inside the Roles-Dimenssions Data an attribute security has been defined, in order to filter reports data for viewing.
How to direct the data driven subscription to retrieve that data from those Roles?
I'm trying to connect the DDS data source to the AS cube and it raises the error below
The CommandText field has a value that
is not valid. (rsInvalidElement)
I'm using SSRS & SSAS 2008, and would like to connect to SSAS data source. The reports are stored
on SharePointServer2010.
I will kindly appericiate your support.
June 22nd, 2011 9:51am
Hi zac139,
According to your description, you would like to retrieve the roles to data driven subscription, and error was appeared when connecting the DDS data source to the AS cube, right?
For the first question, there is no directly way to import roles data to subscription table, you need to import those roles data by writing T-SQL. For more information, please refer to the article:
Tutorial: Creating a Data-Driven Subscription
Is the DDS represent data driven subscriptions? Through the error message you have mentioned, I suspect that there may be some issue with connecting DDS data source to SSAS cube. Could you please tell us more details about how do you connect the DDS data source
to AS cube? And then, we could help you more effectively.
If you have any question, please feel free to ask.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 11:51am