none
the organization or content of the olap cube has been changed RRS feed

Answers

  • The link you're refering to is valid for PS2010. The cube management is still the same for PS2013, except that it has to be managed from the SharePoint Central Admin and not anymore from the PWA server settings.

    If you migrated following the Microsoft upgrade process, you should find in your new environment your custom fields and the OLAP DB configuration. The only step to perform after the migration is to change the OLAP DB configuration to point out on the new 2013 server.

    See reference here: 

    • http://technet.microsoft.com/en-us/library/ff465342(v=office.15).aspx
    • http://technet.microsoft.com/en-us/library/jj943761(v=office.15).aspx


    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Thursday, April 24, 2014 6:59 PM
    Moderator
  • As part of migration your custom fields would have been ported over and so the OLAP cube configuration, so something to check here...

    However if you think these fields are not in cube, navigate to OLAP cube configuration and add those fields to appropriate cube and rebuild the cube, and if your reports are pointing to correct connection, it should come up without any issues


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com

    Thursday, April 24, 2014 7:05 PM
    Moderator

All replies

  • Hi andres,

    Have you checked in the ODC connection properties in your Excel report that it points out to the right server and DB? When you open a sample report (out of the box reports) from the OLAP report folder, can you actually refresh the report?

    In case you can, just compare the connection string of both reports (the one migrated that doesn't work and the out-of-the-box one that should work).

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Thursday, April 24, 2014 5:15 PM
    Moderator
  •  this error message appears if the data connections pointing to cubes earlier are not able to obtain what is being queried, you mentioned you have already checked the connection, make sure to check if the queries or other things are not pointing to any custom fields which no longer exists in cube or try rebuilding another report and compare connection / fields in there with the existing and you would find the difference 


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com

    Thursday, April 24, 2014 5:18 PM
    Moderator
  • ok did that, it appears to have fields that do not longer exists in cube.

    I know this is out of the scope of my question but how this fields have been created on the cube?

    Thursday, April 24, 2014 6:28 PM
  • Hi Andres,

    This issue might actually be that your report refer to custom fields that do not exist in your new OLAP DB.


    Guillaume Rouyre - MBA, MCP, MCTS

    Thursday, April 24, 2014 6:31 PM
    Moderator
  • Ok I see that can be created throught PWA http://msdn.microsoft.com/en-us/library/office/ee767696%28v=office.14%29.aspx

    What is the oficial migration guide of this custom fields? just recreate them?

    Thursday, April 24, 2014 6:46 PM
  • The link you're refering to is valid for PS2010. The cube management is still the same for PS2013, except that it has to be managed from the SharePoint Central Admin and not anymore from the PWA server settings.

    If you migrated following the Microsoft upgrade process, you should find in your new environment your custom fields and the OLAP DB configuration. The only step to perform after the migration is to change the OLAP DB configuration to point out on the new 2013 server.

    See reference here: 

    • http://technet.microsoft.com/en-us/library/ff465342(v=office.15).aspx
    • http://technet.microsoft.com/en-us/library/jj943761(v=office.15).aspx


    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Thursday, April 24, 2014 6:59 PM
    Moderator
  • As part of migration your custom fields would have been ported over and so the OLAP cube configuration, so something to check here...

    However if you think these fields are not in cube, navigate to OLAP cube configuration and add those fields to appropriate cube and rebuild the cube, and if your reports are pointing to correct connection, it should come up without any issues


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com

    Thursday, April 24, 2014 7:05 PM
    Moderator
  • Recreated fields and voilá!
    Thursday, April 24, 2014 7:26 PM