Answer Posted / sampath kumar
Instead of Aggregated table we use the Derived table.
Aggregated table will be created by ETL people, for
summarized columns we use Aggregated table.
| Is This Answer Correct ? | 0 Yes | 9 No |
Post New Answer View All Answers
How to schedule the report in b.o?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Explain the data types present in bo and what happens if we implement view in the designer and report?
What are the steps to be taken to schedule the report?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
is it possible to export the webi reports to crystal reports?with out using businessview?
What is difference between custom hierarchy and report based hierarchy?
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
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
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?
What are the steps to do to use alerts in bo?
What is the profile and package?
How we drill up week to month?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...