Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

why we use aggregation in lower level

Answer Posted / shamanth

Aggregation will be defined at lowest level only, because
we can move/drill anytime from lowest-highest but viceversa
(highest-lowest) is not possible.

Defining aggregation at the lowest level is best practice
to improve performance.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1515


Explain how many universes can be created in a project?

1055


Can we Save (save as) WEBI Doc as DESKI?

8159


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3566


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6868


Can we configure two instances of CMS pointing to two different CMS system databases?

2027


What we need to discuss with designer before starting the universe designing.

2245


how to create reports on screech?

2547


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2391


Explain what is the difference between slice and dice and cross tab report?

1073


U r project in which stage in implementation?

2508


how many reports have u created ? explain a few.

2078


Explain what are the steps to do to use alerts in bo?

1074


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1941


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3071