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.
Great explanation Naresh, I still had some doubts regarding Imcompatible Objects usage in AA, nevertheless, I believe things are clearer now. Thank you :D
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 ?
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.
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
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
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
thanks a lot naresh!
it's been extremely clear and rich in details thru your popup tips!
Excellent.
Looking forward to your next videos!
Thank you Naresh It is really helpfull to me alot and its clear.
Thank you NAresh It is really helps me alot and its clear.
Thanks for sharing this info dude.
all the best
Thanks for the video Naresh..excellent one :)
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.
You're vids are really good and helpful. Thank you so much!
Really informative Thank you dude
Thanks a lot of this tutorial. Really helped me
You are Welcome ! and Thanks for the comments -:)
Regards,
Naresh
Excellent stuff, thank you!
glad it helped !
Great explanation Naresh, I still had some doubts regarding Imcompatible Objects usage in AA, nevertheless, I believe things are clearer now. Thank you :D
Hi Naresh,
Nice Video can you please explain little more about aggregate awareness and also @function.
Thank you so much Naresh... superb explaination..
Please upload more SAP Bobj tutorials if possible..
Merci beaucoup, explication très claire.
Thanks Murali !
1st. DB level aggregation
2nd Projection
Regards,
Superb Information...
I have a question? when aggregation and projection both are applied which will effects first??
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 ?
Thanks Roberto !
Glad that it helped Mahendra !
Do not forget to rate the video -:)
Regards,
Naresh
Thanks Fab !
Thanks Mirko !
Thank You and yes, will try and do so !
Regards,
Naresh
Saad Tadili votre sont les bienvenus !
content que vous aimiez!
(hope I got it right)
You are welcome !
Glad that you liked it !
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.
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
@@NareshGanatra Great thanks....btw....did you find out what that SAP UFO actually was? :)
LOL...that was apparently Elon Musk UFO ....-;)
Hi Naresh,
Do you have any video on Prompt function applied at Designer level?
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
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