Excellent video . . could you please help me understand that . .what is the advantage of a tabluar model here. . I mean to say that we already have the same structure in SQL server dB . .and the same relationship . Why we didn't prefer to use the sql serer DB itself for our analysis . . what is the exact use case need of analysis service here
A little late on this response here...but in addition to the other comment about performance, one major benefit of a cube is that it is intended to be designed to automatically understand relationships (think SQL joins) across multiple tables. Lets say you have a scenario where you want to show a measure (ex. a sum or count) sliced by a particular attribute (ex. customer, user, location, etc.). Using SQL in a typical relational DB, this may require multiple left/inner joins, where conditions, etc to get the result to display the way you want. However, using tabular cube, you can configure it through analysis services to understand how certain tables should relate (based on keys) and therefore it can automatically return this type of answer for you without any joins. You can simply drag and drop and the underlying engine does the equivalent of those SQL joins for you. Also, business users can connect to an Analysis Services cube through something like Microsoft Excel or Power BI. That means that business users who may not know SQL can easily interact with your data but it will be tightly controlled by you (the cube developer) based on how you manage the relationships, measure logic, visibility, etc. of the cube they are working with. Most of this happens in memory, which is a main reason why the performance is also really good. Hope this helps!
Hi Kahan, thank you for the video. May I ask you why you are calling it tabular cube? Tabular and cube are two diffrent technologies... thx for replying
Hello! I had a problem when I imported tables from SQL Server, the error said "Error returned: 'OLE DB or ODBC error: The credentials provided for the SQL source are invalid" Could you tell me How can I solve this? Thanks!!
@@KahanDataSolutions Thanks for your answer!! I tried with my database credentials and it worked! I will subscribe to your channel because your videos are really good. Keep it up!
It isn't really an either/or type of thing as they are often used together. SSAS is the underlying services for building tabular/multi-dimensional cubes. SSMS is the user interface program for looking at different objects, which may be Database Services objects (ex. databases, schemas, tables, data rows) and also Analysis Services objects (ex. cubes).
SA is the system admin account on what I pressume is SQL Server. It's created when you install SQL Server and only the DBA should have access to this account in a PRD environment.
►► The Starter Guide for Modern Data (Free PDF) → www.kahandatasolutions.com/startermds
Wonderful, quite apt
Thanks for watching!
Thanks this was so helpful!!
Exactly what I need, thank you mate!
Glad to help!
can you make a tutorial about dimensional modelling or data warehousing in general that would be great .Thanks in advance
Noted, thanks!
Nice video, concise and to the point.
Glad it was helpful!
Thanks
Excellent video . . could you please help me understand that . .what is the advantage of a tabluar model here. . I mean to say that we already have the same structure in SQL server dB . .and the same relationship . Why we didn't prefer to use the sql serer DB itself for our analysis . . what is the exact use case need of analysis service here
The advantage of using cube is large calculations are computed so fast . correct me if iam wrong
A little late on this response here...but in addition to the other comment about performance, one major benefit of a cube is that it is intended to be designed to automatically understand relationships (think SQL joins) across multiple tables.
Lets say you have a scenario where you want to show a measure (ex. a sum or count) sliced by a particular attribute (ex. customer, user, location, etc.). Using SQL in a typical relational DB, this may require multiple left/inner joins, where conditions, etc to get the result to display the way you want.
However, using tabular cube, you can configure it through analysis services to understand how certain tables should relate (based on keys) and therefore it can automatically return this type of answer for you without any joins. You can simply drag and drop and the underlying engine does the equivalent of those SQL joins for you.
Also, business users can connect to an Analysis Services cube through something like Microsoft Excel or Power BI. That means that business users who may not know SQL can easily interact with your data but it will be tightly controlled by you (the cube developer) based on how you manage the relationships, measure logic, visibility, etc. of the cube they are working with.
Most of this happens in memory, which is a main reason why the performance is also really good.
Hope this helps!
Perfect !
Thanks!
What version of visual studio do you have? I don't have a point "PostgreSQL database", when I configure Data Sources.. (
Hi
Can u pls let me know if u aware of , what is the use of the annotations in XMLA script, u will find these in XMLA script of Tabular Model?
Hi Kahan, thank you for the video. May I ask you why you are calling it tabular cube? Tabular and cube are two diffrent technologies... thx for replying
Hello how can I connect to the same server for practice?
Hello! I had a problem when I imported tables from SQL Server, the error said "Error returned: 'OLE DB or ODBC error: The credentials provided for the SQL source are invalid" Could you tell me How can I solve this? Thanks!!
Looks like a credentials issue, meaning the username/password you used are not correct. Make sure you do not have any typos.
@@KahanDataSolutions Thanks for your answer!! I tried with my database credentials and it worked! I will subscribe to your channel because your videos are really good. Keep it up!
Awesome! Thank you so much! Glad you find them helpful.
Hi! I cant see "new data source" by clicking on data source. Can you help me please?
I use SSMS ver 2019, I cant create Analys Service like you, and I cant install analys services from SQL Servcer Installer, how I can do ? plssss
Have you followed steps similar to what is in this video? ruclips.net/video/0GumDdUyvzo/видео.html
@@KahanDataSolutions yeah, it's working, tks you !
When is SSAS better than SSMS?
It isn't really an either/or type of thing as they are often used together.
SSAS is the underlying services for building tabular/multi-dimensional cubes.
SSMS is the user interface program for looking at different objects, which may be Database Services objects (ex. databases, schemas, tables, data rows) and also Analysis Services objects (ex. cubes).
well... from where do you know sa password?
This is a user that was created on the sever in a previous video (in this same playlist). You would have to create your own user.
SA is the system admin account on what I pressume is SQL Server. It's created when you install SQL Server and only the DBA should have access to this account in a PRD environment.