1.How is "Query drill" mode different from standard drill
mode?.
2.Under what circumstances are you most likely to choose to
use "Query drill" mode instead of standard query mode?.
3.How do you implement the type2 slowly changing dimensions
in your project?.
4.what is meant by Junk dimension?.
5.what is meant by Drill across?.
Answer Posted / alok
4.A junk dimension is grouping of low cardinality flags and indicators. Like for ex when some one processing a order .No all the information like prouct price order id these are important dimension . But if the information is like order place on phone or online, coupon applied or not . like that .
5. drill across directs the drill path to entirely different dimensions or reports across a spectrum of datasets.Like link to new Report . For one report
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
what will be the contents for a functional requirements specifications
Can we create universe with no cache??
What are the steps to be taken to schedule the report?
Explain when we use aggregate awareness function in designer?
Explain about a task that really tested your analytical abilities?
What is the difference between slice and dice and cross tab report?
Explain about a tricky situation for which you found a very simple solution?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
When to use local filter and when to use global filter?
Explain what are the steps to do to use alerts in bo?
How to execute the plsql procedure from the report by clicking with mouse?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain how to schedule the report in b.o?