reporting services - Sharepoint RDL report referring a new cube in the SSAS DB fails to execute the query to a shared data source -


a shared data source, present in our sharepoint server, - works fine other old reports, refer old cube in same analysis services db. don't get, why new ssrs report using new cube in same initial catalog on same server not work exesting sharepoint data source.

at same time new report work, when run within visual studio on local pc , uses old shared data source there - same one, works other old reports in vs! tried load .rds data source file vs report designer sharepoint, not take .rds data source (sharepoint data source files has .rsds extantion , it's xml content differ in .rds bit).

what's wrong sharepoint mode new rdl referring new cube in same ssas db?

p.s.: here sharepoint's shared data source .rsds file content (no defenite cube mentioned, db name 'olap_fd'):

<?xml version="1.0" encoding="utf-8"?> <datasourcedefinition xmlns="http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource">   <extension>oledb-md</extension>   <connectstring>          data source=s-dwh-srv-01;          initial catalog=olap_fd;          integrated security=sspi;          persist security info=true;          mdx missing member mode=ignore;          sspropinitappname=report server;          roles=reader;          timeout=300   </connectstring>   <credentialretrieval>store</credentialretrieval>   <windowscredentials>true</windowscredentials>   <impersonateuser>false</impersonateuser>   <enabled>true</enabled> </datasourcedefinition> 

it's solved! college proposed switch on sql server profiler, ran report sharepoint again , profiler showed, sharepoint connectes ssas db 'reader' role , mistake 'unknown or unprocessed cube' rises. cube processed, checked it. went ssms, connected ssas db , checked permissions 'reader' role. set 'none' new cube sales_pipe! changed 'read'. after action ssrs report on sharepoint portal started work!


Comments