Answer Posted / mark
A surrogate key from a data warehouse schema is used to join
tables both in general SQL queries against the data
warehouse and for joining tables in the universe schema.
From 6.5.1, it can also be used as part of the keys tab
within object definition to improve query performance in
certain instances.
Given that it has no meaning outside of the data warehouse
technical sphere, it should not be created as an object.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain when we use aggregate awareness function in designer?
Can Bo generates the Report from the cubical data Explain?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Did you face any problems while creating reports? Name? Solutions?
When to use local filter and when to use global filter?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What three things do you consider to be the most important factors for a manager?
Explain what is the difference between slice and dice and cross tab report?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
how many reports have u created ? explain a few.
In banking domain how many Fact tables,Dimension table are present?
What is the difference in creating filters in designer and business objects?
