Aggregate Awareness

[@mirkotartaglini9326]

thanks a lot naresh! it's been extremely clear and rich in details thru your popup tips!

[@NareshGanatra]

You are Welcome ! and Thanks for the comments -:) Regards, Naresh

[@mmahi2007]

Thank you Naresh It is really helpfull to me alot and its clear.

[@TheDror410]

Excellent. Looking forward to your next videos!

[@mmahi2007]

Thank you NAresh It is really helps me alot and its clear.

[@NareshGanatra]

Saad Tadili votre sont les bienvenus ! content que vous aimiez! (hope I got it right) You are welcome ! Glad that you liked it !

[@NareshGanatra]

Glad that it helped Mahendra ! Do not forget to rate the video -:) Regards, Naresh

[@itsme9287]

Thanks for the video Naresh..excellent one :)

[@cochinodos]

Excellent stuff, thank you!

[@NareshGanatra]

glad it helped !

[@mlnfb]

You're vids are really good and helpful. Thank you so much!

[@kaushalpandya9839]

Hi Naresh, Nice Video can you please explain little more about aggregate awareness and also @function.

[@fabriziovidarte]

Thanks for sharing this info dude. all the best

[@IgorSHCH]

Thanks a lot of this tutorial. Really helped me

[@rushisv8607]

Really informative Thank you dude

[@sampadakulkarni35]

Thank you so much Naresh... superb explaination.. Please upload more SAP Bobj tutorials if possible..

[@chandrashekharjaka9281]

Thank you Naresh!!! Nice video and we used to watch all your BO videos , its really useful for beginners. Could please post some more videos for @functions and agg_awarness.

[@NareshGanatra]

Thank You and yes, will try and do so ! Regards, Naresh

[@HelloThankYouDeNada]

Merci beaucoup, explication très claire.

[@NareshGanatra]

Thanks Murali ! 1st. DB level aggregation 2nd Projection Regards,

[@carlosroberto366]

Great explanation Naresh, I still had some doubts regarding Imcompatible Objects usage in AA, nevertheless, I believe things are clearer now. Thank you :D

[@NareshGanatra]

Thanks Roberto !

[@NareshGanatra]

Thanks Fab !

[@NareshGanatra]

Thanks Mirko !

[@shanmukhshan9780]

hi, in this video u used two tables orderheaders and orderlines, these are normal tables or agg tables?? my doubt is aggaware function is possible with both normal and agg tables (or) only normal tables

[@NareshGanatra]

late to reply..... the header table could be considered aggregate tables as it as a summed up measures....not sure if I follow what you mean by normal tables....but u can use agg aware as far as you have more than one table with one of them having aggregated values. hth

[@23kafu]

Thanks Naresh , I have been watching your videos to gain knowledge on BO 4.0 . Waiting for more :) I have a quick question here .Is there no means of automatically selecting the incompatible objects, because some classes may have plenty of objects ?

[@MrIrrepressible]

Can we create our own aggregate tables in the information design tool. For example if I have a fact table that list daily sales, can I create a Yearly aggregated sales table and then use that in the aggregate aware function.

[@NareshGanatra]

Hello there ! Long time no see (at least not since the SAP UFO-;)! Been ages since I looked at IDT, but let me see if memory serves me right .. in idt you can create a derived table .. but that would be mostly like crating a view and hence will not help a lot with performance improvement .. if you want to do it at the idt level then just the sum() or appropriate aggregate function .. if u want to create and aggregate table since current performance is not acceptable then creating and agg table at the db level would be the way to go and then use aggregate awareness in IDT ...hth

[@MrIrrepressible]

@@NareshGanatra Great thanks....btw....did you find out what that SAP UFO actually was? :)

[@NareshGanatra]

LOL...that was apparently Elon Musk UFO ....-;)

[@swathi24288]

Hi Naresh, Do you have any video on Prompt function applied at Designer level?

[@MuraliKrishna-tq3ij]

Superb Information... I have a question? when aggregation and projection both are applied which will effects first??