none
Powerview + Sharepoint 2010 + OLAP Cube + CU5 = Error

    Question

  • Hi,

    I just install a new sharepoint dev env.

    I apply the CU5 of SQL Server 2012 SP1

    I want to use the powerview tool in sharepoint to access my OLAP Cube.

    but I got this error using the SQL Profiler.

    Errors in the metadata manager. The current model can only be expressed when the client is requesting tabular view metadata with VERSION restriction of 2.0 or later.

    any idea why this error?

    is there something else to install on the servers?

    Tuesday, July 23, 2013 9:58 PM

Answers

  • ok guys

    I found the problem and the solution.

    I install the rss sharepoint addin on the front end server using the rsssharepoint.msi file, and not using the SQL Server installation process.

    Microsoft did not produce a new RSSharepoint.msi file for the CU4 and the CU5, but its included in the SQL Server CU5 installation file.

    So I just extract the rssharepoint.msi from the SQL Server sp1CU5, and install it on my front end server.

    and the problem is solved.

    so upgrading the back end server where SSRS is installed is not enough.

    • Marked as answer by Willgart1 Wednesday, July 24, 2013 3:50 PM
    Wednesday, July 24, 2013 3:50 PM

All replies

  • Hi Willgart1,

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

    Thank you for your understanding and support.

    If you have any feedback on our support, please click here.

    Best Regards,
    Bin Long


    Elvis Long
    TechNet Community Support

    Wednesday, July 24, 2013 11:32 AM
    Moderator
  • thanks.

    just to confirm... I'm trying to connect to an OLAP cube, not a tabular instance.

    and I'm using 3 servers: sharepoint front end, sharepoint backend with SSRS and the OLAP Server.

    the CU5 was installed on both the sharepoint back end server + olap server

    Wednesday, July 24, 2013 11:39 AM
  • additional info around my problem.

    I follow this to configure my connection:

    http://office.microsoft.com/en-us/excel-help/explore-the-adventure-works-multidimensional-model-by-using-power-view-HA104046830.aspx

    and second point connecting PowerView to my Tabular instance works perfectly. I just check this.

    (but still not solved)

    Wednesday, July 24, 2013 1:56 PM
  • well... sorry for all the posts... but I just do some tests. and the problem is when the system execute the following XMLA command:

    <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
     <RequestType>DISCOVER_CSDL_METADATA</RequestType>
     <Restrictions>
      <RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis">
       <CATALOG_NAME>Analytics2</CATALOG_NAME>
       <VERSION>1.1</VERSION>
      </RestrictionList>
     </Restrictions>
     <Properties>
      <PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis">
       <Catalog>Analytics2</Catalog>
       <Cube>Drug Claims</Cube>
       <Content>SchemaData</Content>
       <Format>Tabular</Format>
       <DbpropMsmdActivityID>1bed99a2-7bbf-4e2c-b22e-52518e3a8312</DbpropMsmdActivityID>
       <DbpropMsmdRequestID>bef37b6e-aa01-43da-a9ef-e3a4f8821307</DbpropMsmdRequestID>
      </PropertyList>
     </Properties>
    </Discover>

    the error is the one I received earlier:

    Errors in the metadata manager. The current model can only be expressed when the client is requesting tabular view metadata with VERSION restriction of 2.0 or later.

    if I change the version from 1.1 to 2.0, the XMLA command works perfectly.

    but I have no idea who push this version number in the command. is it a driver? a config in sharepoint? how to change this?

    Wednesday, July 24, 2013 2:06 PM
  • ok guys

    I found the problem and the solution.

    I install the rss sharepoint addin on the front end server using the rsssharepoint.msi file, and not using the SQL Server installation process.

    Microsoft did not produce a new RSSharepoint.msi file for the CU4 and the CU5, but its included in the SQL Server CU5 installation file.

    So I just extract the rssharepoint.msi from the SQL Server sp1CU5, and install it on my front end server.

    and the problem is solved.

    so upgrading the back end server where SSRS is installed is not enough.

    • Marked as answer by Willgart1 Wednesday, July 24, 2013 3:50 PM
    Wednesday, July 24, 2013 3:50 PM
  • Hello,

    If the problem is resolved, can you please mark this post as answered?

    Thanks.


    Meer Al - MSFT

    Wednesday, July 24, 2013 4:58 PM