Combining 2 calls



For our cube metadata we use the following 2 calls in a SSRS report:

CALL ASSP.DiscoverXmlMetadataFull("\Database\Cubes\Cube\CubePermissions\CubePermission")
CALL ASSP.DiscoverXmlMetadataFull("\Database\Roles\Role", "")

The first call (on Cubes) gives a RoleID that I would like to join with the RoleID in the second call (on Roles) so I can have one SSRS-report with all relevant cube permission info. Now I have 2 datasets in the report that I can't combine in SSRS, even not through a subreport or another action in SSRS. So if I can have just one dataset in the SSRS-report combining the two DLL-calls, than that would make my day.

Or is there another route to take?


Closed Oct 9, 2016 at 10:38 PM by dgosbell
No response to follow up question


dgosbell wrote Jul 7, 2016 at 11:15 AM

Why do you say that you can't combine the data sets using a subreport? This is what we did in the sample ASSP reports project that you can download from the sources tab.

wrote Oct 9, 2016 at 10:38 PM