locked
Local Cube Files RRS feed

  • Question

  • I'm listening to a tutorial because that's how I do and it's talking about local cube files. So far in my power pivot/dax journey I have not been exposed to such a thing. What is this exactly and where do I learn more about it? Grazie. 

    And what are analysis services? Thanks. 

    • Edited by AlexMartini Sunday, January 1, 2017 11:47 AM
    Sunday, January 1, 2017 11:46 AM

Answers

  • Hello Alex,

    We could say SSAS = SQL Server Analysis Services is the Server based Version of Power Pivot, where calculation and data Management/processing is done on the Server, not on your Client machine; see Analysis Services

    A local cube is a small copy of a cube to work with it in offline Modus = no Connection to SSAS required, see Local Cubes (Analysis Services - Multidimensional Data)


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, January 2, 2017 9:55 AM
  • Hi AlexMartini,

    Analysis Services is a built-in component of the Microsoft SQL Server software, and this applet uses files stored in the CUB format. Microsoft developed the CUB format as data files created and referenced by Analysis Services. Data schema details associated to the content of a CUB file are also stored in the corresponding CUB file. The PivotTable Service program is a component of the Microsoft SQL Server software, and it can be used to access the content of a CUB file. Please review this article to learn what is a cub file, and how to open it.

    If your OLAP database is large and you want the cube file to provide access to a large subset of the data, you will need to provide ample disk space, and you will find that saving the file may prove to be time consuming. To improve performance, consider creating the offline cube file by using an MDX script.

    After click the PivotTable report, then you can  create an offline cube file. More details about create an offline cube file from an OLAP server database, reconnect an offline cube file to an OLAP server database, refresh and recreate an offline cube file and so on. Please reference to the official documentation.  


    Best Regards,
    Angelia

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, January 3, 2017 7:10 AM

All replies

  • Hello Alex,

    We could say SSAS = SQL Server Analysis Services is the Server based Version of Power Pivot, where calculation and data Management/processing is done on the Server, not on your Client machine; see Analysis Services

    A local cube is a small copy of a cube to work with it in offline Modus = no Connection to SSAS required, see Local Cubes (Analysis Services - Multidimensional Data)


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, January 2, 2017 9:55 AM
  • Hi AlexMartini,

    Analysis Services is a built-in component of the Microsoft SQL Server software, and this applet uses files stored in the CUB format. Microsoft developed the CUB format as data files created and referenced by Analysis Services. Data schema details associated to the content of a CUB file are also stored in the corresponding CUB file. The PivotTable Service program is a component of the Microsoft SQL Server software, and it can be used to access the content of a CUB file. Please review this article to learn what is a cub file, and how to open it.

    If your OLAP database is large and you want the cube file to provide access to a large subset of the data, you will need to provide ample disk space, and you will find that saving the file may prove to be time consuming. To improve performance, consider creating the offline cube file by using an MDX script.

    After click the PivotTable report, then you can  create an offline cube file. More details about create an offline cube file from an OLAP server database, reconnect an offline cube file to an OLAP server database, refresh and recreate an offline cube file and so on. Please reference to the official documentation.  


    Best Regards,
    Angelia

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, January 3, 2017 7:10 AM