Your videos are clear and crisp. I always watch them before any interview this gives me more confidence. Please posting such great videos on DWH concepts. Thank you for great content.

excellent explansiion sir

Hi Dhyaan, Can u please give an example of using @variable in free hand sql for webi report

What Is this BI tool you are using ?

Thank-you for this. Really easy to understand🙏 Request you to help us with a video on Context to resolve loops in Data Foundation in the similar manner by creating scenario.

Good explanation. Please complete this course

Thank you, very good explaination!

Loved this

is this architecture relevant for version 4.2 as well?

How we are fetching line item details then ? Where are we keeping line item IDs ?

at 5:00 shouldn't it be append instead of merge?

In our datawarehouse we use type 2 with processdate. This is the date when the data was entered into the table. This allows us to see historical snapshots of data. Which is useful when you are analyzing trends like balances. So you can see how balances change overtime.

thank you for such clear and nice explanation.

Very clearly explained, thank you

So what is the difference between BusinessObjectd, Crystal Reports & Webi??? I am new to SAP, do I need to learn all three or any one of then is enough to get started. I am a business analyst and have good hands on SQL and Power BI. From where should I start?

Why you are not doing videos on bo dude.

Can a periodic snapshot contains lowest level of granularity...In other words business wants to take a snapshot of the entire fact table on daily basis, so that on a particular day they want see all the relevant detail rows anytime possible..How to handle this.

Excellent 😊

Nice video man, thx a lot.

Straight and precise

Very clear and logical explanation, thanks!

hello. what is the role of the source dimension when editing merged dimension?

This is the best video on internet which talks about surrogate key

Thanks Guru. The best video on KZbin

Very well explained

What do you mean exactly by VIEWS? Please explain sir.

Really crystal clear explination thanks bro

Great explanation

Thanks for the detailed explanation. This is the best video I have seen till today

Excellent video. Thank you!

This is super helpful, and really awesome for last-minute interview preparations! Thanks!

Thanks it was helpful

Good Understanding of concept..Thankyou..

Where would sales by product fit in?

thank you for the video but what is the solution for a BO dashboard where user can edit the queries of report please ?

Very Nice Explanation. Thanks

it will be great if u also add an addition where,, u can show how to add a surrogate key from customer/ product dimension as well.

DD: Degenerate Dimension is a dimension key in the fact table that does not have its own dimension table. It's like primary key in relational DB table design kzbin.info/www/bejne/nWq2pHh_Zs6Va7c Junk Dimension: It's like Enum field in relational DB table design => we don't want keep them in Fact table so we put them in junk dimensions. Couple different columns will be put in one junk dimension kzbin.info/www/bejne/nWq2pHh_Zs6Va7c

Fabulous 😍

Nice

The way you cleared the concept. Hats off

Sir can you explain why should we create the universe in idt

Thanks, that explained a lot.

To the point!!

good job to summarise the concepts :)

Very difficult topic you have explained in simple words.. Thank you sir

nice

please make some more videos on SAP BO

Thank you very much. You are explaining in detail and can one understand easily

thank you so much!