Hi James, for the first section where you add the column name for unpivot, how can we write it such that the column name comes from a table or a variable so that it becomes dynamic.
Hi james i am great fan of your teaching... could you please make a video on what are the conditions to blend two datasets in microstrategy document? Means is it enough to have one common attribute in two datasets or any other conditions.
I have 2 videos I created a while back on data blending that should help. th-cam.com/video/A8EWDlarzK0/w-d-xo.html and also th-cam.com/video/x5W7b7_tmEs/w-d-xo.html
Awesome video, thank you!
Great work here and thanks so much. This is very useful and helpful.
The best way to put it so far👍 Thanks
it works whether data is aggregate values or not. good way akso to create tall tables for some reasons.
Brilliant example and explanation Brother 😎
Brilliant…. Thank you
You are the man
Thank you!
that was clean
Hi James, for the first section where you add the column name for unpivot, how can we write it such that the column name comes from a table or a variable so that it becomes dynamic.
Hi james i am great fan of your teaching... could you please make a video on what are the conditions to blend two datasets in microstrategy document? Means is it enough to have one common attribute in two datasets or any other conditions.
I have 2 videos I created a while back on data blending that should help. th-cam.com/video/A8EWDlarzK0/w-d-xo.html and also th-cam.com/video/x5W7b7_tmEs/w-d-xo.html
Thanks but how can you have sales amount greater than the inventory amount
Thank you. Learning SQL on my own, is there a place to download large amounts of sample data?
CheCheSmith Yes install sql server express and then download the sample database AdventureWorks from Microsoft
Hi, James. For the first section of the video, you unpivoted. What if you want to add the results of that unpivoted data to another query?
If I understand you correctly, you should use CTE / WITH statements to do that
Great video! Thanks!
please post a video on Microstrategy dossiers in youtube or udemy by updating your course.thanks.
how can we know the original column name ? like SalesAmount and Week
🌟🌟🌟🌟🌟