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 / 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 |
how do u deceided to go create Aggregates for cube. what purpose u want to create aggregates?
Performance monitoring and analysis tools in bw
Can you tell something about the data ware-house hierarchy?
What is LSA architecture and use give me a business senario?
How to export a bex query itself?
Explain about cubes?
What are characteristics values?
Where you have to done cube testing?
how to display the date formats for example i hava a year like 2010 to 2011 bu i want to display in report like 2010-11 can u please explain this
List the steps you would take to create your dashboard in bw.
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
what are data tranformation in bw ?