SQL 2012 Power View for Multidimensional CTP

SQL 2012 Power View for Multidimensional CTP by Phil Seamark

Closed

as Fixed

Type:	Bug
ID:	774496
Opened:	12/16/2012 5:42:55 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

I have installed a clean instance of the SQL 2012 Power View for Multidimensional CTP and believe I have followed the instructions accordingly.

When I try to 'create a power view' report from a rsds file, I get an errosy that says the data extension type for my data source is not valie for this operation.

I am using SharePoint 2013.

If I create an rsds file against a Tabular model it works perfectly.

<detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsInvalidDataSourceType</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">The current action cannot be completed. The data extension type for data source 'http://fs-olapdev/sites/bi/Documents/MyMDX2.rsds' is not valid for this operation.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInvalidDataSourceType&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.9000.5</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">11.0.9000.5</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsInvalidDataSourceType" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInvalidDataSourceType&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.9000.5" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">The current action cannot be completed. The data extension type for data source 'http://fs-olapdev/sites/bi/Documents/MyMDX2.rsds' is not valid for this operation.</Message></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>

Details (expand)

English

private build - 11.0.9000.5

Reporting Services

Windows Server 2008 R2 Standard

English

create an rsds file in a sharepoint library and then 'create power view report'

<detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsInvalidDataSourceType</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">The current action cannot be completed. The data extension type for data source 'http://fs-olapdev/sites/bi/Documents/MyMDX2.rsds' is not valid for this operation.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInvalidDataSourceType&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.9000.5</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">11.0.9000.5</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsInvalidDataSourceType" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInvalidDataSourceType&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.9000.5" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">The current action cannot be completed. The data extension type for data source 'http://fs-olapdev/sites/bi/Documents/MyMDX2.rsds' is not valid for this operation.</Message></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>

No error, and the ability for power view to use an MDX cube

X64

0 attachments

Posted by Microsoft on 1/3/2013 at 1:23 PM

We will send you a link to a secure FTP site to which you can upload your database backup. It will be very useful to investigate this issue. Thank You.

Posted by Phil Seamark on 1/3/2013 at 11:45 AM

I can provide a backup of the cut down version of the cube (everything removed apart from the offending dimensions).

The backup file is still 150MB so not sure who/how to send this.

Posted by Microsoft on 12/30/2012 at 4:22 PM

Will it be easy for you to build some simplified repro of your particular problem? E.g. based on Adwenture Works.
Theoretically this shouldn't be an issue when you have dimension repeated in the cube, especially I wouldn't expect it to fail on the line in the code mentioned in the error message.

Another thought - does that dimension that you removed from the cube have less attributes than database dimension? How is it different (in structure) from the database dimension? Do you have any calc members on that dimension?

thanks

Posted by Phil Seamark on 12/27/2012 at 6:46 PM

I managed to figure it out. I have a MDX cube with 16 Dimensions. If I remove one particular dimension (found through trial and error), it works perfectly.

This dimension is joined to the Cube twice, so perhaps the CTP is tripping up on this fact. It's quite a large dimension.

I'm aware that Tabular models only allow single 'active' relationship between two tables, and I wonder if MDX models have the same restrictions for this.

Posted by Microsoft on 12/27/2012 at 6:34 PM

Hi Phil,

In order to understand the exact reason of failure we need metadata of your AS DB. Can you share it with us?

Posted by Phil Seamark on 12/20/2012 at 12:35 PM

The instructions I originally used for the data connection are from here

http://social.technet.microsoft.com/wiki/contents/articles/14703.create-a-shared-report-data-source-connection-to-a-multidimensional-model.aspx

Posted by Phil Seamark on 12/20/2012 at 10:12 AM

Oh and I was originally using a trial version of SharePoint 2013 but after I started from scratch I used SharePoint 2010 Enterprise (SP1) to see if it was because I was only using the trial key of SharePoint 2013

Posted by Phil Seamark on 12/20/2012 at 10:07 AM

Hi there, I changed to use the 'Microsoft BI Semantic Model for Power View' and now get a different error.

The error in PowerView is rsCannotRetrieveModel. The data source connection tests ok when I test it in the 'edit data source' mode.

If I run a trace against the Analysis services box I see the following error:

Internal error: An unexpected error occurred (file 'xlmodel.cpp', line 4383, function 'XLTableAttrPaths::InitOLAP').

This is all running on a clean install of Windows Server 2008 R2. A clean install of the SQL 2012 CTP Power View for multi dimensional. A clean install of SharePoint 2010 Enterprise.

There is no other software on the box.

Posted by Microsoft on 12/20/2012 at 7:51 AM

The datasources for both Tabular and Multidimensional models should use 'Microsoft BI Semantic Model for Power View' as their data source type.

Can you verify creating Power View reports works for you after changing the data source type?

Posted by Phil Seamark on 12/17/2012 at 11:59 AM

I choose "Microsoft SQL Server Analysis Services".

I have a second data source in the same environment that is set to "Microsoft BI Semantic Model for Power View" which is working against an instance of a Tabular cube I have on a Tabular instance. I only did this to see if I had Power View talking ok to reporting services.

On the "Microsoft SQL Server Analysis Services" rsds file, the test connection button works ok.

And if I misspell the datasource name, I get the above error. Almost like the reporting service engine is rejecting the Data Source Type first before moving on,.

Posted by Microsoft on 12/17/2012 at 10:47 AM

Hi Phil - what data source type is set in the properties of the rsds file(… > Edit Data Source Definition > Data Source Type)?