can we create aliases for every table beforehand? if yes
whar are the disadvantages?
Answer Posted / kiran
There are no any disadvantages for creating aliases..it is
good practice in the projects to create aliases for all the
original db tables and create joins between them, rather
than using original db tables..when we do intigrity check
on this universe it throws all the errors that those
original tables have no joins ...this is the only problem
what I see, by creating aliases..
other then that aliases are used to resolve loops and traps.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain is data mart?
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
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain what are the steps to do to use alerts in bo?
What Is The Difference Between Oltp And Olap?
What is the difference between absolute and relative div positioning?
How to create Index to the table in the universe designer and how it improves the Query performence
What is the difference between business requirement document and use case document.
In banking domain how many Fact tables,Dimension table are present?
How to open a universe with out using the Designer ??
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?