Data Warehouse - 16 - Creating SSAS Multidimensional Cube for Reporting

How to create SSAS Cube for Reporting? How to resolve errors in SSAS Cube?

[@JohnZyski]

Going throught the failures really helps explain the proccess.

[@MohamedIsmail-ps3sc]

Fantastic Video. it shows how to create a cube from start to end and also shows how to troubleshoot errors as well. Well done

[@Eldo_thomasbaby]

The purpose of creating an SSAS instance on top of a data warehouse is to enable efficient and flexible analysis of large amounts of data. SSAS provides a multidimensional view of the data, allowing users to slice and dice the data in various ways to gain insights and make informed business decisions. Bro this is the only video in Yutube with a use case example. Great job.

[@mrgogate]

thank you for the appreciation..

[@aleczanderwilliam8043]

Your videos have helped me a lot. Taught me SSAS

[@bmac8973]

Very good film, you show everything and explain how to manage problems, thank you!

[@mrgogate]

Thank you !!

[@olaoluwaabokede6654]

Thank you. I would classify this as debugging Cube creation 😇 Cheers

[@niteshsoni2282]

very nice sir

[@mohamedabdo-xg6tw]

just subscribed to your amazing channel. thank you for the valuable tutorial

[@mrgogate]

thank you!! and i am glad that the videos are helpful..

[@stone6326]

Hi, you've done great on this video! I wanna ask if you have dummy data for practicing?

[@rajsekharreddy4484]

Thanks a lot...

[@mrgogate]

you are welcome!

[@f3e6g4Qh4]

Hi, at 11:34 when you switched the authentication method which login details did you use? I tried creating a user in the security node in SSMS for SQL Server authentication and gave it sysadmin on the server roles but it dsnt seem to work...

[@mrgogate]

if it has SYSADMIN privileges, it should work.. can u plz tell what error u r getting?

[@f3e6g4Qh4]

@@mrgogate When I try and test the connection for the users I’ve created I get “Test connection failed because of an error in initializing the provider. I’ve tried creating multiple users with different names and logins just to be sure its not an issue with the login details I’m using, nothing seems to work…

[@mrgogate]

@@f3e6g4Qh4 are you able to connect normally to database using SSMS with those new users? not from SSAS..

[@user-wk5cz9ru2e]

I have an issue of deployement of cube .can you help me??

[@mrgogate]

what error you are getting?

[@Eldo_thomasbaby]

I only have one request. Kindly make a proper playlist covering all videos

[@mrgogate]

Sure I will try.. meanwhile you can refer.. github.com/magogate/DataWarehouse_And_Reporting#readme

[@mrgogate]

also, please subscribe :)

[@Eldo_thomasbaby]

Subscribed 👍

[@boutheynabiba3437]

what do u mean by "SSAS" ?

[@nickostrife]

SQL Server Analysis Service

[@chirukurisuryavaraprasad0679]

hi