3.what is alias?
Answers were Sorted based on User's Feedback
Answer / nareshkumar
Aliases are references to existing tables in a schema. An
Alias is a table that is an exact duplicate of the original
table with a different name. The data in the table is
exactly the same as the original table. An alias breaks a
loop by using the same table twice in the same query for a
different purpose.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / g.v.subramanyam
alias is logical popint to alternate to the table name.this
can be used to resolve the loops.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / swades
An alias is a logical pointer to an alternate table name.
Exact copy of the original table.Establish a one-one join
between the original table and the table which is aliased.
The aggregatre results should be canned on to the aliased
table and not the original table.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vams_gk
alias is a logical table of existing look up table.using
alias we can resolve looops
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / raga
one user prefrom different roles is called alias
eg
two dept are there sales , HR
user of sales working in HR with different row is called
alias
| Is This Answer Correct ? | 0 Yes | 5 No |
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
Can Bo generates the reports from cubical data ? Explain?
What are the data types present in bo? What happens if we implement view in the designer and report?
how many user were there
how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
What is diff between InfoView and Zero BOAdmin (ZABO)?
What are templates? Explain what you have created?
How will you know the version of Bo using designer?
4 Answers Tavant Technologies,
Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace
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.
what is maximum scope of analysis --> can we define more than 3 levels?
What is a bo repository?