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


Please Help Members By Posting Answers For Below Questions

When to use local filter and when to use global filter?

593


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

2597


Can anybody tell me what are the tuning problems?

1586


what is xcelsius architecture?

3736


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1619






How to restrict password to a user while sending a document in .pdf format

1852


Explain the data types present in bo and what happens if we implement view in the designer and report?

558


What is the functional & architectural differences between business objects and web intelligence reports?

553


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1812


How to execute the plsql procedure from the report by clicking with mouse?

613


What is thumbnail?

574


Explain how to execute the plsql procedure from the report by clicking with mouse?

594


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

543


how to create reports on screech?

2072


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4439