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
Can Bo generates the Report from the cubical data Explain?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
how get the grand total in master-detail report?
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?
Can you please send me the migration related issues .
Difference between b.o 5.1 and 6.1b?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain which versions are used in the bo dashboard work?
How to restrict password to a user while sending a document in .pdf format
What is the difference in creating filters in designer and business objects?
Give some information on report bursting?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain what are the steps to do to use alerts in bo?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?