none
SSAS Tabular model RRS feed

  • Question

  • Hello. Can I create an SSAS tabular model on my own? Is it complicated? What's the difference between doing that and just grabbing from company databases? 
    Thursday, January 5, 2017 11:45 PM

Answers

  • Yes. You can either create it using Visual Studio or you can do it in Excel and then restore the model to SSAS from Excel. It is no more complicated than Excel other than you need VS and you need to learn the new UI. It is mostly the same, but there are lots of extras that can make it look complex. Grabbing from company DB? Well that depends on what your company DB is. SSAS is a tabular reporting DB. Someone has to make design decisions and build it. Your company DB could be a transactional DB and/or a relational DB or some other reporting DB. It depends.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Thursday, January 5, 2017 11:51 PM
    Answerer
  • Hi Albo44,

    Please find the following link to create your own SSAS tabular model... link.

    A major advantage of using SSAS tabular model instead of loading your company database or data warehouse into Excel is that you can store and share your DAX expressions centrally within your SSAS tabular model.

    You can then share a connection to your SSAS tabular model from multiple Excel files so you don't need to have multiple copies of your DAX expressions when you have multiple Excel files.

    You may also find the following link useful ... Import from Power Pivot (SSAS Tabular)

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Friday, January 6, 2017 4:47 PM

All replies

  • Yes. You can either create it using Visual Studio or you can do it in Excel and then restore the model to SSAS from Excel. It is no more complicated than Excel other than you need VS and you need to learn the new UI. It is mostly the same, but there are lots of extras that can make it look complex. Grabbing from company DB? Well that depends on what your company DB is. SSAS is a tabular reporting DB. Someone has to make design decisions and build it. Your company DB could be a transactional DB and/or a relational DB or some other reporting DB. It depends.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Thursday, January 5, 2017 11:51 PM
    Answerer
  • Hi Albo44,

    Please find the following link to create your own SSAS tabular model... link.

    A major advantage of using SSAS tabular model instead of loading your company database or data warehouse into Excel is that you can store and share your DAX expressions centrally within your SSAS tabular model.

    You can then share a connection to your SSAS tabular model from multiple Excel files so you don't need to have multiple copies of your DAX expressions when you have multiple Excel files.

    You may also find the following link useful ... Import from Power Pivot (SSAS Tabular)

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Friday, January 6, 2017 4:47 PM
  • Hi Matt. Thanks. Can I just build my own tabular report with data from a transactional database or a multidimensional database? I'm a newbie :) Excuse me. 
    Thursday, January 12, 2017 2:01 AM
  • Also is DAX studio the same as visual studio? What is visual studio and where can I learn about it? Thank you kindly. 
    Thursday, January 12, 2017 2:02 AM
  • Hi Matt. Thanks. Can I just build my own tabular report with data from a transactional database or a multidimensional database? I'm a newbie :) Excuse me. 

    Yes, you can use Visual Studio and/or SSDT

    https://msdn.microsoft.com/en-us/library/hh231689.aspx

    SSDT can be stand alone or a plugin to VS.  VS is a developer tool that can be used for may programing languages, including doing this work (when SSDT is loaded).



    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Friday, January 13, 2017 3:47 AM
    Answerer