1.what is exception aggregation?
2.difference between condition and filter
3.difference between direct update dso and write optimized
dso?
4.difference between repeat and repair process types?
5. disadvantage due to numeric pointer in generic
extraction?
Answer Posted / saripalli
1)exception aggregation use in Query designer.Ex:if want one Value Min, max,avg, stranded divination using this exception aggregation.Based on taking one reference info object then we create Min, max,avg, stranded divination in exception aggregation.
2)filter works on characteristics.Condition works on Key figures.
3)In Both DSO only one TABLE that is Active.write optimized:supports ETL(extraction, transforming and Loading)
direct update:it Doesn't support ETL only thought APD or ABAP program
4)We use this both options in process chain.
repeat:That terminated instant run again.
repair:The new instant creates and it will run this option available in SAP BI7.0
5)disadvantage due to numeric pointer:We change the existing record it is not able to track that is main disadvantage.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
List the steps you would take to create your dashboard in bw.
what are the extractions made in a sap bw project using lo cockpit extraction in mm and sd and fi?what is the requirement and name them?
What are the general restrictions?
What is persistence mode in cache?
What is a validity determining characteristic?
how the master data is read?
What are the minimum no of dimensions in info cube?
What is extended star schema? Which of the tables are inside and outside cube in an extended star schema?
what is direct schedule and what is meta chain
What is an infoobject and why it is used in sap bi?
what do you mean by transfer routines
Is it possible to create aggregates for cumulative?
I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
Hi, I need to know anything and everything abt datamarts and thier behaviours. Please suggest any links/whitepapers/articles which explain datamarts from scratch. This is required for my admin job at hand. Appreciate your help :)
what are the data types for the characteristics info object?