There is a Fact Table InternetSales as a Dimension option because Degenerate Dimension usa a column in a fact table as a source. In Define relationship select relation type as a Fact. Ex.Sales Order Details but It can add to the cube processing time and can result in slower queries
Thanks so much for putting this out there,very interesting for someone thinking about getting into SSAS! Again thanks very much, the world needs more Ludwig Armbrusters!
Ludwig, guten job man! well done! Excellent overview of what can be done with the standard tooling. Of course, now we have PowerPivot and wow!
Best
Jorge
MrCarilho 6 days ago
Nice share, thanks!
xiHebat 1 week ago
I'm not going to lie, this is pretty frickin' awesome. Excellent tutorial!
PatrickWard4 3 weeks ago
Great video ! \it was a pleasure to watch!
MrPaulbm100 2 months ago
thanks Mr Ambruster :) like your accent too
maddypaddy123 2 months ago
Good Job Ludwig. I liked all three videos... gives really a good introduction.
adugodishyju 4 months ago
Thank you for the tutorial- very nice job
jiv63 5 months ago
thanks for this tutorial. it is really a good starting training to SQL server Analysis Services.
Samira1579 5 months ago
i am unable to ssas,ssrs etc in the server dropdown in management studio....any idea why? thanks.
rashmik25 6 months ago
very nice .. Sir ... thanks for sharing me too ...
kisses from Brazil ..
bye ..
brsantoslu 9 months ago
very nice, gr8 job, Thanks for sharing
asimk73 10 months ago
Very nice Video serious.. Thank you so much for the nice introduction!!!
bassammagdy 11 months ago
Very nice job.
thefxpivotpoint 1 year ago
Great tutorial.... Now I clear how data cubes used in by business users using Excel
chautubesl 1 year ago
Thanks a lot. Been struggling a lot finding a good use for analysis services but can now see quite clearly how it all fits together in BIDS.
armitagedesu 1 year ago
thanks for awesome videos....i learnt alot
santhosh37 1 year ago
Excellent will like have more such SSAS Advanced videos
tinku1214 1 year ago
One of the neatest explanation of SSAS I have ever came through.Great job.
sachinyahoo 1 year ago
This was excellent. thanks a lot for posting it.
cpryr0 1 year ago
There is a Fact Table InternetSales as a Dimension option because Degenerate Dimension usa a column in a fact table as a source. In Define relationship select relation type as a Fact. Ex.Sales Order Details but It can add to the cube processing time and can result in slower queries
hardikabhavsar 2 years ago
Thanks so much for putting this out there,very interesting for someone thinking about getting into SSAS! Again thanks very much, the world needs more Ludwig Armbrusters!
LeeAntonyTaylor 2 years ago
Good job! Please, keep going with this series of educational videos.
That is the best I have seen so far!
Stopadjia 2 years ago