Can any one tell me for business objects what we need to
study means some body tole me that we need DW,ETL,SQL.... is
this is necessary..?
Answers were Sorted based on User's Feedback
Hi,
If one must be an expert in Business Objects he need to have
the skills mentioned belwo :
- Oralce (sql)
- Datawarehouse Concepts
- Business Objects tools :
- Designer
- Desktop Intelligence
- Web Intelligence
- CMC
- Migration
- Report conversition tools
- Infoview
All these Business Object tools are the products
of the Business Objects which come with the product.
You can Study these guides as pdf documents you can prepare
completely the only thing is that you should get the
software of the Business Objects and Oracle 9i. if u need
any help more u can mail me jagadish_val@yahoo.com.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / chakri
BO is used as a reporting tool. if u want to generate
report u need to access database. oracle and teradata are
the two databases which are widley used. SQL is the only
way we can access data in databases.
we can get data from the legacy systems also, but the
historical data(huge in quantity)wont be there. so the
concept of dataware housing is used. to load data to
datawarehouse we need ETL tools.
wat i meant to say is if u want to get into BI ofcourse u
need to know the whole datewarehousing concepts (ri8 from
ETL to reporting). if not in depth, but the beginner level
of knowledge will help u a lot.
Is This Answer Correct ? | 1 Yes | 0 No |
WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
What is aggregate table and aggregate fact table ... Any examples of both?
Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?
How were the reports scheduled and how to resolve unexecuted documents?
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
How to create a report template BO XI R2
In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain what is aggregate table and aggregate fact table ... Any examples of both?